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?

[@user-vc7fz5qy2l]

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.

[@ivettemartinez2505]

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

[@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?

[@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?

[@yurivillela9745]

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

[@Excel10tutorial]

You're most welcome!

[@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.

[@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.

[@nancyray969]

Thanks!

[@Excel10tutorial]

Thanks a million.

[@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.

[@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.

[@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.

[@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.

[@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