D
driller
Hi again,
thanks in advance..
In Sheet1 (A2 ~ A1000) i have a master list of names.
In 6 other sheets (with varying sheet name) i have a list of concatenated
text containing names along Col. A.
I have a formula to extract just the names on the 6 other sheets (Col A)
Along Col B of other sheets i have a formula, e.g. B2 =LEFT($A2,LEN($A2)-15)
Now i need to compile all the extracted results (from 6 other sheets at Col
B) and
paste them in Col B of Sheet 1.
Then I will perform a sort operation and compare them with data @ Col A..
This is part of a checking procedure i need to perform to compare the
masterlist on sheet1 and the other as listed on 6 other sheets.
Maybe this can be done in excel in the master list of sheet1..
thanks in advance..
In Sheet1 (A2 ~ A1000) i have a master list of names.
In 6 other sheets (with varying sheet name) i have a list of concatenated
text containing names along Col. A.
I have a formula to extract just the names on the 6 other sheets (Col A)
Along Col B of other sheets i have a formula, e.g. B2 =LEFT($A2,LEN($A2)-15)
Now i need to compile all the extracted results (from 6 other sheets at Col
B) and
paste them in Col B of Sheet 1.
Then I will perform a sort operation and compare them with data @ Col A..
This is part of a checking procedure i need to perform to compare the
masterlist on sheet1 and the other as listed on 6 other sheets.
Maybe this can be done in excel in the master list of sheet1..