| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Associating data across worksheets from an inventory that's sorted
Hi guys, new to all this so please be patient!!
I have an inventory worksheet which is used as base data. This inventory is sorted using 2 cols. The data within the inventory is populated to other worksheets to using this formula =inventory!$k$52 The problem I'm having is when the inventory is re sort and the above data that was in K52 above moves to say K55, I would like the other worksheet to track the data rather than the cell. Can this be done...I hope so...thanks to anyone who helps me out... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
