Copy cells by multply condition

Hi everybody,

I would like to ask your expert skill to solve a problem with VBA macro.
I have a workbook (CTM MOD.xls, uploded). This workbook contains 3 worksheet CRITERIA, DATA, RESULT.
I would like to collect all data (rows) in RESULT worksheet to meet the specific criterias in CRITERIA worksheet column B2:B24 and C2. In the RESULT worksheet could be copied those entire rows which is equal to CRITERIA/B2:B24 (OR) and CRITERIA/C2 (AND).

After that it would be useful if the macro could copy the CRITRIA/A2:A24 values (according to the value of CRITERIA/B2:B24) in the RESULT/F column.

In the RESULT worksheet I indicated the prefered result, I hope with that you can indentify more easily my goal.

The range B2:B24 and A2:A24 can be streched beacuse i have to add more data later. The macro should investigate the range as the last cell contains data (xlDown).

Thanks in advance for your help

This should do it, though I seem to get a few more rows of data than you did. You can put more than one computer in column C if you wish.

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

D is empty. But this will give you the syntax, you can adjust from there:

Please Login or Register  to view this content.