Hi,

I'm trying to link values from one worksheet to another (in same workbook).

I'm nearly there, but falling down on one area.

Say on sheet2 I have these values(in columns A and B):
C1 100pf
C2 100pf
C3 100pf
C4 100pf
C5 100pf
C6 100pf
C7 100pf
C8 do not fit
C9 do not fit
C10 do not fit
C11 100pf
C12 do not fit
C13 do not fit
C14 do not fit
C15 100nF
C16 100nF
C17 100nF
C18 100nF
C19 100nF
C20 do not fit
C21 do not fit
C22 do not fit
C23 do not fit
R1 100R
R2 100R
R3 100R
R4 100R
R5 100R
R6 100R
R7 100R
R8 100R
R9 do not fit
R10 do not fit
R11 100R
R12 do not fit
R13 do not fit
R14 do not fit
R15 do not fit


Then on sheet1 I have these entries (in columns A & B):
Quantity Value
8 100pF
5 100nF
9 100R

The numerical quantities above I'm getting from the formulae:
=COUNTIF('sheet2'!B1:B1006,B2)
=COUNTIF('sheet2'!B1:B1006,B3) etc.

This is great, and it works.
BUT...
say I change R15 from "do not fit" to 50R.
What I need is to populate column B on sheet1 with each unique text entry from column B on sheet2, excluding "do not fit", and have a new entry if enetered onto sheet2 added to the list in sheet1. (Tho the excluding "do not fit" part is not essential)

Is this possible ?

FYI: Microsoft Excel 2003 11.6560.6568 SP2