copy and paste values to another sheet if value in one column matches condition

Hi
I am trying to copy data to another sheet as values only, if it matched value on perticular column.

VBA code to copy rows ( column A to Z) if value in Column C is 'rr' (Copy to sheet2 row 2 and below)

It over writes existing data in sheet2 ( sample book attached)

Any help please

Kind regards

I am not sure on overwriting issue.

Please Login or Register  to view this content.

If you want to first clear data in sheet2.

Please Login or Register  to view this content.

my favourite loop

Hi AB33,
Thanks very much.
This works great.
If I want to add another condition then what will be the code?
I tried but it will not work. e.g. condition 'cc' & 'aa'

Please Login or Register  to view this content.

Hi,
Another solution may be by formula in conditional formatting...

Link sheet1 to sheet2 and then do conditional formatting with formula to include...

Like Autofilter columns A to Zwith condition that rows visible if column C has values 'aa' and 'cc'
Other rows hidden or deleted....

Do you think this is possible.

Regards

Is it possible??

I am completely forgotten excel functions since I have immersed my self in VBA, but why do you go a formula route while I have provided you two different codes.

Hi AB33
Yes the second solution worked fine.
Great help my friend.
As always, I have clicked *
Many thanks.
I will treat this thread closed.
We can continue conditional formatting discussions for academic purpose.
Once a great help.
I have also posted new thread on closing excel book at certain times. Please have a look if you are free.
Thanks again
Kind regards

Thanks AB33

Hi AB33,
Just one more question which came up much later on your excellent code.
If I have to add more criteria , what exactly I should say? I tried many combinations but it is not working.

Please Login or Register  to view this content.

Kind regards
KK1234

Auto filter can handle two options only. You need to use array filter. Please see attached

Hi AB33,
Thanks a lot.
I was wondering why.
Thanks for your help again.
Apology for re-opening this one.
You always have been a star to help others.
Kind regards

I have again clicked * to thank you