Hello,

I am new here and for my daily work I need to copy data from one worksheet to another.
Till now I am using the filter option and copy everything manually, but as it takes some time I would like to automate this.

I already found this tread and modified it a bit to something that looks like my own datasheet, but I figured out that in this VBA code only limited data is copied. If I start of with "peaches" only, row A / C / E / G / I / K are copied to Sheet1...

Can someone help me with that? And is it also possible that - when re entering the "Command Button", first all data of Sheet 1/ Sheet 2/ Sheet 3 is removed and then copied? This in order to not have doubles listed.

Thanks for you help in advance!

Kind regards,
Eva

PS: See here the worksheet