Copy & paste from summary sheet to 3 different sheets within workbook based one condition

[LukiiMaxim96]

Hey!

Through a macro I managed to adjust a report and automatically import it to Sheet1 starting in cell A2. A1:E1 are static column headers in each sheet. The .xlsm should be used as kind of "tool" to generate weekly reports.

Now I want to include another thing: Loop through the rows of Sheet1 and copy & paste row into Sheet2, 3 or 4 based a condition check in column E, which is volume in kEUR.

Origin:
Sheet1(Summary/Report)

Destination:
Sheet2(Volume <1 kEUR)
Sheet3(Volume >1 kEUR AND < 5kEUR)
Sheet4(Volume >5 kEUR)

Can someone give me a hint how to accomplish that?

Thank you in advance
Lukas

 

[Marc L]

​

Hey !​

​

I would use a filter or better an advanced filter, depending on where is located the criteria data and on the layout of each destination worksheet.​

 

[LukiiMaxim96]

​

Hey !​

​

I would use a filter or better an advanced filter, depending on where is located the criteria data and on the layout of each destination worksheet.​

....I am so... Indeed.. I could mirror the master to all three sheets and have a different filter running within each sheet... thanks......