~ merge two spreadsheets with one sheet each into a new one based on matching ids. please

[exceltoohard]

hey im trying to do hobby project and i have this really big problem: im trying to merge two spreadsheets with one sheet each into a new one. they should be merged based on matching ids in column A1:A1000, so the outcome would not have duplicated ids.

im assuming this is a common need but i couldn't find anything for excel 2013

please advise. link to a good video guide would be helpful and good.

[:) Sixthsense :)]

If the data structure is same then use Pivot Table with Multiple Consolidation Ranges method.

[exceltoohard]

*** THANKS SO MUCH!!

i've never used a pivot table before but

i found what i needed -- http://www.youtube.com/watch?v=NYX3x32CeSg

i needed to know what the word 'consolidate' in excel meant. this is by labels, so 'top row' and left column'

sorry i could i not explain this any better :/

this is for making a map!

[exceltoohard]

sadly i need to request for aid again as i realised far too late that 'consolidate, from what i understand, only does numerical data...

advise please?

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[exceltoohard]

first sheet is just data from A-C1 : A-C1000

the same as the sheet you want to merge with

only difference is A2:A1000 would have similar ids/labels so the id would need to match upon merge and not be duplicated (the consolidate video shows how the outcome would be)

the first post describes what the problem is though.

everything is already there in the first 2 post for an advice to the problem

[jeffreybrown]

Your post does not comply with Rule 8 of our Forum RULES.

Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[exceltoohard]

it would be type B on http://welfarestate.com/Excel-Data-Matching-Merger/ but that script doesn't seem to work on excel 2013