Merging data from several workbooks
 

I have approx. 30 workbooks that i need to consolidate into one book. They
all have the same column headings, however, the data underneath each heading
on every workbook is different.

Is there any way I can 'consolidate' these workbooks so all the information
is listed under the same headings, rather than copying and pasting???

Thank you.

Louise

Hi Louise

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Louise" wrote in message ...
I have approx. 30 workbooks that i need to consolidate into one book. They
all have the same column headings, however, the data underneath each heading
on every workbook is different.

Is there any way I can 'consolidate' these workbooks so all the information
is listed under the same headings, rather than copying and pasting???

Thank you.

Louise

Thank you for your reply, however, the user has no VBA knowledge whatsoever
and doesn't have a clue what it means?? Any other ideas??

Thanks.

Louise

"Ron de Bruin" wrote:

Hi Louise

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Louise" wrote in message ...
I have approx. 30 workbooks that i need to consolidate into one book. They
all have the same column headings, however, the data underneath each heading
on every workbook is different.

Is there any way I can 'consolidate' these workbooks so all the information
is listed under the same headings, rather than copying and pasting???

Thank you.

Louise

Thank you for your reply, however, the user has no VBA knowledge whatsoever
and doesn't have a clue what it means?? Any other ideas??

See this page
http://www.mvps.org/dmcritchie/excel/getstarted.htm
See David McRitchie's site if you just started with VBA

And try it


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Louise" wrote in message ...
Thank you for your reply, however, the user has no VBA knowledge whatsoever
and doesn't have a clue what it means?? Any other ideas??

Thanks.

Louise

"Ron de Bruin" wrote:

Hi Louise

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Louise" wrote in message ...
I have approx. 30 workbooks that i need to consolidate into one book. They
all have the same column headings, however, the data underneath each heading
on every workbook is different.

Is there any way I can 'consolidate' these workbooks so all the information
is listed under the same headings, rather than copying and pasting???

Thank you.

Louise