Announcement

Collapse
No announcement yet.

How to select a list and move one row up before copy and paste it

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to select a list and move one row up before copy and paste it



    I would like to write a code to automate the following.

    First of all I will explain how I do today, sou you can help me with the code to create a macro to do it.

    A have a list with two columns and a lot of rows (variable quantity) and I need to copy this list and paste in another sheet. Today I select the first row of the first column (cell B10, for example) and press CTRL+SHIFT+RIGHT ARROW and then CTRL + SHIFT + DOWN ARROW. This select all list, but the last row is a sum of all above, so I press SHIFT + UP ARROW, so I copy and paste in another sheet.

    Please help me!


  • #2


    Record a macro while performing the steps you outlined.

    Comment

    Working...
    X