Naming and creating worksheets

  • Thread starter Thread starter Harry Limey
  • Start date Start date
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!
 
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?
 
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!!
 
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.
 
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!
 
Back
Top