How can I merge different excel sheets in one

How can I merge different excel sheets in one
Mohammed DallagPetroleum ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alex Green3rd Line Server SupportCommented:
To confirm, sheets or workbooks?

https://www.ablebits.com/office-addins-blog/2015/09/01/consolidate-excel-merge-sheets/

guide for sheets there.

Also what version of excel?


Thanks
Alex
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
please find attached a workbook which has many sheets that I want o merge in one.
test.xls
0
Alex Green3rd Line Server SupportCommented:
Then use the consolidation tool that I've linked.

Thanks,
Alex
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mohammed DallagPetroleum ConsultantAuthor Commented:
I don't want to merge tables from different sheets. I just want to put the sheets on top of each other in one sheet
0
Alex Green3rd Line Server SupportCommented:
OK,

You're not entirely making what you want clear, so when you say you want them on top of each other in one sheet, what do you mean.

If you can explain it a bit better, I'm sure we can figure it out, you're not talking about cascading the sheets are you? So you have all 4 sheets available to view in 4 separate panes?

Thanks
Alex
0
Alex Green3rd Line Server SupportCommented:
https://www.spreadsheetsmadeeasy.com/excel-view-multiple-worksheets-at-the-same-time/

Take a look at that, is this similar to what you want?
0
Roy CoxGroup Finance ManagerCommented:
To achieve something like this then your data needs to be better organised. It looks like some kind of dump from a reporting software.

Which version of Excel are you using? You've attached an xls file. Try the code that I've added and let me know if it needs changing.
test.xls
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
I am using Excel 2016 and yes the data are not organized and I don't want it to be organized. I need just one sheet for all the sheets without taking care of the data relation.
0
Roy CoxGroup Finance ManagerCommented:
This may be better suited, it adds all the data to one sheet named Combined. Only the main data is copied.

Edit: saved the new file to 2016 version
test--1a-.xlsm
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
Sorry I don't want to combine the data. I just want to but the sheets in sequence in one sheet. like the all sheets in the attached file
test--1-.xls
0
Roy CoxGroup Finance ManagerCommented:
Is this what you mean?
test--1b-.xlsm
0
Robberbaron (robr)Commented:
can you do a macro recording of what you want to achieve with a couple of worksheets.  we can then use that to confirm output.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.