Naming and creating worksheets

H

Harry Limey

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
spreadsheet (the names of society members!!)

And one other little thing!

When the sheet has only the formulae and no data it is full of #NA entries!
is there a way to ask Excel not to display anything in those cells until
data is added?

Hope someone can help!
 
B

Barb Reinhardt

You could conditional format the #NA cells so that the font color is the same
as the background color. The only problem with that is that users may
inadvertently overwrite the cells if unprotected.

Get the original sheet working as you want before you copy it. Do you want
to copy the worksheets programmatically?
 
H

Harry Limey

Barb Reinhardt said:
You could conditional format the #NA cells so that the font color is the
same
as the background color. The only problem with that is that users may
inadvertently overwrite the cells if unprotected.

Get the original sheet working as you want before you copy it. Do you
want
to copy the worksheets programmatically?
Click to expand...

programmatically? Not sure quite what that means! But what I am hoping to
do is copy the sheet I have created with the formulae and headings and no
actual data, and if possible with a different name on each new sheet!!
 
M

Melissa

And one other little thing!

When the sheet has only the formulae and no data it is full of #NA entries!
is there a way to ask Excel not to display anything in those cells until
data is added?

Hope someone can help!
Click to expand...

This is how I've learned to do it:

=IF(ISERROR(J7/J$13),"",(J7/J$13)) That way, if there's an error, it
returns a null value to the field and no results are displayed. I
have this used in a worksheet that is set up waiting for data updates
through the end of the year.
 
H

Harry Limey

Thanks Melissa, I used a solution very similar to yours and the problem was
solved!
But I have saved your words in case they are needed later!
 
Top