Hi,
Apologies if this is really easy but I cant find a way to do it.
I have a large amount of data. I autofilter this data to give me the data I require. I would then like to delete all of the other data and just leave the data I filtered.
I dont want to create another worksheet if need be.
I know how to select all the visible cells in a worksheet, is there any way to invert this after selecting them or just of just clearing the rest of the cells?
Thanks for any help.
Apologies if this is really easy but I cant find a way to do it.
I have a large amount of data. I autofilter this data to give me the data I require. I would then like to delete all of the other data and just leave the data I filtered.
I dont want to create another worksheet if need be.
I know how to select all the visible cells in a worksheet, is there any way to invert this after selecting them or just of just clearing the rest of the cells?
Thanks for any help.