Copy row based on Cell value.

[dcgrove]

Hello, I have been using the macro below that I recorded to copy rows of data the Weekly Data sheet to the Report sheet based on the cell value. It is working well, but I would like to build some logic into it so that it will not copy any row that already exists in the target sheet. There will never be a repeating row of data in the spreadsheet so you could use the combination of the values in columns A&D in the Weekly Data sheet to compare to the values in columns A&D in the Report sheet. Sample Data is attached.

Please Login or Register  to view this content.

Thanks for any guidance!

Clayton

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[snb]

Let's do some codecleaning first:

Please Login or Register  to view this content.

[JBeaucaire]

Nevermind, not worth getting into.

[dcgrove]

Jerry, not entirely sure what I missed, but thanks for the help! I can always count on your suggestions to be top notch!

Clayton Grove