Moving a row in Excel [Closed]

Report
-
Posts
14482
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 5, 2021
-
Hello,

I need to move a row completely from spreadsheet 1 to Spreadsheet 2, which has same rows and columns. Can anyone explain me step-by- step as I am new to Excel. Thanks.

5 replies

Posts
14482
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 5, 2021
4
Do you want to do that manually (a few times), or automatically?
Thanks, I want to do that automatically.
Posts
14482
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 5, 2021
4
How do you want to trigger that move?
You want to move (copy then delete the original) a single row, right?
Yes,I wanted to copy and delete the row in the original spreadsheet. And need to do it multiple times whenever need. Thanks
Posts
14482
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 5, 2021
4
To start with, I propose that you develop a solution doing what you require between two sheets of the same spreadsheet.
If you agree, I propose that you start by recording a macro while you manually do the move. You will then enhance the recorded macro according to your requirements (still on a single worksheet).
You can later, once it is fully operational within a single spreadsheet, easily enhance it to go to another spreadsheet.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!