Solved

Multiple Spreadsheets needs to be condense into one

Posted on 2013-10-24
3
197 Views
Last Modified: 2013-11-14
Hello, I have a spreadsheet that goes out to team members that input data into the sheet and send back but when they turn in the sheets we have to compile all the data into one sheet, my questions is, there has to be a better way to compile all of the sheets into one other than manually doing it ..... All of the fields are the same on the final spreadsheet
0
Comment
Question by:Deerek11
3 Comments
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 166 total points
Comment Utility
I would keep the sheet name the same, but the file name different. Then use VBA to create a new file, then read the xx files you sent out and received back (saved into one folder), copy all data into the new sheet.
If you need more help on the actual VBA code, let me know.
0
 
LVL 10

Assisted Solution

by:broro183
broro183 earned 167 total points
Comment Utility
hi Deerek,

I like Kimputer's idea & have done something similar in the past. Once the files are in the same folder I use a free add-in of Ron DeBruin's which will easily merge all the files into a selected file. RDBMerge is a user friendly way to Merge Data from Multiple Excel Workbooks, csv and xml files into a Summary Workbook.

rondebruin.nl/win/addins/rdbmerge.htm

hth
Rob
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 167 total points
Comment Utility
Excel has a very powerful built-in function to consolidate data from multiple worksheets. The advantage of this system is that the worksheets can actually be updated.
Read this link.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now