Hi all,
I have a series of prices A2-A11,
these prices will be updated automatically by an additional macro,
what I'd like to do is record the updated price in the cell to it's right, and repeat time & time again,
if the price has not changed since the previous, I'd like it to list that same price.
Sheet attached:
Any help would be much appreciated,
Thank you in advance,
Chad
Bookmarks