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