Filtering cells from a Worksheet into another Worksheet

Have you ever felt overwhelmed with the prospect of moving specific filtered data from one worksheet to another? Trust me, you’re not alone! Initially, this task seemed like a mountain to me, but with a bit of exploration, I discovered it was simpler than I thought. Let me guide you through the process, using a practical example to make things crystal clear.

Imagine a spreadsheet with numerous columns, including segment, country, product, and so on, as depicted in the sample image. Our task is to filter data based on a specific country and transfer that filtered information to a separate worksheet. Here’s how you can do it:

1. Initiate the Filter

• Head to the ‘Home’ tab.
• On the left-hand side, you’ll spot the ‘Sort & Filter’ option. Click on it.
• Opt for ‘Filter’.

2. Select Your Filter Criteria

• With the filter option now active, drop-down arrows will appear next to each column name. For our example, let’s filter by ‘Country’.

• Click on the drop-down arrow for ‘Country’. A dialog box will emerge.
• Deselect ‘Select All’ since we’re interested in a particular country. Then, choose your preferred country (for instance, ‘Canada’).
• Click ‘OK’ to apply the filter.

3. Transfer the filtered data to a New Worksheet

• With the relevant data now filtered, it’s time to move it to a fresh sheet.
• Create a new worksheet by tapping the ‘+’ icon next to ‘Sheet1’ at the bottom.
• Copy your filtered data and then paste it into this new worksheet. Rename the worksheet for clarity, e.g., ‘Canada Sales Data’.

4. Continuing the Filtering Process (If Needed)

• If you want to further filter the data within your new sheet, say by ‘Segment’, you can do so. However, remember to turn off the filter on the original sheet first to prevent any glitches.

With these steps, I was able to streamline the data for ‘Canada’, neatly organized in a separate sheet. The beauty of this method is its versatility. You can replicate it for any other column or criteria. Happy filtering!

Gained something new? Show some love with a like, share, or comment.

Stay updated with my latest musings by subscribing using your email!