I have an Excel 2010 workbook with multiple worksheets.

Worksheet 'one' has column B holding values such as ',1,12,20,'
(starting at row 2) with adjacent cells in column C holding textual
comments relating to the entries in column B.

I need to search through column B and find the first cell holding ',1,'
and then copy the adjacent cell in column C to column D in worksheet
'two'. The search then needs to continue to find the next occurrence of
',1,' in B and copy the corresponding cell in column C to the next row
in column D of worksheet 'two'.

Some of the cells in column B of worksheet 'one' do not hold ',1,' so I
would prefer it if they did not provoke blank rows in worksheet 'two'.

Any help would be gratefully received!

TIA

--
F