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