6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
This lesson shows how to split a large worksheet into multiple (separate) smaller worksheets. You'll take transactional data for three months into a separate worksheet for each Month's transactions. You’ll often find that data is easier to work with if you divide it into logically separated sections.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
This video comes from the "Working With Multiple Worksheets and Workbooks" session (Session 6 in our YouTube Excel Essential Skills free video training course).