How to Automatically Move Rows to Specific Worksheet Based on Text In Microsoft Excel

[@ufsltddailyeuropeanroadfre211]

This is incredibly useful. Is there a way to move it down a row on the "Completed" sheet in order to retain the same headings there? How would you accomplish this?

[@P4PYROIND]

Hai, Thank you,It was a wonderful Video....., Is it possible to not to remove/Delete the data from the Source work sheet even though it gets appears on the destination work sheet...

[@osbuilt256]

This is a very awesome video, it helped me get the start of what I'm wanting to do in my spreadsheet but I still have questions. I was able to move the data as the video explains but I'm wanting to expand it to being able to move the data to different worksheets rather than only having one option.

[@Excel10tutorial]

kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@TheSupersquab]

Hi! This is awesome, is there another video where you show how to add the other drop down options? Say I have 3 more sheets I need them to separate in?

[@eimran1178]

Thank you very much for the vid. Very well explained. The first one works perfect. The lines which contain "Done" are sent to the other sheet. Unfortunately the second code doesn't work for me. I copied it exactly but the second macro isn't called when enter "Done".

[@Excel10tutorial]

Did you save the workbook in .xlsm format?

[@eimran1178]

@@Excel10tutorial hi, yes. The first one works so VBA is enabled. Only the macro under the worksheet isn't triggered when I enter "Done" Kind regards.

[@Excel10tutorial]

If its not the spelling send the workbook to me. I'll take a look.

[@coininban]

This looks great, but do you have a place where the VBA script is listed? Thanks!

[@Excel10tutorial]

In the description

[@kirannikil]

Excellent. It is really useful in projects. However can you please help me in providing in when ever the status is done then to copy those only table data to email body. This is will be really helpful if you would provide this information. Appreciate you help in advance.

[@Excel10tutorial]

Break it down to Two step. Step one: Move data to specific sheet using the technique Step two: Send email the way you are used to.

[@kirannikil]

Can you please share this code I will try enhance this code as per you guidance into two methods. Looking for the code used in this video. Also need your as usual support in this. Thank you very much for your kind ful support.

[@Excel10tutorial]

Link in the description.

[@kirannikil]

I filled form and subscribed. Waiting for code

[@Excel10tutorial]

Check now.

[@florilynb.casajeros9778]

Thank you so much, this is so helpful. Just wondering if it still works if I will move rows from 2 to 4 worksheets into the completed sheet.

[@Excel10tutorial]

Yes, absolutely

[@rohitrohh]

Most underrated video in KZbin. Great job

[@Excel10tutorial]

Glad you think so! Thanks a million for subscribing.

[@kuanming0601]

Thanks for super useful video! The VBA code for Master part is a bit incomplete due to zoom-in, can I ask what should be filled after "Is Nothing Then"?

[@Excel10tutorial]

Code link is in the video description. Please copy the code from there

[@LukeKerrigan]

Thanks so much for this video and the code, it's extremely useful! Is it possible to get the row to move back from the completed worksheet if the wrong drop down option is selected by accident? I tried inserting the same code but changing the 'Master' and 'Completed' around - however, the code doesn't seem to work. Do you know if I'm doing something wrong? Sorry if stupid question, I' completely new to this!

[@Excel10tutorial]

You can get ideas from this video. kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@petchimuthut5469]

Hi This is really awesome. Can u post a video on how to write this code?. This would really help me

[@Excel10tutorial]

I will in the future.

[@nunogomes694]

Finaly !!! This is something I have been looking for so many time !Thanks man for shared this info. Waiting for the codes to be sent please

[@Excel10tutorial]

In the description

[@HVinnieVee]

Thank you so much for this, has change my spreadsheets ! Just wondering how I could have two drop down options going to the same worksheet?

[@Excel10tutorial]

Create two macro for same destination worksheet. Just change the text by which you want to move. Also you can check this tutorial for inspiration: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@harrylu4488]

This is something we have been looking for. Subscribed and form filled. Waiting for the codes to be sent through!

[@Excel10tutorial]

Sent!

[@ericbeyer8229]

This is awesome, thank you!! Does it work for Tables as well or does the code need to change for that?

[@Excel10tutorial]

it doesn't work with table.

[@dmeyer6994]

Awesome tutorial. You have helped me out so much. Thank you!

[@Excel10tutorial]

That's great to hear, glad I could help!

[@mailkeen]

Hey man great video! Wondering how long before the code gets sent though... I'm using for a project at work! So thanks again... You're making this workbook a totally different experience!

[@Excel10tutorial]

Code sent. Please check

[@fionajhoa]

Hi, thank you so much for this it’s been very helpful in my work. I wanted to see what needs to be done in order to add a new command. I’m looking to add “pending” to the status and I would like it to move to the pending worksheet. please let me know if this can just be added to the module code and if so, how can it be coded. Thank you for your insight!

[@Excel10tutorial]

I think this will do the job: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@taqiraelliott3280]

This was super helpful. Please let me know once you send the code

[@Excel10tutorial]

Sent. Please check.

[@aaronwindsor5249]

Is there a way of reversing the action, say if you 'Complete' a cell on the Master sheet and it moves to the 'Completed' sheet. If I then changed the cell to 'Open', is there a way of it automatically going back to the 'Master' sheet?

[@Excel10tutorial]

For that you need to configure each sheet.

[@a.wessel8865]

Great video! I too am using this for a project at work with a bit of a deadline. Could you please send that over? Thanks again for your help!

[@Excel10tutorial]

Code link is aready in the description. Please check.

[@robertattard7300]

Great video and it's something i really wanted to implement to my sheet. How would i get access to the coding you used?

[@Excel10tutorial]

Check the link in the video description.

[@ianmayseno5220]

Hi Excel 10 tutorial, Please teach me how to reverse. Example when I will make the status done and it will go to Completed sheet. How about making it back to Master sheet?

[@Excel10tutorial]

There is no ctrl + z if you are using vba. If you want to get back to master sheet either you do it manually or set a code in the destination page. Just reverse. Just set up the code as if master worksheet is your destination worksheet.

[@lisaschwab710]

Thank you so much for this! It worked great but then when I reopened the spreadsheet the next time, it would not work at all. Any idea why?

[@Excel10tutorial]

You need to save the workbook as excel macro enabled workbook. Which is .xlsm format

[@Michael-kv6qr]

Thanks for the tutorial. I've completed the form and waiting for the code. Thanks again.

[@Excel10tutorial]

Sent

[@HelenBowran-iw6ns]

This has been so helpful and I’ve finally started to make some headway with what I’ve been trying to achieve. Is it possible to do this when you have multiple ‘master’ sheets and one destination sheet? Thanks so much

[@Excel10tutorial]

Yes you can! But with a bit different approach.

[@nickmyron8284]

Greetings, I got it to work with the manual process but ran into an issue after adding the Private Sub... to the Master sheet, with this error Compile error: Block If without End If. When this error came up, the following texts are highlighted in yellow "Private Sub Worksheet_Change(ByVal Target as Range). Please let me know what you think. Thanks.

[@Excel10tutorial]

Copy the code again, You missed something while copying.

[@tommccarthy3390]

I got the same error and came looking in the comments to find a solution. I managed to figure it out. Add "END IF" under the line below. If Intersect(Target, Range("N:N")) Is Nothing Then End If Im no expert but I think it was because if there is an "IF" statement you need an "END IF" afterwards. It worked for me.

[@marsontaylor8873]

Very deltailed and organized tutorial. Question, how would I modify the code if I wanted to move the row for more than key word eg. For "done" or "pending"

[@Excel10tutorial]

It is possible. Check this out: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@hzahriyeh213]

At the time 4:16 in the video, I can not see the full code. What comes after “Is Nothing Then…” ?????

[@Excel10tutorial]

Code link is in the video description. Please check.

[@karryceee]

Awesome video. I found it easy to follow. May I have the code please? Not sure if it's available still. Thanks!

[@karryceee]

I found it! :) And it worked. Took me 20 minutes (my first time ever using codes on Excel)!

[@Excel10tutorial]

In the description

[@alexknox6272]

This is just what I was looking for. Where can I get the code? Thank you so much!

[@Excel10tutorial]

In the description

[@staceykleinsasser2079]

This is great! I got it to work on my spreadsheet. I do have a question though. Let's say I marked something as Done and it moves the row to the Done Worksheet but I changed my mind and don't want it to be Done yet. How do I get it to move back to my original worksheet if I change it back to In Progress?

[@Excel10tutorial]

Just think that sheet as your master sheet setup this code again on that sheet.. you'll need to change the procedure name and it will work.

[@t-frontal]

Danke!

[@Excel10tutorial]

Thanks a million for your support.

[@catalinabrizeno5037]

subscribed and Filled out the form just waiting for the code. thank you!

[@Excel10tutorial]

Code sent to everyone. Please check email.

[@tyleradams3904]

Did you ever get the code?

[@Excel10tutorial]

Yep. Everybody does. Sometimes it takes time because i sent to to everyone manually. Sorry for the trouble.

[@devote2256]

This is the exact outcome I am trying to achieve. Is there a location where the code can be copied? I understand I will need to edit it some information specific to my sheet.

[@Excel10tutorial]

Please check the link in the video description

[@sushahs9656]

Hi Sir, great video kindly sir i need the same method but want to copy data to next few Sheets,as per different sheets but i want the same list too on a main sheet. plz send me its code . i shall be very thankful

[@Excel10tutorial]

Try this one: kzbin.info/www/bejne/invSg4itp6qYZsk Code link is in the video description.

[@andrewhockey2825]

Hi Excel 10 Tutorials, Wondering if i can get a copy of the codes please

[@Excel10tutorial]

Code is linked in the video description.

[@andrewhockey2825]

@@Excel10tutorial Thank you, I have found it. How do I adjust this code do that i can have 2 or more key text across 2 or more key worksheets?

[@Excel10tutorial]

Check this: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@AllisonMiller-us4sw]

Hello! This will come is so useful for my workplace. I would like to utilize this for multiple sheets in one workbook. Move from current to completed. Can't wait to try this out! Thank you! I look forward to watching more of your videos!

[@Excel10tutorial]

Sounds great!

[@Adrian-sj3qi]

Hey, fab video.. pleaee could I get the code for this so I can give it ago

[@Excel10tutorial]

Code is linked in the video description. Please check.

[@lstuart2727]

After completing all the steps in both the Module1 and the Master(sheet1) and close those out, Macro will not run Automatically when the exact word (Spelling and Leader Cap) is entered into the designated column. Excel workbook is saved in the format of Excel Macro-Enabled Workbook (*.xlsm). The Macro will only run when I manually select the Macros in the Developer tab, and, click on Run. What could cause this to not Automatically Run?

[@Excel10tutorial]

Please check the code again. I think you missed the first few lines of the code when copying.

[@mikehunt752]

If i were to do this again to go from the other oneback to the original location will it work obviously changing some of the values out.

[@Excel10tutorial]

Just change the destination worksheet to source worksheet and vise versa.

[@amysingh2752]

Hello, Can I get the code to automatically move rows from 1 tab to another with cell values. The information from the master tab needs to move to 3 other tabs by the cell value. Can you help me with this please?

[@Excel10tutorial]

Please check this: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@arijturner8419]

what if i want the data to be entered in sheet 2 but starting from 5th row for example like for example start from cell G7 ? not A1?

[@Excel10tutorial]

Can't change the column. You can start from different row but not column.

[@rossmarkley-in4ss]

Hi, this is just what I am looking for. Would it be possible to get the code please?

[@Excel10tutorial]

Code link is in the description.

[@leetpaco8814]

What would the code be for the Completed tab to be able to move it back to the master if we changed the status?

[@Excel10tutorial]

For that you have to create another set of code. Assuming the Completed tab as your master worksheet and Master as your destination worksheet. Just change the procedure name in the second set.

[@ahmedhabib2975]

Great video, exactly what i was looking for. Do you think itd be possible for you to send me an alternative link to the code since the link in the website in the description isnt working for some reason. thankyou in advance

[@Excel10tutorial]

Are you still having trouble getting the code?

[@cmf9375]

Hello! Thank you for the guide, i was wondering if i could have multiple criteria that sends the row to the other sheet as long as one of them matches? for example, either “Done” , “Ok”, “Good to go” will allow the macro to work?

[@Excel10tutorial]

Here is how: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@cmf9375]

Thanks! Could there possibly be a shorter way? I have like 1000 eligible criteria that I want the VBA to recognize and move the respective rows to sheet 1 and then another 1000 eligible criteria for sheet 2 😂

[@Excel10tutorial]

That would lead excel to crash.

[@petrixo1911]

If I change the data in the completed form from done to pending is there a code for it to go back to master sheet?

[@Excel10tutorial]

You'll have to setup each page. Here we've setup master sheet as base worksheet and pending sheet as destination worksheet. you need to consider pending sheet as base worksheet and master sheet as destination worksheet.

[@m.behnamdds.3356]

hi, can you kindly share the code needed to move row to another worksheet

[@Excel10tutorial]

In the description

[@RaphaelDJ-iu5tu]

great video! I tried to do it but seems like there something I did wrong. The code Sub MoveBasedOnValue() is highlighted with yellow. Could you help?

[@Excel10tutorial]

Please try again on a new workbook and let me know if you still have a problem.

[@bhushannakade5215]

Is there a way let suppose there are 5 sheets and as I type the name of that sheet that entire row data gets copied to that particular name sheet

[@marcuspasfield892]

Howdy, Really loved this but unfortunately when I have used the code it is not working on enter. I need to "Run" the script and then it moves the rows with my text in

[@Excel10tutorial]

Please check the code again. i think you missed a line or two from the beginning of the code. Please copy it properly.

[@Noname-tl7tx]

Hi there, thank you so much for this. I got this working beit when coming back from leave suddenly when changing to completed the line disappears and doesn't show up in the other sheet. What can I do?

[@Excel10tutorial]

Save the file in .xlsm format which is excel macro enabled workbook

[@daniele5713]

Hi, I have changed the names of the worksheets and the interval columns to adjust to my spreadsheet but it doesn't work?

[@Excel10tutorial]

Send me an email.

[@wadamini]

Hi, I'm trying to find the code but the link in the description does not open up the code. Please tell me where I can find the code elsewhere.

[@Excel10tutorial]

Check this: www.patreon.com/posts/44693147

[@keithmcgee1253]

What if you only wanted to move a range instead of the entire row from the Master worksheet to the Completed worksheet?

[@MaryKrupar]

Very helpful! The links to the codes don't seem to work though :(

[@Excel10tutorial]

Please check again.

[@oliviademaris5035]

Hi! Thank you so much. I followed this... do you have any idea why I keep getting the error message "Compile error: Sub or Function Not Defined."

[@Excel10tutorial]

Copy the code carefully. Make sure no line is missing.

[@monikao5266]

Hi there! Amazing code and it works but i realized i need to RUN the code every time for the info to transfer. Is there a way to make it run automatically?

[@Excel10tutorial]

This one is automatic. If its not working that means you made a mistake preparing the first part of the code. Check the code that goes in the worksheet. if you will have problem, send me an email. I'll prepare the code for you.

[@akulsharmaa]

Got the code! Thanks a lot Is there a way to just copy the data in another sheet and not deleting it from the original one?

[@Excel10tutorial]

Check This One: kzbin.info/www/bejne/pl6qmpaYgtVsb5Y

[@Excel10tutorial]

@pushpendra patel Please check now.

[@IgnatiusOmenai]

Thanks for the tutorial, I've subscribed and filled out the form, waiting for the code

[@Excel10tutorial]

Check now

[@hamishhill4152]

Subscribed and form submitted - waiting for the code - thanks!

[@Excel10tutorial]

Sent!

[@shaheedhappie7110]

Hi, I just recently subscribed and waiting for the code. Thanks

[@Excel10tutorial]

Check now

[@AndyBanns]

You're a legend, thank you so much, this is exactly what I wanted to do. Took a little bit of fiddling, but works perfectly now

[@Excel10tutorial]

Great to hear!

[@stephanienovakowski817]

Thank you so much! Great video and I have signed up but I have not yet received the codes.

[@Excel10tutorial]

Sent!

[@OneBaseballFan1]

This is exactly what I needed after searching high and low. May I please have the code? Thank you so much :)

[@Excel10tutorial]

Code link is in the description.

[@kemometriker]

Great video! Can I also get the code please? Much appreciated!

[@Excel10tutorial]

In the description

[@flipafone8648]

Hi, do you have tutorial for google sheet doing the same- move rows

[@Excel10tutorial]

I don't have anything on google sheet. sorry.

[@christymulhall]

Thanks. A really easy to understand guide. Do you have a link for the code?

[@Excel10tutorial]

Sure. Code link is in the description.

[@bradbarton1387]

Hi, thanks for this. its works beautifully! i do have a question though. if I wanted to move a completed (which works fine) but I also wanted to move a *cancelled*. how would I do this. i want to move from he same dropdown. to the same workbook page. I've tried adding another field but I'm getting something wrong as it crashes. would it be possible if you can create a quick video about creating multiple moves to a workbook page from the same drop down. or another field :) thanks a lot!

[@Excel10tutorial]

Check this: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@dianafeliciano6275]

This is awesome! Can I Have the code please? thank you:)

[@Excel10tutorial]

Please check the link in the video description

[@brenigthomas7670]

Hi, it looks a great video but when running the program I get a Compile error: syntax error and the 1st line of code on the worksheet code Dim Z As long is highlighted and the code will not run any further. How do i fix this?

[@Excel10tutorial]

Well, that us not the first line of the code. Make sure you copy it accurately.

[@isimikehinde5584]

great tutorial. I have signed up to your website to get the code but i am not getting them; is there something i need to do?

[@Excel10tutorial]

Check now.

[@isimikehinde5584]

@@Excel10tutorial unfortunately the website isn't loading; any other way to get the code? Thanks

[@Excel10tutorial]

Send me an email. Address is in the channel about section.

[@TrustedPatriot]

Thank you for the information. Can you please share code?

[@Excel10tutorial]

Link in the description.

[@ThisIsMeSoThere]

the link to the VBA doesn't exist (anymore). Is there a new link available?

[@Excel10tutorial]

Here you go: www.patreon.com/posts/44693147

[@EliseHumphreys]

Hi the link for the code in the bio has expired. Could you direct me as to where I could now find it? x

[@Excel10tutorial]

Try again. Code link is working.

[@zeinabouibrahim2697]

Thanks for this tutoriel, it will be very helpfull for me. May i have the code please? Thanks in advance

[@Excel10tutorial]

In the description

[@shaikhsajed9345]

The video is great but still i am unable to run i, it's showing while debugging it's showing "Compile Error invalid outside procedure" if you know how to fix it please let me know.

[@Excel10tutorial]

Check the code again.

[@clairehayes3323]

Is it possible to create a second row move, into a different tab, based on another project status, eg On going.

[@Excel10tutorial]

Yes, absolutely. You need to change the module name for that and call that module in the code. If you find it hard, send me an email with your project. i'll look into it. Email address is in the channel about section.

[@israelvilla4877]

Thanks for tutorial, subscribed and form completed. Waiting for code.

[@Excel10tutorial]

Sent

[@rajakumar.r4827]

Subscribed and signed up the form

[@Excel10tutorial]

Code sent. Please check

[@luissuaste4836]

what if I wanted to move them if complete to separate sheets? So using your data as an example if we had a sheet for each person in the "assigned to" column, how would we get it to send to the designated sheet by person if marked complete?

[@Excel10tutorial]

Check this video: kzbin.info/www/bejne/jn6mgaavhtmFa6c

[@luissuaste4836]

@@Excel10tutorial Kind of, I want complete to be the indicator for it to move, but I would like it to move to separate folders by project names. So complete would be the indicator to move, but the folders would be by project name

[@Excel10tutorial]

You can do that.

[@ianmartin902]

HI - is it possible for the VBA to look for 2 criteria? For example, using your spreadsheet, If column C contains "Jackie Hood" AND column D contains "Completed" then move the entire row Is that possible?

[@Excel10tutorial]

Yes. Sent the solution through email. Please check and share your experience. Thanks.

[@ashleypellegrina9039]

Good Morning, Apologies i have no sound so have tried to use youtubes subtitles to watch your video. what i am looking for is the ability to type WON or LOST in Column P for example and it automatically move it to the Won / Lost tab spread sheet. is this something you may be able to help with? Many thanks

[@Excel10tutorial]

You can do that. Please email me the file and I'll configure it for you. Email address is in the channel about section.

[@ashleypellegrina9039]

@@Excel10tutorial Thank you - I have sent you an email.

[@Excel10tutorial]

Yes. I've replied.

[@ashleypellegrina9039]

@@Excel10tutorial Big help thank you very much

[@Excel10tutorial]

You're welcome.

[@standingtogether4532]

Hey thank you for this! very helpful - running into a bit of a problem - when I write 'completed' which is my version for 'done' in this code, it does move to the new sheet however it appears at row 6, and if i try to do another row, it replaces the one done before? if you could help me out that would be great!!

[@Excel10tutorial]

If you can't set it up send me the workbook in .xlsx format, I'll look into it. Email address is in the channel about section.

[@mortezajahri1709]

Hey mate, Fantastic. May I have the codes?

[@Excel10tutorial]

In the description

[@glennahenriksen217]

Great video! When can I expect to receive the code so that I can try this?

[@Excel10tutorial]

Link is already in the description

[@kbwrules]

Great videos. I'm working on a spreadsheet from columns A to H, H being the done column, how do I go about getting the code so when I write done it moves to new spreadsheet.

[@kbwrules]

Have done Patron, found the code, but still can't get it to work. Excellent videos.

[@Excel10tutorial]

Thanks a million for the support on patreon. Please check this article, I've detailed instruction there. Hopefully your questioned will be answered there. If you still have problem contact me through email. I'll setup your workbook. msexceltutorial.com/post/How-to-Automatically-Move-Rows-to-a-Specific-Worksheet-Based-on-Text-in-Microsoft-Excel

[@brandonsimpson8993]

Hey great video. Would love to get the code to use for my team

[@Excel10tutorial]

Check video description and Please subscribe and share.

[@rachelswendiman]

I subscribed and filled out the form. Is there a way to adjust the code so that the row on the master isn't removed?

[@Excel10tutorial]

There are several tutorial on the channel regarding how to copy row to another sheet, Please check.

[@rachelswendiman]

@@Excel10tutorial Could I still get the codes for this one?

[@Excel10tutorial]

Code sent to everyone who signed up.

[@traviswilliams1377]

On the second code I'm getting a compile error Block if without End if on Private Sub Worksheet _change(ByVal Target As Range) Do you know how to fix that

[@Excel10tutorial]

Please check the code again and copy correctly. There is missing line.

[@daniellim7675]

If you have multiple sheets that you build using a templated sheet, is there a part in the code for "module" that you can change so the Move to Sheet function works universally in the workbook?

[@Excel10tutorial]

Please explain your need.

[@RekkiLakea]

Hi, I know its too late, but i would like to know if I can do this with an entire table instead of a row. Maybe in the code i need to type "EntireTable" where it saids "EntireRow"?

[@Excel10tutorial]

It doesn't work that way.

[@rizalfanani9512]

great video and tutorial, but i got error "compile error: invalid outside procedure" have copied it many times and its the same as what it show on your video but i still got that error everytime

[@Excel10tutorial]

May be you missed the first line while copying the code. Make sure the first line starts with sub

[@rizalfanani9512]

@@Excel10tutorial oh yeah it turned out the sheet code have missing line. btw how can you move the data to a specific cell on specific sheet? i have tried it the data moved but its not move to the cell that i want it to move. i want the data to move to cell "A5" but everytime i do the macro, the data moved to cell "A105", "A405" and so on. the cell "A5" on every destination sheet is empty and reffered to another sheet

[@Excel10tutorial]

Data moves to next empty row. If you delete from row 105 to 404 just once, it will start working fine. It will place data to the next row from then.

[@rizalfanani9512]

@@Excel10tutorial yes i have tried to delete the row, but the problem is every cell on the destination sheet is refered on other sheet, so it get formula error on other sheet when i deleted it. i have fixed it by delete the destination sheet and start making it again. i was ask if there is a code command to make it move data starting on the cell "A5"

[@jehanjayamaha5849]

Subscribed and waiting for the code. Thanks you

[@Excel10tutorial]

Check the link in the video description.

[@shawngraham4484]

This was really helpful thanks. I seem to have an issue though, I can move the data from sheet 1 but it doesn’t appear anywhere in sheet 2. I get an error for the xRg(C).Entirerow. Copydestination:=worksheets(“complete”).range(“A”&b+1) It doesn’t let me in : followed by =, I can only have one or the other so I’m assuming this might be my issue?

[@Excel10tutorial]

Send me an email. I'll take a look

[@ashwanisrivastava6539]

Thanks a lot, I being newbie trying to do the same from watching different youtubers, but always missed something. After following your video, it is working perfectly.

[@Excel10tutorial]

Glad I could help!

[@MariusBredesen]

Hello! Is it possible to only move a few columns and not the entire row? :)

[@Excel10tutorial]

Yes. Its possible. Send me an email

[@k03dz0n3]

you are a legend! thank you so much!!

[@k03dz0n3]

I practiced a couple of times just to see if it works, and now when row is moved, it moves it multiple rows down... is it possible to have the system fill up an empty row as close to the start / top of the spreadsheet?

[@Excel10tutorial]

Delete those empty row once. After that it won't miss.

[@k03dz0n3]

@@Excel10tutorial thank you!!!!

[@Excel10tutorial]

You're welcome. Don't forget to subscribe.