Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just ran into a snag. In my workbook I have 4 Quarterly Project tabs and 1
Summary tab to consoildate project status throughout the year. I am using Paste Link to the Summary tab from each of the Quarterly Project tabs, however, if we use the Data Sort feature on any one of the Quarterly Project tabs to view the data sorted by a different column, (i.e., Organization, Status, Project Lead), it completely messing up the Summary page. Is there anything that I can use to prevent this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Value used in a Paste Link to remain constant during a sort | Excel Discussion (Misc queries) | |||
Cell reference value to remain constant in a sort using Paste Link | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |