How to Automatically Move Rows to Specific Worksheet Based on Text In Microsoft Excel

In this Advanced Excel Tutorial, I'll show you an excellent way to automatically move rows to any specific worksheet based on cell value. Not only this; in the bonus part, I'll show you how you can add a dropdown menu to this and whenever you select a specific value from the dropdown list, it'll move the entire row to the particular worksheet. I've created several tutorials on moving and copying data. You can check them here:

Learn To Copy Data To the Next Empty Row Of Another Worksheet In Excel:

Now let's follow the procedure below to automatically Move Rows to a Specific worksheet based on text In Microsoft excel.
Step 3: Click "Insert" and then "Module."
Step 5: Close the VBE

Now We need to Automate This. So, Follow the instruction below:
Step 1: Right Click on the source worksheet Tab
Step 2: Click on View Code.
Step 4: Close the VBE.

Now, whenever you write a specific word in a particular column, it'll move the entire row to the specific worksheet automatically.
Now, the bonus fact. Create a dropdown menu around it.
Step 1: Create a list of the menu you want in your dropdown.
Step 2: Click On the cell where you want the dropdown menu
Step 3: Click "Data" and then "Data Validation."
Step 4: Select List from the Dropdown.
Step 5: Select the menu list you just created
Step 6: Click, "OK."
Step 7: Copy the dropdown menu throughout the column and done.
Whenever you select the specific menu from the dropdown, it'll move the entire row to the specific worksheet.

#MoveRow #VBA #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[osbuilt]

This is a very awesome video, it helped me get the start of what I'm wanting to do in my spreadsheet but I still have questions. I was able to move the data as the video explains but I'm wanting to expand it to being able to move the data to different worksheets rather than only having one option.

[AllisonMiller-ussw]

Hello! This will come is so useful for my workplace. I would like to utilize this for multiple sheets in one workbook. Move from current to completed. Can't wait to try this out! Thank you! I look forward to watching more of your videos!

[mailkeen]

Hey man great video! Wondering how long before the code gets sent though... I'm using for a project at work! So thanks again... You're making this workbook a totally different experience!

[harrylu]

This is something we have been looking for. Subscribed and form filled. Waiting for the codes to be sent through!

[AndyBanns]

You're a legend, thank you so much, this is exactly what I wanted to do. Took a little bit of fiddling, but works perfectly now

[ufsltddailyeuropeanroadfre]

This is incredibly useful.
Is there a way to move it down a row on the "Completed" sheet in order to retain the same headings there? How would you accomplish this?

[nunogomes]

Finaly !!! This is something I have been looking for so many time !Thanks man for shared this info. Waiting for the codes to be sent please

[jessicahughes]

This is exactly what I was looking for. Just waiting for the code now. Thank you!

[biancaacuna]

this is exactly what i needed ! Thank you for these tutorials. Just waiting on the code so i can try this. :)

[Michael-kvqr]

Thanks for the tutorial. I've completed the form and waiting for the code. Thanks again.

[claytonrider]

Just the function I was looking for. Thank you for sharing!

[ivettemartinez]

Hi! This is awesome, is there another video where you show how to add the other drop down options? Say I have 3 more sheets I need them to separate in?

[blackhawk]

Great Tutorial. Thanks for this. Awaiting code so I can try it my self.

[DrPeppa]

Thank you for the tutorial,
I subscribed + filled out the form and I'm now waiting for the code.
Thank you 👍

[IgnatiusOmenai]

Thanks for the tutorial, I've subscribed and filled out the form, waiting for the code

[fionajhoa]

Hi, thank you so much for this it’s been very helpful in my work. I wanted to see what needs to be done in order to add a new command. I’m looking to add “pending” to the status and I would like it to move to the pending worksheet. please let me know if this can just be added to the module code and if so, how can it be coded. Thank you for your insight!

[allisonbueno]

This was incredibly helpful! Thank you

[HelenBowran-iwns]

This has been so helpful and I’ve finally started to make some headway with what I’ve been trying to achieve. Is it possible to do this when you have multiple ‘master’ sheets and one destination sheet? Thanks so much

[icyyabo]

Great tutorial!! Thank you for this and the code! :)

[tanglewoodguitarsuk]

Great! This is exactly what I need, just waiting for the code!