Need Help with Copy row to other worksheet based on criteria

  • As the title states I need help with a copy and past VBA for a button I am using column a on sheet 2 "Data" and what I need is when I input an "X" into the column which there are multiple rows that will be used, I need when I push the button it copies the whole row to the bottom row of the "TruckHistory" sheet. But I want only the values copied over. I have tried so many too many to count variations of copy and paste code that I am at my wits end. The attached sheet is just a working model. There are a lot of blank cells in the data sheet and truck history, as I am continuing to update it everyday. Here is the code I have gathered so far.



    [/CODE]

  • Re: Need Help with Copy row to other worksheet based on criteria


    Try this. :cool:


  • Re: Need Help with Copy row to other worksheet based on criteria


    Well it finally copies the values, unfortunately it copies the whole table to the next page instead of only the rows marked "X".

  • Re: Need Help with Copy row to other worksheet based on criteria


    I thought you were using the column marked status.


  • Re: Need Help with Copy row to other worksheet based on criteria


    Wow so, so nice works perfect, thank you so much. I should have swallowed my pride a lot earlier.

  • Re: Need Help with Copy row to other worksheet based on criteria


    You could probably record a macro for that and then ask for some help customizing it with an input box that asks for the truck number.


    It should be a new thread though, not a continuation of this one.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!