Linked cells from master data sheet and sorting
Hi
Provide you mark your complete block of data on master sheet before
carrying out the sort, then the data will remain attached to the correct
person.
--
Regards
Roger Govier
"merrittr" wrote in message
ups.com...
I have a maser work sheet with names alphabetically ordered. as well
these names are linked to worksheets based on departments
abarham---------hr worksheet a1
anderson--------it worksheet a2
billings -----------hr worksheet b2
.
.
.
zintel ----------it worksheet a1
now if i add a new employee at the bottom and sort the master data
everything gets shiffted is there anyway to get changes to the master
worksheet to update the child worksheets?
vba /macro
|