View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David_in_AUS
 
Posts: n/a
Default Look up a value which position changes.


Hi.

I was wondering if someone could help.

I have an automated report which list trades and then totals them at
the bottom.

The number of trades changes daily, so the cell with the total figure I
need changes daily too. Is there anyway to import this figure using its
relative position. It is always 2 cells to the right of the 'Grand
total' cell.

Many thanks.


--
David_in_AUS
------------------------------------------------------------------------
David_in_AUS's Profile: http://www.excelforum.com/member.php...o&userid=35359
View this thread: http://www.excelforum.com/showthread...hreadid=551304