Command button to copy cells from one sheet and paste in second sheet

Hello,

I'm trying to create a command button on my sheet that when clicked will find all rows in column u that read Engineering Evaluation and then copy certain cells from that row to another sheet. The kicker is that this button will be used over and over again as more entries are entered into the log. I only want each row counted once. Right now I get a run time error for the "For Each Cell In Application.Intersect(Range("u:u"), target)" line.

Any help would be great. Thanks.

Please Login or Register  to view this content.

Does the "another sheet" need to have historical data or can it be a current representation of the data in the primary sheet?

Do you have a header in row 1?

Is it always Column C, G, H, I, K, R, S, and V which you need to transfer data from?

The another sheet is just a blank sheet, there will be aa header in row 1. Yes it will always be the same columns. Thanks.

Let me see if I can simplify my first question for you. Can I delete the contents of the second sheet each time the command button is pressed and rewrite all the rows in column u of the primary sheet, or do you need to maintain a history of column u regardless of future changes.

I would like to keep the historical data. Though if it just started over and searched all of u each time that would not be a problem.

Please Login or Register  to view this content.

This was awesome. Thanks for the help.