Building an excel VBA application to move data from various sheets and print non-duplicate entries

Method:

• Looping through sheets

• Looping through each cell

• Remote referencing

• Dynamic auto-adjusting range

• Create a list of unique names using formulae and VBA

• Using a conditional statement to print values if a condition is satisfied.

• Print the values in a list using .offset to control position with an anchor cell