Move rows from one sheet to another sheet

Question

Help Please! 

Need to move the rows with the Name Bass under DSC COLUMN to the bass tab. Then I need to move all rows under the AGENT NAME column to the appropriate labeled sheet(agent name = name 10 move to name 10 tab) also move under the correct heading by month. See image. So move agent name to correct tab labeled by that name and place under the correct heading by effect. Month.

Answer 1

Sure, I can help you with that! To move the rows from one sheet to another in Excel, you can use the cut and paste method. Here's what you can do:

1. Open the sheet that contains the rows you want to move.
2. Select the rows that have the name "Bass" under the DSC COLUMN.
3. Right-click on the selected rows and choose "Cut" (or press Ctrl+X).
4. Go to the "bass" tab.
5. Select the cell where you want to paste the rows.
6. Right-click on the cell and choose "Insert Cut Cells" (or press Ctrl+Shift+V).

This will move the rows with the name "Bass" to the "bass" tab. Repeat the same process for moving the rows under the AGENT NAME column to their respective labeled sheets. Make sure to select the correct rows and paste them in the appropriate tabs and headings by month.

Remember to double-check your work after moving the rows to ensure everything is in the right place. Let me know if you need any further assistance!

Glad I could help, please leave positive feedback.

David

Answer 2

Thanks David!

I was looking for excel to do it automatically. I understand it will probably be a VBA and I dont know how to write a VBA.

Thank you!

Dan

Answer 3

Unfortunately it can only be done through a VBA, I hope these tips help. Glad I could help, please leave positive feedback.

Answer 4

Can anyone provide the vba?

TIA

Answer 5

Here’s steps without a VBA

To move the rows with the name "Bass" under the "DSC COLUMN" to the "bass" tab, you can follow these steps:

1. Open the "DSC COLUMN" tab in your spreadsheet.
2. Find the rows that have "Bass" under the "Name" column.
3. Select those rows and cut them (Ctrl+X or right-click and select "Cut").
4. Go to the "bass" tab.
5. Find the appropriate place where you want to paste the rows.
6. Paste the rows (Ctrl+V or right-click and select "Paste").

To move the rows under the "AGENT NAME" column to the appropriate labeled sheets, based on the agent's name, you can do the following:

1. Open the sheet where the rows are located.
2. Look for the rows that have an agent's name under the "AGENT NAME" column.
3. Cut those rows.
4. Go to the sheet that corresponds to the agent's name (e.g., "name 10" tab for "name 10" agent).
5. Find the appropriate place where you want to paste the rows.
6. Paste the rows.

Make sure you also place the rows under the correct heading by month.

Remember to adjust these steps based on the specific layout and structure of your spreadsheet.

Glad I could help. Please leave positive feedback.