![excel vba on worksheet change get row excel vba on worksheet change get row](https://i.ytimg.com/vi/-QFjJoRGCtU/maxresdefault.jpg)
Sheet 2: This is our destination worksheet and we will paste the data here. Sheet 1: This is our source worksheet and we will copy data from here. The scenario used in the video and inside the code: If anyone wants to copy data from one sheet to another in Excel, he/she can do it if they follow the procedure from this tutorial. I am using a basic scenario so that you can change it easily and match your own worksheet and situation.
![excel vba on worksheet change get row excel vba on worksheet change get row](https://i0.wp.com/alistechtips.com/wp-content/uploads/2020/02/image-7.png)
Now let's consider a basic scenario and then start the procedure to copy data if a condition is met in excel. I’ll be using a VBA to solve this and it will take a few minutes to set it up and copy the entire row.
![excel vba on worksheet change get row excel vba on worksheet change get row](https://cdn.extendoffice.com/images/stories/doc-excel/doc-move-row-to-another-sheet/doc-move-row-to-another-sheet-5.png)
In this Advanced Excel Tutorial, I’ll show you an excellent way to copy a row if the cell contains a specific word. You can even create a button to run the vba code. How would you copy the data from the master sheet to John? Copy each row from the master and then paste it to John? What if you need to transfer 150 rows to another worksheet? Doing this manually is prone to error. Now let's say on my master worksheet I have 10 project details and I want to assign 3 projects to John, and I have a dedicated worksheet named John. You need to transfer data from one sheet to another. There are literally thousands of scenarios and each has one thing in common. Assign and keep projects on separate worksheets for each employee. Or you can create a project management application and in the master worksheet you aggregate all the projects. Suppose you are creating a billing application on Excel, then you need to create a master worksheet for all transactions and a month-wise sheet for data from each month. The usual format of any project is a dashboard for reporting, a master worksheet for all the data, and lastly, several worksheets for different data types. No matter what we do in Excel, we usually use several worksheets.
#Excel vba on worksheet change get row how to
In this advanced Excel tutorial, you’ll learn how to copy data from one sheet to another based on cell value in Excel using VBA.