Hi all, just wondering if anyone has any ideas ( code or formula ) that can copy the value in a cell, say cell "a1" into the next available blank cell in column "B" every time the value in cell "A1" changes ?
"A1" is auto populated via a data (web) lookup every hour.
( spot gold price )
I can then graph the resulting data.
Thanks heaps