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!
Bookmarks