J
jonmarcr
I think there was a glitch at the last post because it hasn't appeared after
30 mins. So pls excuse the repeat.
I have to import from an external database two lists of data for further
importing into ACCESS
Both lists have start columns with "refno" and "name" then various other
columns with mixed data.
I cannot create one single import list because the number of rows are
different in each list - of course the "refno" and "name" are the same.
I need to be able to collect the data from the list with the small number of
rows and place it in a cell on the correct row in the list with the full
number of rows.
So sheet 1 might have:
refno name info1 info2 info3 - and for a particular refno have 10 rows
Sheet 2 might have:
refno name info3 info4 - and only have 5 rows for a particular refno
I need to collect the information from all 5 rows in the secondary sheet and
place it in a cell in each of the 10 rows where the refnos are the same of
the "master" sheet
I've tried using vlookup on a cell in sheet 1 to gather the information from
sheet that refers only to the appropriate refno but I can't make that work
because I cannot know how many rows I have to look at (it varies for each
case).
Maybe this is impossible without more sophisticated programming but any help
would be appreciated!
30 mins. So pls excuse the repeat.
I have to import from an external database two lists of data for further
importing into ACCESS
Both lists have start columns with "refno" and "name" then various other
columns with mixed data.
I cannot create one single import list because the number of rows are
different in each list - of course the "refno" and "name" are the same.
I need to be able to collect the data from the list with the small number of
rows and place it in a cell on the correct row in the list with the full
number of rows.
So sheet 1 might have:
refno name info1 info2 info3 - and for a particular refno have 10 rows
Sheet 2 might have:
refno name info3 info4 - and only have 5 rows for a particular refno
I need to collect the information from all 5 rows in the secondary sheet and
place it in a cell in each of the 10 rows where the refnos are the same of
the "master" sheet
I've tried using vlookup on a cell in sheet 1 to gather the information from
sheet that refers only to the appropriate refno but I can't make that work
because I cannot know how many rows I have to look at (it varies for each
case).
Maybe this is impossible without more sophisticated programming but any help
would be appreciated!