Copy Cells to another Worksheet Based on Multi Criteria

[cambralenta]

I read this thread that almost as the code that i need.

Please Login or Register  to view this content.

As the original author i want to paste only column A to E (without the field criteria column).
Please, someone can point me to changes that i have to make!?
Thanks in advance,
Luís

[tehneXus]

Hi,

please check the attached sample which contains test data from the other thread you mentioned and adapted code to copy only columns A-E: CopyToSeparateSheetsWithCondition.xls
if you need to change the number of columns again do this in "Resize(, 5)" where 5 is the number of columns starting at A

code:

Please Login or Register  to view this content.

[cambralenta]

I think I got it!
I´m using this:

Please Login or Register  to view this content.

Must test more to see if it works!

[cambralenta]

Hi tehneXus,

Just now i saw your reply. Your code works better for me I think.

Thanks