Copying certain columns from one sheet to another based on the value on one column

Originally Posted by Richard Buttrey

Hi,

Have you tried Advanced Data Filter?

Thanks for your reply.

It needs to happen dynamically, so it shouldn't have to be intervened at all.

I suppose this does need Macro to work.

Can someone please have a look and pitch in?

Many thanks,
TR