| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem created by sorting linked sheet | Excel Discussion (Misc queries) | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| Sorting data in a master sheet | Excel Worksheet Functions | |||
| use data on master worksheet for sorting | New Users to Excel | |||
Linear Mode
