conditional copy data from multiple workbooks

i want to copy the first 8 columns of data from every row in specified sheets in several workbooks if the column a value is "1" and paste it all into the first 8 columns of a new worksheet in the active workbook.

Can someone help with this please?

I've checked the forum and googled it but there are so many references I'm completely confused.

Any help would be appreciated and example data attached

Thanks

Louise

Try the attached macro workbook. You will need to set up the configuration as in the example.

OK

Change the code in module1 (alt F11) to

Please Login or Register  to view this content.

I've assumed that your specified sheet is called "Target".