List management

Hello Jessica,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding copying and pasting data to other locations. I presume you are referring to copying filtered data? If so, you don't have to use advanced filters unless the autofilter doesn't give you sufficient options.

Once you have chosen the filter options then you can select the data and copy. Then paste the copied data to wherever you choose.

If you do decide to use the advanced filter then place the criteria column headings above the data sheet and leave sufficient space to place rows of criteria. The list range is the entire data area and the criteria range will include the criteria headings together with rows of criteria. You can list the filter 'in place' or place the results in another location on the same sheet.

Once the filter has been run then copy and paste as before.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer