1 to copy only filtered records and 2 to paste into range ending by last row in next col

Hello All,

Happy New Year to everyone!

I would love to learn how to copy filtered entries only from one Tab to another using a Macro. When I record the Macro it records specific cells but I need it to work in a flexible manner as each time it will be different cells/rows to be copied.

I have attached a sample where I want the macro to filter column F on Sheet1 Tab by hiding "0" value from displaying and then copy the resulted rows in within columns B:K to Sheet2 Tab.

I have also got one more question regarding making a macro copy a formula in Sheet3 Tab that is in A2 and paste that formula in the Range - A3:A-last entry in column B. Is this possible to determine the flexible stop?

I appreciate your help. I hope there is someone who is able to give it a go and point me in the right direction. I don't know the coding and I am only learning it by recording macro and studying the text to see which part is responsible for what action. Therefore my knowledge is quite limited in the subject.

Thank you all in advance for looking into and giving it a go.

Simon

Try the attached.

Check it out,

Please Login or Register  to view this content.

Hello Both,

Thank you very much for your help.

I have tried both and davesexcel worked perfectly for me. I have had to tweak it a little and add a couple of things to make it work in my main file but this was it! Thank you very much for this!

@ AB33 - I think I have confused you a little with my idea and when I tried the macros from yours they were a little different to bring up what I wanted. Although I understood what they do and find them helpful as well. Thank you for giving it a go.