Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

~ merge two spreadsheets with one sheet each into a new one based on m

- - - - -

  • Please log in to reply
9 replies to this topic

#1
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

***SOLVED ***

 

it's been solved.....

the solution from easiest to hardest are:

vlookup
www.asap-utilities.com/download-asap-utilities-free.php?file=1 (doesn't work for excel 2013 64 bit though :/
ms access

sorry i could not explain it better.... thank you..

 

*** OP ***

 

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.


Edited by office13broken, 03 September 2013 - 06:23 PM.



How to remove advertisement from MSFN

#2
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,669 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

Forget about Excel 2013.

 

This is "basic" spreadsheet use.

 

Post an example of the contents of first and second sheet.

 

Basically you want to use the VLookUp function on the third sheet:

http://office.micros...P005209335.aspx

 

jaclaz



#3
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

THANKS SO MUCH!! i found what i needed -- 

 

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

 

just curious, would vlookup be easier for this? or would be the same?

 

this is for making a map!


Edited by office13broken, 31 August 2013 - 05:19 PM.


#4
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,669 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

It depends of what you want to do. 

A "report" sheet made using vlookup and similar functions is "dynamic" and "connected" to the source worksheet(s).

Any change in the source will be "reflected" on the "report" sheet, you can have as many "report" sheets as you want, each one highlighting some fields or having fields in a given order, sorting them, etc.

In this case you would be using Excel as a "poor man's" database, where you have one or more sheets (separated or connected among them) containing "raw data" and one or more "report" sheets allowing to sort/visualize the data in any given form.

The use of consolidating functions built-in in Excel is a (very limited) subset of what you can do "manually".

 

jaclaz



#5
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

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

 

doesn't need to be dynamic (changes base on source data)

 

advise please?



#6
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,669 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

advise please?

I advise you to provide the example that I requested earlier. :whistle:

jaclaz



#7
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

it's 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 first post describes what the problem is though. it never mentions anything about dynamic and all these other things 

 

i don't know what you mean by 'report' sheet because this is for making a map

 

but making a map has nothing to do with the problem, just letting you know was all


Edited by office13broken, 02 September 2013 - 04:43 PM.


#8
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

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



#9
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,669 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

Look, you asked for advice, I gave some to you.

Please provide some example data.

 

You do not follow this advice, I cannot provide you with further ones.

 

I need an example actually a sample of the EXACT, SAME data you are working with, to be able to provide quickly (and hopefully) a solution to your issue.

 

Please do cooperate in taking the §@ç#ing guessing :w00t: :ph34r: out of the equation:

http://homepage.ntlw...ard-litany.html

 

Remember that is you that have the problem and someone else, in his/her spare time and for free, is trying to help you, why not making the life of this someone a little bit easier? :unsure:

 

jaclaz



#10
office13broken

office13broken

    Newbie

  • Member
  • 29 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

it's been solved.....

 

the solution from easiest to hardest are:

 

vlookup

www.asap-utilities.com/download-asap-utilities-free.php?file=1 (doesn't work for excel 2013 64 bit though :/

ms access

 

sorry i could not explain it better.... thank you..






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users