Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorted Linked data doesnt stay together
Example: My workbook has two sheets:
Sheet One: Contains typed employee names in Col A. Col B is a pasted link from a column in Sheet Two. Sheet Two: Col A is a mirror of Col A in Sheet One. It contains pasted links from the names in Sheet One. In Sheet Two, Cols B-M (labeled Jan-Dec) contain hours worked in each month, followed by Col N which is the sum of Col B-M. The sum in Col N in Sheet Two links to Col B of Sheet One. Heres the problem: When I add a name to the list in Sheet One, then sort, the name list in Sheet Two sorts OK, but the hours do not stay with the original name. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll wheel doesn´t work in excel 2007 | Excel Discussion (Misc queries) | |||
Scroll wheel doesn´t work in excel 2007 | Excel Discussion (Misc queries) | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
Excel-rolling data linked to chart & worksheet columns must stay | Charts and Charting in Excel |