Thanks to an earlier reply I now have the first worksheet up and running
(thanks Gord and Bernd)
But what I would like to know is if there is a way of creating another 30
copies of the sheet in the same workbook, each named from names on another

I have a column of cells, some which have data (an amount of cash such as
£2.50) and some which have the symbol #NA because no data has yet been
entered.
What I would like to do is add up the column showing the total cash so far

I have a Pivot table that is dynamically linked to data, over time, the
filter data on the columns will become obsolete.  My question is how  do I
clear the invalid values?  PivotTable("tableName").PivotCache.Refresh()
doesn't seem to do it.

I am using the countif formula to count the  Xs in each column -  
What I really want is a total that counts the Xs in a column and then
multiplies that count by a number, i.e.:
Column Q x 1, Column R x 2, Column S x 3, Column T x 4, etc.

I am the new treasurer and statustician for a billiards pool league and I
have to make up all of the programs myself.  I haven't a clue as to how to do
this the easiest way.  Any suggestions?  Thank you in advance.

there are two columns.
the first column is the key column, and the second one is the value column.
I want to conditional-format the rows which is the same key with
different values.

Anyone knows how to protect a Range of specific cell/s

I have a Pivot Table that shows Total Columns at the far right end of the
table.  I would like to move those columns to the beginning of the table, the
far left.  Does anybody know how to rearrange the columns in a Pivot Table?
Thanks,

You open an Excel 2003 Workbook and the sheet tabs are not visible. They are
not hidden. The display area seems to cut them off. You can move between
sheets using Ctrl+PageDown but that's a pain. Is there a short-cut key for
the size handles ? Or some other way to deal with sheets ...

Can someone point me to which function to use to ascertain the following
If a cell contains 1 then I would like the results cell to show 20% of yet
another cell
                        2 then I would like the results cell to show 10% of

I need to know how to protect a range of cell/s in a workbook

I need to know how to protect a range of cell/s in a workbook

Hi to all,
I have VB code to print Arabic words in cell H20 depending on the value in
cel J20. It works fine on my computer.
When I copy the file to another computer The Arabic text does not apear! In

I have a spreadsheet that I need to be to email, but Symantec's anti-virus
software won't let it go through.
I looked in the VB Editor and there was a module but it didn't have any
code, just a header and footer so I deleted it, but it still wont go...

I have a spreadsheet with 23 columns and 361 rows. I am looking to see if I
can use HLOOKUP to show me the lowest price in columns G-K-P. The other
columns have different data in them. Is there a way to use HLOOKUP or
something else to do this?