Updating Names
 

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

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!

---
Regards,
Norman



"BLM" wrote in message
...
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

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.

Norman Jones wrote:

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!

---
Regards,
Norman

"BLM" wrote in message
...
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

--

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

BLM wrote:

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

--

Dave Peterson

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!

---
Regards,
Norman

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

Norman Jones wrote:

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!

---
Regards,
Norman

--

Dave Peterson