How to copy and paste filtering criteria together with data in excel

Hi Everyone,

I am trying to copy some data with useful filters, though, I don't need all the columns and I am trying to tidy up this data based on my research needs. I tried to make use of the data-advance- copy filter, but it didn't/doesn't work. can you help me, please?



In attached file please see CICES V5.1 TAB. This excel file is from a public domain.


Thank you

Sarah

Unfortunately the attachment icon doesn't work at the moment.

So... for a new thread (1st post), scroll to Manage Attachments

and for a new post in your existing thread click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments.

In both cases, the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.