Updating Names

[Guest]

Hi,
I have several worksheets which contain the same names but different info.
I want to be able to add and delete names in one source file which will
update the
other worksheets, sort in alphabetical order and keep the same data in all
the worksheets linked to the right name.
Thanks

 

[Norman Jones]

Hi BLM;

Jan Karel Pieters's Name Manager add-in, freely downloadable at:

http://www.jkp-ads.com/Download.htm

Might well reduce a lot of the manipulation pain - and it is well worth
having anyway!

 

[Dave Peterson]

I think that BLM really meant names (John Q. Smith, not workbook names).

But Jan Karel Pieterse's (note spelling <vbg>) is a very nice addin to have for
workbook names.

 

[Dave Peterson]

This is possible, but it can go awry very quickly.

I would think that it would be macro based (event changes) and if macros were
disabled or even just events disabled, then you'd soon fall out of sync.

And if you made a typing error, you may lose data that you didn't want to lose!

I like to keep my data in one spot and then use Data|filter|Autofilter to
show/hide the stuff I want.

You may want to look at View|custom views, too.

And if you're really serious about having separate worksheets, I'd use a macro
to split the data--but it would be on demand. I'd run that macro when I was
sure I was ready. (I'd give up on the update automatically version.)

If you think you like the "on demand" suggestion, Debra Dalgleish has some
sample workbooks that do this kind of thing.

Maybe you can steal some code from here:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

 

[Norman Jones]

Hi Dave,

I think that BLM really meant names (John Q. Smith, not workbook names).

Re-reading BLM's post (through your eyes) I am sure that you are right.

But Jan Karel Pieterse's (note spelling <vbg>)

I never make spelling errors - I just wish my fingers had comparable
spelling ability!

 

[Dave Peterson]

I blame the keyboard. They seem to keep moving the letters from where they used
to be!