Merging data from several workbooks

[Guest]

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

 

[Ron de Bruin]

Hi Louise

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

 

[Guest]

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]

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