What tools or software I can use to merge series of Excel in one

jana
jana used Ask the Experts™
on
I have given out 10 Excel for filling out forecast numbers, expected expenses, expected sales, etc and want to merges these 10 Excel to one.  Is there a tool for this or Excel has this capability?  What is the way to get this working?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
What do you want to merge? All to one sheet or each worksheet to one workbook.
AlexSenior Infrastructure Analyst

Commented:
Open up a new one,

Import the data

However, you've actually not detailed how you want it laid out? Do you want a sheet per person or do you want it formatted onto a single sheet?

Author

Commented:
OK, this is done now:

All department submit their scope of expenses and income in the coming 6 months via an Excel (these excel have pre-determined items like sales area1, expenses area1, etc.).  Then when all depts. fill out their excel, I have them sent to me.  My assistance begins copying those columns to a main excel, including adding all values and projections and other calculations).  

Besides doing the actual excel work of copying/paste, recalculate, etc., is there a tools design for this type of job?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Roy CoxGroup Finance Manager

Commented:
Are all the files exactly the same layout?

Author

Commented:
yes.
Excel Consolidate tool allows you to add a series of data that is reflected in different cells either within the same Excel workbook that you are working on or within other books.

https://www.aboutespanol.com/consolidar-datos-en-excel-1791109

Use translator to read the post in English

:)
Group Finance Manager
Commented:
If they are identical and you place all the sheets in one work you could create a Summary Sheet like the one explained here. There's also an example workbook.

If that's not an option then attach an example workbook

Author

Commented:
Thank you.

I was looking more of an external tool for Excel or add-on maybe.  Currently we copy/paste and most data is read in values from the excels.  We can keep doing this, it's just wanted to know if there was a solution out there less tedious and less need for user-validation.
Roy CoxGroup Finance Manager
Commented:
See if this tool from Ron de Bruin works for you

RDBMerge, Excel Merge Add-in for Excel for Windows

Author

Commented:
checked it out, but couldn't find an example to show it's potential.  Besides just merging data, is there anything fancy on it, like graphs, or tables, etc.?

Author

Commented:
any comments?
Roy CoxGroup Finance Manager

Commented:
I haven't used the tool but Ron's tools are usually good. You need to test it yourself

Author

Commented:
Thanx
Roy CoxGroup Finance Manager

Commented:
Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial