Naming and creating worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry Limey - 26 Aug 2007 22:52 GMT

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!

Reply to this Message

Barb Reinhardt - 26 Aug 2007 23:56 GMT

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?

> Thanks to an earlier reply I now have the first worksheet up and running
> (thanks Gord and Bernd)
[quoted text clipped - 9 lines]
>
> Hope someone can help!

Reply to this Message

Harry Limey - 27 Aug 2007 06:49 GMT

> You could conditional format the #NA cells so that the font color is the
> same
[quoted text clipped - 4 lines]
> want
> to copy the worksheets programmatically?

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!!

Reply to this Message

Barb Reinhardt - 27 Aug 2007 15:20 GMT

Right click on the sheet tab that you want to copy and copy it.

> > You could conditional format the #NA cells so that the font color is the
> > same
[quoted text clipped - 8 lines]
> 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!!

Reply to this Message

Melissa - 27 Aug 2007 18:56 GMT

> And one other little thing!
>
[quoted text clipped - 3 lines]
>
> Hope someone can help!

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.

Reply to this Message

Harry Limey - 27 Aug 2007 20:32 GMT

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!

>> And one other little thing!
>>
[quoted text clipped - 11 lines]
> have this used in a worksheet that is set up waiting for data updates
> through the end of the year.

Reply to this Message