Results 1 to 2 of 2

Thread: Copying the Data in reverse by using Formula/Paste Special

  1. #1

    Copying the Data in reverse by using Formula/Paste Special

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Friends,

    I request you all kindly let me know while doing paste special whether we can copy the data in reverse manner instead of regular pattern. Here, I would like to explain my query in detail.

    As you all aware that we use paste special command for multipurpose requirements such as breaking the links/transpose etc. But, here I need to copy the data from last row figure as first in the same context first one as final.

    Ex: if Data is 123456 and if we paste the data by using paste special, data will be same may be in in row /column. Here, I wanted to copy the data as 654311 which means reverse. Hence, kindly guide me whether is there any command/formula for doing the same.

    Your kind support for the same would be appreciated.

    Thanks in advance

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    York, England
    Excel Version
    This bit of code will allow you to input the copy source and paste location, and carry out the reverse paste operation:

    Sub PasteReverse()
    Dim Crange As Range, Prange As Range, rws As Long, x As Long
    Set Crange = Application.InputBox _
     (prompt:="Input Copy Range: ", Type:=8)
    Set Prange = Application.InputBox _
     (prompt:="Input First Paste Cell: ", Type:=8)
    rws = Crange.Rows.Count - 1
    For x = rws To 0 Step -1
    Prange.Offset(rws - x, 0).Value = ActiveCell.Offset(x, 0).Value
    Next x
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts