Macro for multiple Filter

[Revathi kannan]

Hi all,

I need macro for the below requirements.

Filter only Column A which contains only Apple
Filter only Column B which contains only Blanks.

Then i need to paste only those 2 columns to the next sheets.. (need to lock the cells while pasting it to the next sheet)

[Revathi kannan]

any one here to help me out.....