i have a sheet related to stock market where the rates change everyday.
now the cell value at B2 changes everyday and i have to manually copy the VALUE of the cell to the cell right below the active cell in a column. the same goes for 2 more cells ie E2 & H2.
Is there a way that when the cell value changes in B2,E2 and H2 , it automatically copies the value of the cell right below the last active cell .(i have marked the cells to copy with yellow and where to paste the values with green)
thnx
Bookmarks