Hi
I want to create a worksheet where i have one button and 3 columns.
Column A = data that i paste in
Column B = data that i paste in
Column C = data with result
Buttun "run"
When user clicks on button. I want a VBA code to pick out all unique values and put them in Column C.
The idea is to compare the two columns (A and B) to each other so i can find what values are unique.
Each value in column A will be unique to it´s own column
Same with column B.
So i only want to find the values that are unique by comparing each cell to the other column.
How can i do this with VBA so i can run the command when pressing a button?
I want to create a worksheet where i have one button and 3 columns.
Column A = data that i paste in
Column B = data that i paste in
Column C = data with result
Buttun "run"
When user clicks on button. I want a VBA code to pick out all unique values and put them in Column C.
The idea is to compare the two columns (A and B) to each other so i can find what values are unique.
Each value in column A will be unique to it´s own column
Same with column B.
So i only want to find the values that are unique by comparing each cell to the other column.
How can i do this with VBA so i can run the command when pressing a button?