How Move Row to Multiple Worksheets From One Worksheet Based on Cell Value or Dropdown List In Excel

[@pamelahamilton9668]

This is awesome. However, I want to COPY the data and not move it. How would I change the code to do this?

[@ZahidMuhammed-q9w]

This awesome tutorial, could you please make a video about copy instead of moving?

[@Excel10tutorial]

I have a lot of videos regarding that. Please check on the channel.

[@dOnellaization]

Thank You!! I'm still looking through your videos, but what if you want to move from multiple source sheets to one destination worksheet for "completed" items?

[@TheSupersquab]

Would I apply the same code in the master tab to the other tabs if I want to move a pending to complete? Right now my worksheet only automatically moves them from the master tab, but not the other tabs when I update the status

[@lucianaragone5260]

This is a great video. Quick question.. when I put complete in my drop down it moves over to the complete sheet however it deletes a previous row in that sheet. How do I fix this?

[@julietaontiveros5227]

What if by mistake i select the wrong row and in the drop down list I accidently clicked on one of the categories from the dropped down an it moves that row to it's designated worksheet/tab. Is there a way to automatically move it back to "Master" worksheet/tab if I change the category in the worksheet/tab it was moved to? Hope I'm explaining myself clearly. I look forward to your advice.

[@Excel10tutorial]

You need to setup each sheet in this way. Here you have many destination worksheet to achieve what you want you need to consider those destination sheet as source sheet and setup the code in those sheet accordingly.

[@yurivillela9745]

Thank you very much!! It helped me a lot!

[@Excel10tutorial]

You're most welcome!

[@matthewporter3048]

hi, thanks very much for this tutorial its great, question I have is, if I delete data from the destination worksheets and then move a row from the master sheet, it doesn't paste the data to the top/first available blank cell in column A. how can I ensure the data moves to the first available empty row on the destination sheet?

[@Excel10tutorial]

Select the in-between empty row, rightclick and delete. Now it will work fine.

[@ped2710]

Thank you for making this Video. There is small problem with your code. lets say there are 10 rows of information, if i type Completed on the last row in this case the 10th row it won't move it to Completed sheet. Can you fix this please.

[@Excel10tutorial]

It will work unless you're making a mistake. Remember the specific text here is case sensitive. Make sure its same as your code.

[@yumnaasif2244]

As well, will this work if I add a new row and select one of the 3 options from the drop down list?

[@Excel10tutorial]

Yes it will work.

[@fredowdomini4964]

You gain a new subscriber for this one. This is a very helpful. Just a question though, what if from pending status I need to change it complete status or cancelled status, should I just copy the automation code to the pending sheet?

[@Excel10tutorial]

If you do full automation then it will be problem. If you use button to activate the code you can do that in that way.

[@johncanlas1704]

Hi, what if I have sheets CompanyA, CompanyB, CompanyC, CompanyD, CompanyE and Master. How can I automatically move from master to their respective sheet once I type in Completed? By the way, very nice tutorial. Hope you can help me. Thank you.

[@Excel10tutorial]

You'll have to setup multiple condition. One for company name and another for conpleted.

[@johncanlas1704]

@@Excel10tutorial Sorry but im totally noob about this. Can you kindly give me a sample code that I can just copy and edit? Appreciate your help. Thanks a lot.

[@Excel10tutorial]

Send me an email with your workbook. I'll take a look at it. Email address is in the channel about section.

[@nancyray969]

Thanks!

[@Excel10tutorial]

Thanks a million.

[@ldickson2540]

This has been useful, but I'm a true novice. Do I change range in all areas you have 'C'?

[@Excel10tutorial]

Not everywhere. Just a the lines listed below. If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub Set xRg = Worksheets("Master").Range("C1:C" & A)

[@leshemrae]

My code is not appearing in the completed worksheet for some reason. The code look right to me. What is it that I could have done wrong?

[@Excel10tutorial]

Try again. Follow the video carefully. If you still have problem, send me an email.

[@yumnaasif2244]

How can we make the row not disappear from the master sheet? I still want to keep it there?

[@Excel10tutorial]

You need to check this video: kzbin.info/www/bejne/g3_GnJ1metJgY80

[@louispereira8340]

I get error with the following code? Private Sub Worksheet_Change(ByVal Target As Range) Dim Z As Long Dim xVal As String On Error Resume Next If Intersect(Target, Range("H:H")) Is Nothing Then Exit Sub Application.EnableEvents = False For Z = 1 To Target.Count If Target(Z).Value > 0 Then Call MoveBasedOnValue End If Next Application.EnableEvents = True End Sub

[@Excel10tutorial]

Which error did you get?

[@TrishGrigg]

Hi and thank you for this information! Can you please send me the VB code so I can set it up? :-)

[@Excel10tutorial]

In the description