Linking to specific cells in a changing table. How to Index?
 

Try using the Vlookup function on the other sheets. Refer
the range to the your sheet. Once the data on your sheet
changes the other sheets will change as well. You don't
need to sort the data.

Hope this helps...

Chong Moua

-----Original Message-----
I have a worksheet which contains prices and other data
which are constantly updating with new values.

On any given line I will have a column which contains the
prices, and on each line will be other data which doesn't
change, such as an item description.

From time to time, the lines will be added to, or
removed, as certain items become active or are removed
from the table.

The price data is provided to me from a table I copy off
of a web page and I have no control over the order in
which the prices are given to me, but the data on each
line is constant enough to allow me to match it, through
sorting to the data in my worksheet.

For example, I would have something like:

Name, Number, HiPrice, lowPrice, closeprice
on each line. By doing a sort, I can match up the data
in my worksheet to that which I import.

What I need to do is find some way in which I can refer
to the data in my sheet on other sheets so that when I
update the data on the PriceSheet, I will have the data
on the other sheets also updated with the correct values.

I've thought of doing a lookup but the order of the lines
is changing due to sorting so unless I check to make sure
the sort order hasn't changed I can't be sure the values
will remain the same in the linked sheets.

How can I fix this? Is there a seek or find function
which doesn't need the data to be in ascending order
inorder to find a unique cell?
.