I
Ian
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...
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...