C
campaign
I have information on three seperate worksheets which I
need to compile onto sheet one. Each line of data is
attached to a person by an identity number in column A.
The problem I have is that on sheets two and three there
are more than one entry under each identity number, which
has to be transferred onto sheet one under the
corresponding person by identity number. Could anybody
suggest a formula that might retrieve several rows of
data from one worksheet to append to the corresponding
identity row on another worksheet?
need to compile onto sheet one. Each line of data is
attached to a person by an identity number in column A.
The problem I have is that on sheets two and three there
are more than one entry under each identity number, which
has to be transferred onto sheet one under the
corresponding person by identity number. Could anybody
suggest a formula that might retrieve several rows of
data from one worksheet to append to the corresponding
identity row on another worksheet?