Linked cells from master data sheet and sorting
If the data on your master sheet is in A1:C1000 mark the whole range of
A1:C1000 then carry out the sort based on column A.
Any data in columns B and C will move in correspondence with any move of
the data in column A.
--
Regards
Roger Govier
"merrittr" wrote in message
oups.com...
what do you mean by mark my complete block? I not sure technically
wgat
to do
Roger Govier wrote:
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
|