Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data between worksheets using reference index?
I'm not sure whether my query is similar to others, but I hope
someone can point me in the right direction. I have an excel file with two worksheets. On both are a list of branch numbers in the first column. I want excel to match the branch number from the first sheet to the second and import a column of data from the second (column c). Not all branch numbers present in the second sheet appear in the first. Be grateful if someone could give me some simple direction - tried to look at some excel websites and totally confused by them! Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data between worksheets using reference index?
"ler01kjh" wrote: I'm not sure whether my query is similar to others, but I hope someone can point me in the right direction. I have an excel file with two worksheets. On both are a list of branch numbers in the first column. I want excel to match the branch number from the first sheet to the second and import a column of data from the second (column c). Not all branch numbers present in the second sheet appear in the first. Be grateful if someone could give me some simple direction - tried to look at some excel websites and totally confused by them! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MERGING DATA FROM SEVERAL WORKSHEETS | Excel Worksheet Functions | |||
merging data/worksheets | Excel Worksheet Functions | |||
Data merging with 2 worksheets | Excel Worksheet Functions | |||
Merging data from 2 worksheets | Excel Worksheet Functions | |||
Merging data between worksheets using reference index? | Excel Worksheet Functions |