Combine two columns from different worksheets

Hi and welcome to the board
One way would be to copy paste one of the columns underneath the other
Then select data - advanced filter
Check "unique records only"
Select if you want to filter in place or somewhere else ( if so sleect where)
OK

Thanks ArthurBr,

Is there any way to automate this? The two columns are from different worksheets that I import from a customer from two different sources.
The lists can change as more parts are added.

Maybe with a macro? (I've used the macro wizzard before, but definitely a
beginner)

Thanks

Thanks Rahul,

I've attached a sample what I'm trying to do.
sheet 1 is from one source, sheet 2 is from another source.
Sheet 3 is my combined parts list.

It shows the lists from sheet 1 and sheet 2 combined with
duplicates removed.

I'm trying to figure out how to do this automatically through a
macro or formula. Sheet 1 and Sheet 2 can contain different
total number of lines.

Thanks

Hi
Ron De Bruin has a macro to merge cells in one sheet.
Once this is done you can use the macro recorder to make the unique list

Thanks for help Arthurbr. It took me a while but I got it working.

Glad to help. Can you now kindly mark your thread as Solved?

Edit your original post
Click Go Advanced
Select [Solved] from the drop down where it says [No Prefix]
Click Submit.