Merge Multiple Worksheets and Workbooks into One Worksheet

B

bosstone75

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello,

I've searched around and I'm having difficulty finding an answer for what I would think would be a relatively simple and common problem.

I have a user who has created multiple worksheets AND multiple workbooks with multiple worksheets (don't ask me why).

All the worksheets have exactly the same columns headings, so I could do a copy and paste, but I would have to do that for a hundred different worksheets.

2 questions...

Is there a quick and easy way to basically copy and paste all of the information currently contained in multiple worksheets into one worksheet?

ALSO

Is there a way to do the same thing across multiple workbooks? If you can only answer question one, it wouldn't be hard for me then to manually cut and paste across workbooks once I have the worksheets combined.

I haven't had any experience with Macros or VBA, so if you talk about that, I'll need a bit of extra support.

Thanks!
Bill
 
P

Phillip Jones, C.E.T.

your OS is seriously out of Date. It should X.5.8.

As to your problem that may not make a difference.
 

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

Top