Move filtered data to new sheet, but keep all data.

Occasional Visitor

I am filtering data to get specific data values, but I need to move the entire data over even if it includes zeros. I have thousands of pieces of data so it will take hours to individually move the data. I.e. I filtered by operator and one type of product, but when I move the filtered product data, I need all operators data even if its empty. Is this possible?

1 Reply

@MrFacer I believe so. but can you upload a representative sample of your data, showing the the "raw data" and with an example of what you would like to copy over to the other sheet.

Which Excel version are you on? Mac or PC?