Forum Discussion

rs2020's avatar
rs2020
Copper Contributor
Apr 06, 2018
Solved

Excel

Hi! I've got a problem in Excel. I need to make Tab A into Tab B in 3 or 5 clicks.   Tab A March 5 - 100 March 4 - 200 March 3 - 200 March 2 - 50 March 1 - 100   Tab B March 1 - 100 ...
excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 06, 2018

    Hi,

     

    Supposing that the Tab A is in range A1:A5, you can start this formula in any other cell and drag it down:

    =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0)

    After that, you can get rid of the formulas by copying them then paste them as values only.

     

    Hope that helps

    Haytham