Copy data from several worksheets to one existing worksheet

I have a delicate problem which I found some input on through various searches, however not a perfect match for my specific problem. The code below almost nails what I want to accomplish, but I haven’t been able to figure out how to tweak it due to my weak VBA knowledge and hope that some of you gurus can help (it would save my day). Basically, the code below merges all worksheets from x to i into a new file named master (same structure required for all worksheets). What I want to do is to merge three specific sheets into an existing worksheet (which in turn contain formulas to do various calculations with the imported data). Hence, create an automatic model without the need of copy/paste.

I have a workbook with three worksheets (named Sub A, Sub B and Sub C), which has the exact same structure – headlines and data from column A-J with various number of lines for the three worksheets.

I want to merge the data (column A-J) from the three worksheets into an existing worksheet named Output, being able to keep the formulas in column L-X. My goal is by using the macro update monthly figures from these three worksheets with a click of a button.

Thanks in advance!

Please Login or Register  to view this content.

e.nekram

Something like this? Put the code into a standard module.

hth

gmk

Please Login or Register  to view this content.

Thank you gmk, your magic worked perfectly well!

Just that little obstacle left in the model, now it works very smoothly!

You saved my day

e.nekram

Glad to help.

Perhaps then you would be kind enough to mark as solved and maybe use the star as well.

gmk

Sorry

Done! 5 stars for the excellent work!

Hi, great work with this!

I am trying to do something which is more simple than this but I still can't figure it out!

All I want to do is copy a selection of worksheets with exactly the same headers on them into one consolidated worksheet.

I have tried to amend the code above but with no success!

Any chance you could help?

Cheers

e.nekram

Done!

Not quite. If you intend to add to reputation you need to click on the star at the bottom of the reply.

Thanks.

gmk

staceyburton66

Welcome to the forum. Please check out the rules on posting. Rule 2 applies.

If you still haven't managed to adapt the solution to your own wbook then start your own thread explaining your particular circumstances.

Thank you.

gmk