Hi all,

I have just started using excel at work after being rushed through a
basic/intermediate and advanced excel course.

However I have yet to see or be told a way in which I can merge
multiple worksheets from multiple work books into one workbbok with one
worksheet.

I currently have 8 workbooks with 5 worksheets in each and would like
to create one main master file on a single worksheet.

I know I can copy and paste all the sheets into one however Im sure
there must be an easier way to accomplish this task.

I have no knowledge of including vb scripts etc and my courses only
covered basic macros, so any help in a form that I could understand and
implement would be greatly appreciated,

Cheers,

'Pod


--
TripoD
------------------------------------------------------------------------
TripoD's Profile: http://www.excelforum.com/member.php...o&userid=16617
View this thread: http://www.excelforum.com/showthread...hreadid=314817

Hi TripoD

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



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


"TripoD" wrote in message ...

Hi all,

I have just started using excel at work after being rushed through a
basic/intermediate and advanced excel course.

However I have yet to see or be told a way in which I can merge
multiple worksheets from multiple work books into one workbbok with one
worksheet.

I currently have 8 workbooks with 5 worksheets in each and would like
to create one main master file on a single worksheet.

I know I can copy and paste all the sheets into one however Im sure
there must be an easier way to accomplish this task.

I have no knowledge of including vb scripts etc and my courses only
covered basic macros, so any help in a form that I could understand and
implement would be greatly appreciated,

Cheers,

'Pod


--
TripoD
------------------------------------------------------------------------
TripoD's Profile: http://www.excelforum.com/member.php...o&userid=16617
View this thread: http://www.excelforum.com/showthread...hreadid=314817