Moving a row in Excel

Closed
Mary - Nov 10, 2016 at 02:48 PM
yg_be Posts 22719 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 - Nov 13, 2016 at 04:24 AM
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 responses

yg_be Posts 22719 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 5
Nov 12, 2016 at 02:36 PM
Do you want to do that manually (a few times), or automatically?
0
Thanks, I want to do that automatically.
0
yg_be Posts 22719 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 5
Nov 12, 2016 at 04:13 PM
How do you want to trigger that move?
You want to move (copy then delete the original) a single row, right?
0
Yes,I wanted to copy and delete the row in the original spreadsheet. And need to do it multiple times whenever need. Thanks
0

Didn't find the answer you are looking for?

Ask a question
yg_be Posts 22719 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 5
Nov 13, 2016 at 04:24 AM
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.
0