• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Opposite of Vlookup: join lists into one master list

R

raggd

New Member
Good morning (or evening) everyone,

I've been looking around on the forums and not found anything yet (or maybe I am using the wrong keywords).

I have 7 sheets each with identical column headings. Each is filled out by a different business unit and in effect is a 'dynamic list' as information is contantly being added to each list. Values are both text and numerical.
I would like to join/merge/consolidate these lists into one master list, that updates when someone adds to a list, but doesn't overwrite the previous data.
For example:
Heading A B C
Dave 2 z
Hannah 1 c

Heading A B C
Chris 2 x
John 1 f
merges to give:
A B C
Dave 2 z
Hannah 1 c
Chris 2 x
John 1 f

Many Thanks for your time.
 
Hi!

I've uploaded na exemple file where I do exactly what I believe you want to do...

In my exemple there's:
  • 3 sheets named List1 List2 and List3 with sample of lists such as the one you want to join in a master list.
  • A sheet named AuxiliarySheet with some auxiliary data I need to apply my method of doing what you need
  • A sheet named MasterList with some auxiliary columns on the left and your final master list of columns E, F and G, shaded in green
I dont really have time now to explain it, im sorry, but it is somehow self explanatory, just walk around a bit and you'll hopefully understand what it does.

If you add elements to the sample Lists, just copy paste the last line of the master list sheet down as far as you want and it will fetch the data on all the 3 lists...
If you want to add a new List, mind that the columns must be the same, with the same headings, and add a 4th list to the auxiliarySheet table.

I have to go, I hope this will be helpfull.
Leave any comments or questions here and Ill get back to you in a couple of hours.

Bye!
 

Attachments

Hi Nunes,

Thanks for the example file, a quick look seems to be the right thing! I will have a more in depth look this afternoon but i think the auxiliary sheet is a great help and i can understand the process you used.

Deepak,

VBA is undesirable unfortunately so I try to stick away from it unless there is no other way.

Thanks for your help!
 
You must log in or register to reply here.
Back
Top