I have three columns, B, C and D. In B I would have ranges such as 1-5 6-10
and so on. In D I would have yes or now, paid or not paid. I would kind of
like it to be checked or not checked if possible. C must be something like
"if B is 1,2,3,4 or 5, then xxx and if D is yes or ...

According to Hector's reply to my earlier posting, I probably can't
edit macros in an old spreadsheet because they were created using
version 4.  Is there any way to get my hands on version 4 so I can edit
just a couple of macros, rather than having to recreate the entire

Suppose I've defined a few UDFs in my Excel workbook. What's the
difference between saving the workbook as a regular Excel vs an Excel
Add-in?
In both cases I can still use the UDFs, so what's the difference?

I wonder if this can be done.  I have spreadsheet that I want the data to be
exported into MS Access via a command button on the Excel spreadsheet.  I
only want the data to be appended to a table in MS Access 2003 not exporting
to a new table. Can this be done.  I don't know ...

for excel users, who are office employees, are you technically allowed to use
a user defined function -out of the Fx box- in your office workbook ? I need
it for statistics.

I need to have a macro run based on a cell value.  I have a "data
validation" drop down box.  (Not a form dropdown box.)
If drop down box is equal to NEW STORE PROJECT then run macro.
Here is the macro...

From:  learning_codes@hotmail.com - view profile
Date:  Thurs, Nov 16 2006 9:24 pm
Email:   "learning_co...@hotmail.com" <learning_co...@hotmail.com>
Groups:   microsoft.public.excel

I am having all kinds of strange things happen in my computer. It is
probably caused by the loose nut on the keyboard.
Anyway, my task bar no longer has the Right/Center/Left option and I
can't find it in the drop down arrows. I would like to have it back.

Quick syntax question:
is there a way to copy one colunn of a 2D array into excel directly and
vice versa? I.e. I have a 200*10VBA array, and I want to plug the value
of the 7th column into one Excel Column. Of course I don't want to

I have a worksheet that contains roughly 3000 rows of data for inventory.  
In column A is the list of names .  Most names are listed more than once
because people order more than one product. I used COUNTIF to get my totals
on another worksheet for total of orders per person.

I have a spreadsheet that was nicely formatted by a user whose values I need
to incorporate in  one of my MS Access reports.
Here is a sample layout of the excel file:
COLUMNS                   A        B        C        D        E

I posted to this group earlier but it hasn't shown up so I'm trying
again.
I need to update worksheet names that appear on the tabs when a new
workbook is created from a template I've created.

I have a spreadsheet that contains multiple photos. How can I copy one photo
and save it as a jpg file?

I have 2 worksheets containing data that I need to combine, by creating rows
WS1 has product data in the range of:
Product_ID     Name       price         Options_Ref
1                  Product 1    10.00       18

Is there any easier way to do this than repeating it 90 times?
conditional formatting:
if formula is-----
=and(E36="Yes",[this cell]=O9) then strikethrough