Merging whole workbooks???

  • Thread starter Thread starter TripoD
  • Start date Start date
T

TripoD

Hi all,

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

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

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

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

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

Cheers,

'Po
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
merging data/worksheets 1
Copy worksheet from one workbook to a master workbook 2
Compile data from several workbooks 1
Import worksheets from another workbook? 1
Merging worksheets within the same workbook 3
How do I merge/combine different workbooks with different sheets 2
Sharing workbooks limitations - Merged Cells 12

Back
Top