Office & Productivity Software forum

General discussion

Combine Lists

by entrecon / May 16, 2006 2:45 AM PDT

On regular basis I have a need to combine sets of data in Excel. I have several teams working on projects and they submit lists of items in Excel. All of the Excel files have the same column headings, but the data underneath is different. I would like to combine this data into one master list. I looked at the concolidate, but this wants to do a calculation. I just need all my lists combined.
for Example:
Sheet 1: Items to be completed Phase 1
Sheet 2: Items to be completed Phase 2
Sheet 3: Items to be completed Phase 3
Cheet 4: Combined list of items to be completed in all phases

Discussion is locked
You are posting a reply to: Combine Lists
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Combine Lists
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
by Kees Bakker / May 16, 2006 6:10 AM PDT
In reply to: Combine Lists

If a macro is acceptable, that seems easy. I won't supply detailed and tested code (sorry for that), but I can give some elements to combine. I've got the impression you would be capable to finish it.

Did you ever consider to use MS Access for the combined lists (if you want to stick to MS Office)?


Collapse -
Thanks...found one
by entrecon / May 16, 2006 12:40 PM PDT
In reply to: Macro?

Thanks Kees,

I did find a macro that will work. I just wanted to make sure I wasn't missing a built in Excel function for this.

I agree that a database would be better, but most of the staff is using and is familiar with Excel. It would be a culture change to get them to use Access.

Popular Forums
Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions


Help, my PC with Windows 10 won't shut down properly

Since upgrading to Windows 10 my computer won't shut down properly. I use the menu button shutdown and the screen goes blank, but the system does not fully shut down. The only way to get it to shut down is to hold the physical power button down till it shuts down. Any suggestions?