Hi,

I have a ever changing column of data (in no of rows). The starting point is given to C2. In this column I have the following values to pick a few:

BB
NT
BB
NO
CB
LE
WO
WO

What I want to do is consolidate these values and paste under the existing values in column C (previously Ive used Selection.End(xlDown).Offset(1, 0).Select to find the end.

My problems are the following:
1. Consolidate does not work since it needs to specify my workbooks directory and sheet which will be changing from user to user and the sheet is created in the macro so it is not given a specific name.
2. Advance filter copy Uniques does not work for some reason, I get duplicates trying to use this function (these duplicates does not appear when i manually try consolidation).

As I said I can not specify a certain range however would work to choose entire C:D since rest is empty.

Does anyone have a good idea how to solve this?

Many thank you! I am sooooo stuck