Moving a row in Excel Closed

Question

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.

Configuration: Windows / Chrome 54.0.2840.71

yg_be · Answer

Do you want to do that manually (a few times), or automatically?

Mary · Answer

Thanks, I want to do that automatically.

yg_be · Answer

How do you want to trigger that move?
You want to move (copy then delete the original) a single row, right?

Mary · Answer

Yes,I wanted to copy and delete the row in the original spreadsheet. And need to do it multiple times whenever need. Thanks

yg_be · Answer

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.

Moving a row in Excel

5 responses

Similar discussions

Subscribe To Our Newsletter!