Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells with changing format | Excel Discussion (Misc queries) | |||
changing table cells colours using a master table | Excel Discussion (Misc queries) | |||
Linking a specific x/y position in a table | Excel Discussion (Misc queries) | |||
Changing Tabs to Specific Cells | Excel Discussion (Misc queries) | |||
Linking changing values (cells) between worksheets. | Excel Worksheet Functions |