I have a problem trying to keep my list of names up-to-date across several
spreadsheets. I had a list of names defined in a master spreadsheet.
Everytime I made a new Excel file I copied a dummy sheet from the master file
to the new file so that all the names became visible in the new file. I hope
you understand what I'm trying to say!

BUt now whenever I add a new name to "master" it (obviously) doesnt show up
in the daughter sheets until I manually copy the dummy sheet to the daughter
sheet again. Is there a way to automate this? i.e. define names in only a
central location and have them show up in all new sheets I make?

Thanks!

-Rahul

If your list isn't too long, use a formula in the new sheet that simply says
A1 = "Sheet Original" A1 Simple: type = then click on original page and
select A1 on the original. Touch Enter.
You now have 1 formula in new sheet. Copy this formula down as far as you
need in column A, adding enough rows for future names to be added. Each time
you add a name, it wqill appear in all sheets where you have this formula.

Hope this is what you want. If not, explain further.

Rahul wrote:
I have a problem trying to keep my list of names up-to-date across several
spreadsheets. I had a list of names defined in a master spreadsheet.
Everytime I made a new Excel file I copied a dummy sheet from the master file
to the new file so that all the names became visible in the new file. I hope
you understand what I'm trying to say!

BUt now whenever I add a new name to "master" it (obviously) doesnt show up
in the daughter sheets until I manually copy the dummy sheet to the daughter
sheet again. Is there a way to automate this? i.e. define names in only a
central location and have them show up in all new sheets I make?

Thanks!

-Rahul

--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1

Thanks! That is one option but how do I get those names defined dynamically?
Usually I go to Insert-- Name-- Define each time I want a new name.

Even if I have a formula in a sheet how do I get that defined as a name?(in
the daughter sheet)

-Rahul

"Launchnet via OfficeKB.com" wrote:

If your list isn't too long, use a formula in the new sheet that simply says
A1 = "Sheet Original" A1 Simple: type = then click on original page and
select A1 on the original. Touch Enter.
You now have 1 formula in new sheet. Copy this formula down as far as you
need in column A, adding enough rows for future names to be added. Each time
you add a name, it wqill appear in all sheets where you have this formula.

Hope this is what you want. If not, explain further.

Rahul wrote:
I have a problem trying to keep my list of names up-to-date across several
spreadsheets. I had a list of names defined in a master spreadsheet.
Everytime I made a new Excel file I copied a dummy sheet from the master file
to the new file so that all the names became visible in the new file. I hope
you understand what I'm trying to say!

BUt now whenever I add a new name to "master" it (obviously) doesnt show up
in the daughter sheets until I manually copy the dummy sheet to the daughter
sheet again. Is there a way to automate this? i.e. define names in only a
central location and have them show up in all new sheets I make?

Thanks!

-Rahul

--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1

Sorry, I understood your 1st message to say that if you had the name John
Brown in cell A1 on your master list, you then wanted to add a new sheet and
have the name John Brown automatically appear in cell A1 on the new sheet.
The same would happen for Sue Jones in cell A2.

Is this what you want?

Rahul wrote:
Thanks! That is one option but how do I get those names defined dynamically?
Usually I go to Insert-- Name-- Define each time I want a new name.

Even if I have a formula in a sheet how do I get that defined as a name?(in
the daughter sheet)

-Rahul

If your list isn't too long, use a formula in the new sheet that simply says
A1 = "Sheet Original" A1 Simple: type = then click on original page and
[quoted text clipped - 19 lines]

-Rahul

--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1