VBA Help

[Jaffabfc]

Hi,

I am new to this page so i hope you can get me off to a flying start.

I have several spreadsheet all in 1 folder and inside these spreadsheets they have seperate tabs, 1 of them says Data. I want all this information from Data on all the spreadsheets in the folder to be transfered onto 1 spreadsheet.

I am talking over 600 spreadsheets and ranging from columns A:DF, i had something before but it use to try and save each file everytime something was copied and it just use to crash the system.

Can someone help please?

thanks

 

[VoG]

THis should get you started Merging Data from Multiple Workbooks into a Summary Workbook in Excel

 

[AlphaFrog]

Ron also made a free add-in

RDBMerge, Excel Merge Add-in for Excel for Windows

 

[Jaffabfc]

hi,

ive checked those but they dont really work.

how do it get the addon to work?

thanks