Hi all,

I'm having a problem. I have a spreadsheet where the values in column C should contain all of the values in A (starting from C3 and A3). Column C may contain values that are not in A.

Effectively, what I would like the macro to do, on a button push, would be to look at the values in A, check to see if the values is in C, and if it is not, copy the value to the next available row in C.

Any bright ideas? All help is much appreciated.