How to automatically move rows to a specific worksheet based on text in Microsoft Excel

In this advanced Excel tutorial, I'll show you a great way to automatically move rows to a specific worksheet based on the cell value. Not just this; In the bonus part, I will show you how to add a drop-down menu to this and whenever you select a specific value from the drop-down list, the entire row will be moved to the particular worksheet. I have created several tutorials on moving and copying data. You can view them here:

Learn how to move an entire row down an active worksheet based on cell value in Excel: https://youtu.be/GAgoy_Of8nc
How to move an entire row to another worksheet based on the value of a cell in Excel: https://youtu.be/s7geU5Z2RJA
How to copy an entire row to another worksheet based on a cell value in Excel: https://youtu.be/TJoRUwrEe0g
Learn how to copy data to the next blank row of another worksheet in Excel:
https://youtu.be/_BdxU19qLU0
How to automatically copy data from one worksheet to another in Excel: https://youtu.be/TrVycW-fUkg

Now let's follow the procedure below to automatically move rows to a specific worksheet based on text in Microsoft Excel.
Step 1: Click on the Developer Tab (How to add a Developer Tab in Excel: https://youtu.be/jkSLYLk0OHU)
Step 2: Click on Visual Basic (Learn VBA Programming: http://bit.ly/excelvbacourse)
Step 3: Click /"Insert/" then /"Module./"
Step 4: Write the code (please subscribe and here is the code: https://msexceltutorial.com/post/How-to-Automatically-Move-Rows-to-a-Specific-Worksheet-Based-on-Text-in -Microsoft Excel)
Step 5: Close the VBE

Now we need to automate this. So, follow the instructions below:
Step 1: Right-click on the source worksheet tab
Step 2: Click Show Code.
Step 3: Write the code (please subscribe and here is the code: https://msexceltutorial.com/post/How-to-Automatically-Move-Rows-to-a-Specific-Worksheet-Based-on-Text-in -Microsoft Excel)
Step 4: Close the VBE.

Now, whenever you write a specific word in a particular column, the entire row will automatically move to the specific worksheet.
Now for the bonus fact. Create a drop-down menu around it.
Step 1: Create a list of the desired menu in your drop-down list.
Step 2: Click on the cell where you want to display the drop-down menu
Step 3: Click on /"Data/" then on /"Data validation./"
Step 4: Select List from the drop-down list.
Step 5: Select the menu list you just created
Step 6: Click /"OK./"
Step 7: Copy the drop-down menu across the entire column and it's done.
Each time you select the specific menu from the drop-down list, the entire row will be moved to the specific worksheet.

#MoveRow #VBA #Excel

Thank you for watching.
————————————————– ————————————————– ———
Support the channel with only 5
https://www.patreon.com/excel10tutorial
————————————————– ————————————————– ———
Please subscribe to #excel10 tutorial
https://goo.gl/uL8fqQ

Here is the channel's most recent video:
https://bit.ly/2UngIwS

Playlists:
Advanced Excel tutorial: https://goo.gl/ExYy7v
Excel tutorial for beginners: https://goo.gl/UDrDcA
Excel case: https://goo.gl/xiP3tv
Combine workbook and worksheets: https://bit.ly/2Tpf7DB
All about comments in Excel: https://bit.ly/excelcomments
Excel VBA programming course: http://bit.ly/excelvbacourse

Social networks:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hub Pages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG

Please take the opportunity to connect and share this video with your friends and family if you find it useful.