Download the featured file here: https://www.bluepecantraining.com/if...


Blue Pecan Computer Training Ltd offers onsite or online Excel training for businesses. Training can be delivered at your business premises in the southeast of England or via Teams wherever you are in the world. Visit our training page at https://www.bluepecan.co.uk

In this video I demonstrate how to copy records that meet specified criteria to another worksheet. I demonstrate three methods:

1) Use filters in Excel and copy/paste visible records
2) Use the FILTER function available in Excel 365
3) Use a VBA macro code below