Links between worksheets

[Guest]

Might be an issue that has been covered a million times before, but still
gonna ask once more...

Can I somehow link values between different worksheets, so that when I
change information (add lines etc) in the source worksheet, the information
on the 'result' worksheet would refer to the right cell?

Example:
I have a price list on first worksheet, to this 'page' I keep adding
information, row etc. On the first page the producs are in alphabetical
order. On the second worksheet these same products are in different order
(sometimes with different names), under subtitles or similar and the prices
are fetched from the first worksheet, so that when I change the price in the
first spreadsheet, it automatically updates to the second, third, fourth...
list? Currently what happens to my lists is that the cells refer to wrong row
(=price) if I have added items to my alphabetical list.... Is there something
I can do to fix this?

thx

 

[Guest]

There are a number of possibilities to investigate:

1) Use named ranges
2) Use VLOOKUP or MATCH to associate a value in a cell on one sheet with its
corresponding cell in another sheet
3) Streamline the design of your workbook so that you do not have
duplicative data within the workbook.

Dave