Moving information from spreadsheet B to A

C

Craig

I have two spreadsheets, let's say A and B. I have a
unique element in each spreadsheet that is the same in
both spreadsheets, say ABCDEFG isn in A and B. I would
like the move the row with 5 columns that contains ABCDEFG
from spreadsheet B to the row that contains ABCDEFG in
spreadsheet A and place the information in columns T, U,
V, W, X.
 
G

Guest

There will be no duplicates of the unique eight character
field - only one of each in A and B.

So I am basically trying to merge to spreadsheets based on
one column of information based on it matching in A and B.
-----Original Message-----
It would help to have some further information about your data:

Can you have duplicates in either spreadsheet (i.e. can
Click to expand...
ABCDEFG appear more than once in either or both sheets?)
Is there an exact 1 to 1 relationship between the data in
A and B, or is it 1 to many or many to many?
You probably want to have formulae in spreadsheet A
Click to expand...
columns T-X that will lookup the matching values from
spreadsheet B, but if there is not a 1 to 1 relationship,
you will need to anticipate that and decide how you want
to handle the duplicates.
 
Top