Скачать или смотреть How Move Row to Multiple Worksheets From One Worksheet Based on Cell Value or Dropdown List In Excel

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: https://msexceltutorial.com/post/How-...)
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:   / 62331567  )
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:   / 62331567  )
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
  / excel10tutorial  
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/ Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial