Very new to this - so apologizes if this has already been answered. I did a quick check but didnt see anything.
I have a list (see below). As items are completed I am highlighting cells yellow - as an indicator. I would then like to create a list of items that have completed the item.
Is there a VBA code that can do this ? I have found some code but was not sure which should be used. A sample screen is below.
2 items are highlighted, and when the lists are made, the title is placed in item 2 and 3 , but no the others.
I have a list (see below). As items are completed I am highlighting cells yellow - as an indicator. I would then like to create a list of items that have completed the item.
Is there a VBA code that can do this ? I have found some code but was not sure which should be used. A sample screen is below.
2 items are highlighted, and when the lists are made, the title is placed in item 2 and 3 , but no the others.