Copy data from multiple workbooks to mail file.

**visha_1984** · 04-25-2013, 05:10 AM

Hi,Team

I am copying & pasting data from workbooks to main master file there are 300 files ,So i want macro code that should copy data from workbooks to master file,
All workbooks in 1 folder.so finally i want to consilidate all workbooks into one master file.

any help greatly appriciate.

**ragulduy** · 04-25-2013, 05:26 AM

I use this sort of thing:

Please Login or Register  to view this content.

**visha_1984** · 04-25-2013, 05:35 AM

Hi,Yudlugar

Thanks for reply,ur code running but didnt copy data to master file.

**ragulduy** · 04-25-2013, 05:40 AM

Hi Visha,

I added a comment line:
'code to copy data

I don't know what data you need to copy from what sheets and where it is going so you will need to add that code instead of the commented line. It should look something like:

Please Login or Register  to view this content.

You will need some sort of counter to change where the data is pasted in the master workbook.

**visha_1984** · 04-25-2013, 05:55 AM

Hi,yudlugar

I have a 7 column in all worksheets ,copy that data and paste into master workbooks,and one workbooks contain 2 or 3 sheets.
in 1 col- party name ,2 col -address, 3 col- cityname, 4 col- mobile number, 5 col-date, 6 col-zone.