I tried but I just do not know where to start. I need macro that would look
at Worksheet("DATA").range("B:B"), intentfy the destinct records and list it
on worksheet("shipping").range("B:B"). This must automaticly happen if
worksheet Data is populated. Advance filter does not work because the result
is on a different worksheet.

Thank you for all the help.