questions of copy

[KK1966]

Dear all?s

I?ve curious that?s if Vba can doing copy folder for all workbooks, if which?s possible that?s perfects to saving and kicking off a lot of my time, some one can help me that?s or tell me does it a possible or impossible!

Many folders named = Jan ??to December
In folders content workbook named = Jan 01 to Jan 30
Objectives are certain range form ?a6 to k6 at the workbook/worksheet/sheet1.

Can I have Vba help this just a click? To completes it the month data in a one workshhet



Regards
KK

[MaximS]

Do you need to copy only a6 to k6 from all the files (named like c:/Jan/Jan 01.xls) and paste to master file - each file is one row??

If yes then thats possible.

[KK1966]

Dear MaximS

Thanks your advise, that's YES, just the row A6 to K6, but that's i means to have all workbok copy's by the folders, here is a total 30 WB or above and it named to Jan 01 to Jan 30.xls.

is that really possibility, can u help me the cde or learn about it,


Thanks Very much