Forum Discussion

rs2020's avatar
rs2020
Copper Contributor
Apr 06, 2018

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
March 2 - 50
March 3 - 200
March 4 - 200
March 5 - 100


Right now I do this step by step using copy-paste. It's too difficult.

Please help me - how to do this using some Paste special or Function.

Thanks in advance!

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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    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

Resources