Data between tabs


I have a number of sheets for pricing a product we produce, so in sheet 1 I place the purchase price of all the items we buy then sheet 2 I select the items in sheet 1 I want to include in the pricing of a certain product.
When I copy across the data it is fine but then if I alter sheet 1 by inserting new lines, doing a data sort by a different column it messes up my pricing in sheet 2 as it does not change the formula along with the changes made to sheet 1.

Any ideas on this?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!