Linked cells from master data sheet and sorting
 

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

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

Linked cells from master data sheet and sorting
 

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

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