R
RJG
I need to keep a summary of our latest prices plus the previous price ,
so on sheet1 cell C5 is the previous price while cell D5 is the current
price.
I want these prices to update automatically whenever a price change
occures. Each time a price change occures the new price is added to row
16, currently the last price is X16 while the previous price is W16.
How do I get cell D5 to lookup the last item in row 16 and C5 to find
the last but one item in row 16.
With thanks
Bob
so on sheet1 cell C5 is the previous price while cell D5 is the current
price.
I want these prices to update automatically whenever a price change
occures. Each time a price change occures the new price is added to row
16, currently the last price is X16 while the previous price is W16.
How do I get cell D5 to lookup the last item in row 16 and C5 to find
the last but one item in row 16.
With thanks
Bob