Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data on one sheet, linked to another, but staying the same
A colleague of mine is putting together a large spreadsheet of customer
parts. "Worksheet A" calculates a price for each part based on many variables. "Worksheet B" contains a list of some of these parts, which make up asseblies. Two cells from "Worksheet A" are linked to "Worksheet B". If "Worksheet A" is sorted the data in "Worksheet B" is no longer correct. Is there a way to sort "Worksheet A" and the data in "Worksheet B" stay the same or follow the data? The link has to be maintained between the two because the data in "Worksheet A" changes frequently and it needs to adjuston "Worksheet B" Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells from master data sheet and sorting | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
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 |