How to Copy Rows to Another Worksheet and Remove Duplicate Based on Text
How to copy rows to another worksheet and remove duplicate based on text Copy or transferring data based on text in excel is a tremendous feature to have. No matter what we do in excel, there are times we need to copy rows from one worksheet to another. For example, if you are managing projects you must’ve separated worksheet based on project status. Like I’ve done in the video. Now for a cleaner look I copy all the completed project to a different worksheet. But if I want to do it manually every time it is tiresome. So, I need to automate this procedure. In a previous video I’ve done that: • How To Copy An Entire Row To Another Works... I even created a tutorial on how you can move an entire row based on cell value: • How To Move An Entire Row To Another Works... But there was a catch on the previous video. When you move a row, you don’t have to deal with duplicate value. But when you copy rows, every time it creates duplicate value. In this tutorial I’ve update that code and now you can copy an entire row to another worksheet based on text and then remove duplicate automatically. Now let’s follow the procedure below to copy rows to another worksheet and remove duplicate based on text in excel. Step 1: Click on the Developer tab (How to Add Developer Tab in Excel: • How to add developer tab in excel ) Step 2: Click on Visual Basic (Learn VBA Programming: http://bit.ly/excelvbacourse) Step 3: Click "Insert" and then "Module" Step 4: Write the code (Please subscribe and here goes the code: / 48048035 ) Step 5: Click On the "Run" Button Step 6: Done. You have successfully copied an entire row based on cell value to another worksheet and removed duplicate. The code I prepared has several parts. First it will copy the entire row based on the text. Then it will paste the row to the pre-defined worksheet. Then it will remove duplicate rows so that you can access unique value no matter how many times you use the code. #CopyRow #Worksheet #RemoveDuplicate 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 Become a member and enjoy exclusive perks while supporting the channel you love! / @excel10tutorial
