Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I merge info. from 2 sheets using common numbers in Excel?
I am trying to merge information from two different sheets. Both sheets share
a common item #. How can I get the information all together on one sheet using that one common item # as the link? Help... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I merge info. from 2 sheets using common numbers in Excel?
If the number only shows up once in each sheet and the information you want
to group is on one row,Vlookup() will probably do what you want, but without more details we can't be sure. if the grouping are more complex, or has multile rows on information, the method can get more complex, but shouod be doable. "Angela" wrote: I am trying to merge information from two different sheets. Both sheets share a common item #. How can I get the information all together on one sheet using that one common item # as the link? Help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can u add common info to a cells in a column with out doing @ cel | Excel Discussion (Misc queries) | |||
How do I merge or combine 2 excel worksheets by a common collumn? | Excel Worksheet Functions | |||
sort prob with Common info on more than one sheet | Excel Worksheet Functions | |||
How do I merge 2 excel spreadsheets containing some common info? | Excel Worksheet Functions | |||
Excel: how to merge data from 2 workbooks with 1 col. in common? | Excel Discussion (Misc queries) |