Hi,

I am making assembled components which consists of a number of parts.

When i finished the first component, i enter all partnames in a column.

When i need to make a second component (which is basicly a copy of the first one, but with a few added parts) i need to know which parts are allready created and which are new.

this will go on until i finished a section (a set number of components)

I really need help with the following issue:

I have succesfully created the selection between allready-made-parts and new parts by using 'Conditional Formatting', but need help with creating a list of all new parts per section.

i need to create a stacked column on a seperate sheet with only the new parts (cells with allready-made-parts have a red background color).

So i need a single column with all new parts per section on a new sheet.

If anybody could help me write the correct VBA code i would be most grateful!