How Move Row to Multiple Worksheets from One Worksheet Based On Cell Value or Dropdown List in Excel
Moving data from one worksheet to multiple worksheets is one of the most tiresome clerical tasks ever existed. There are tons of scenarios where you'll need to move data from one sheet to several others based on different conditions. Suppose you create a task manager where you aggregate all the projects in a master worksheet and then distribute them to different sheets based on different situations. Or you have to transfer each completed project to the completed worksheet, pending projects to the pending worksheet, and ongoing projects to the ongoing worksheets. If you want to do it manually, you can do that, but that will not be suitable if you want to be efficient in your workspace. You need an automation service where you'll be able to transfer data in a blink of an eye.
In this tutorial, I'll show you how to do that. I'll be using VBA here, and I've done several tutorials like this, but this one shows how to automate the whole process. Let's follow the steps below to move rows to different worksheets based on different cell values without further ado.
Step 1: Click on the developer tab (If you don't have the developer tab on your ribbon, please check this tutorial: [ Ссылка ])
Step 2: Now click on "Visual Basics."
Step 3: Select "Insert."
Step 4: Click "Module."
Step 5: Compose the code (Check this link to get the code: [ Ссылка ])
Now repeat steps 1 to 5 based on how many destination worksheets you have. In the video, I had three destination worksheets; that's why I had created three modules.
Step 6: Change the code in each module based on your worksheet name and specific text.
Step 7: Close the VBE.
Step 8: Right-Click on the source worksheet name and paste the automation code. (Check this link to get the code: [ Ссылка ])
Step 9: Change the automation part based on how many macro names you need to call and the column name where you have your specific text.
Step 10: Save the workbook in .xlsm format.
Done. Now, if you select a value from the dropdown list, it will move that entire to another worksheet you specified earlier.
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:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]
Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
Quora: [ Ссылка ]
Website: [ Ссылка ]
