Copy & Paste Row Based On Corresponding Cells

[strato1983]

I attached a workbook that needs to copy only the rows with corresponding cells that have data in them located in columns E, F, G, or H in sheet1, it does not matter what is entered in these cells, then paste the corresponding row values to the next available row in sheet2.

[stnkynts]

What do you mean by "corresponding"? Do you mean, for example, all rows in which E has a value in it? Do you mean that you want all rows with a value of 1 in colums E:H to copy to sheet 2? Something else?

[watersev]

see attachment

[strato1983]

Your macro works great! Can it copy and paste the values only? Great work!

[watersev]

check attachment

[strato1983]

Almost there! The copy & paste with values works but I found with both versions of you macro that each row is duplicate twice if there is a value in column E & F on the same row, three times if there is a value in E,F & G, and so on...

What it needs to do is only copy the row once if a single value is entered or if multiple values entered in columns E:H. I'm guessing your formula scans down column E copies each row it finds a value, then moves to column F, then G, and so on.

[watersev]

check attachment

[strato1983]

It works! Fantastic job!
thank you for all your help, I will be sure to "add to your reputation" on this forum as an excellent Excel guru.