Hi,

I need help to create a macro/vba code that would consolidate
worksheets from different workbooks into one. All the worksheets being
consolidated have the same format. All the different worksbooks are
saved at the same location

For example under Y:DRIVE\REPORTS\ANALYSIS, the analysis folder will
have 4 or more workbooks with titles A, B, C, D, etc.. Each workbook
will have the 12 months Jan to Jul. If I want to consolidate all the
Month July worksheet into one workbook... how can I do this.

I have to do this everymonth consolidating each of the current months
worksheet. I just need to copy the individual worksheet/s into one
main for that month.

Thank you in advance for any assistance that you may provide.

Check out the copy paste merge examples listed here...

http://www.rondebruin.nl/tips.htm
--
HTH...

Jim Thomlinson


"Excel newbie" wrote:

Hi,

I need help to create a macro/vba code that would consolidate
worksheets from different workbooks into one. All the worksheets being
consolidated have the same format. All the different worksbooks are
saved at the same location

For example under Y:DRIVE\REPORTS\ANALYSIS, the analysis folder will
have 4 or more workbooks with titles A, B, C, D, etc.. Each workbook
will have the 12 months Jan to Jul. If I want to consolidate all the
Month July worksheet into one workbook... how can I do this.

I have to do this everymonth consolidating each of the current months
worksheet. I just need to copy the individual worksheet/s into one
main for that month.

Thank you in advance for any assistance that you may provide.

Hi,
look into Ron de Bruin web

http://www.rondebruin.nl/copy3.htm

to merge different worksheets into a Master

http://www.rondebruin.nl/copy2.htm

if this helps please click yes thanks




"Excel newbie" wrote:

Hi,

I need help to create a macro/vba code that would consolidate
worksheets from different workbooks into one. All the worksheets being
consolidated have the same format. All the different worksbooks are
saved at the same location

For example under Y:DRIVE\REPORTS\ANALYSIS, the analysis folder will
have 4 or more workbooks with titles A, B, C, D, etc.. Each workbook
will have the 12 months Jan to Jul. If I want to consolidate all the
Month July worksheet into one workbook... how can I do this.

I have to do this everymonth consolidating each of the current months
worksheet. I just need to copy the individual worksheet/s into one
main for that month.

Thank you in advance for any assistance that you may provide.