![]() Filter out any records that you don’t want to copy.Use the shortcut CTRL SHIFT L to display the filter buttons.Method 1 used the filtering capabilities in Excel. Want to shine as an Excel hero in your workplace? This free mini course will help to obtain your superhero status. Learn superhero formula hacks as well as printing, charting, PivotTable and VBA macro hacks.Īnd yes, the course is completely free! Enrol now for free. Use a VBA macro – this method is the most automatedġ0 Excel Hacks That Will Make You a Workplace Hero.Use the FILTER function – this method won’t work in Excel versions prior to Excel 365. ![]() ![]() ![]() Filter and then copy/paste – this method is easiest for beginners.In this tutorial I am going to explain how to copy records to another sheet based on a condition. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |