Рет қаралды 314,617
Download the featured file here: www.bluepecantraining.com/if-...
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at 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
------------------------