Macro to copy data from other workbooks based on cell value

Morning,

I have about 10 workbooks that I want to be able to go into and get the data copied from them on to a master workbook, if a cell value is less than a certain number. It is ten or so separate workbooks and they will all be copied onto one workbook. I only want them copied if the cell value on that row is less than a certain number.

Can anyone help?

Thanks

Is this cell value that you are testing to see if it is < than this 'certain number' always in the same column on each Workbook?

Do you want this 'certain number' to be static or have a cell where you can enter its value?

Are all the other Workbooks in the same folder as the 'Master' Workbook?

Can you attach the Master Workbook and 1 of your other workbooks where the data will be copied from? That will make it easier/faster for someone to help you..

Yes it will always be in the same column.

It can be either...although for one of the sheets I'd want it to be different.

Yes they are in the same folder

Emm for the sample workbooks I'm not allowed to upload the actual things but i could possibly make a dummy set. It's just a simple table.

Hi..

Try the attached.. i have zipped a Master Workbook and 3 other dummy Workbooks..

Change the filepath in 2 places to your own... also. if they are .xls files (instead of .xlsx files).. change the following:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks very much. Looks good at first knockings. I'll try it in a few.

Cheers

k.. don't forget to extract the files into 1 Folder that has no other files...

Apo,

What do I need to change to get this putting the data into another set of cells in the master sheet?

Define 'another set of cells'...

Currently.. it copies the autofiltered data from the other Workbooks to the next available row on the Master sheet..

Where do you want the autofiltered rows copied to?

OK, yes that will work. Can I change the sheet that is copies to easily?

Also can I change the value for just one of the workbooks?

Hi..

Can I change the sheet that is copies to easily?

Just change these 2 lines..

Please Login or Register  to view this content.

Also can I change the value for just one of the workbooks?

Most things are possible.. but alas it is bedtime for me.. so I will look at that tomorrow..

Hi..

Please Login or Register  to view this content.

Thanks man, I'll give it a try