Changing data on a sheet with a selector

Hi,

I have a question about the following:

I need to make a document with some data that gets collected on a monthly basis. This document could have multiple tabs (e.g. 12 in total) for every month of the year. However, I'm wondering if there's a way to have the data on the sheet change by selecting a different month. That way I can keep the file to just one tab and select a month to display the right information.

I hope you understand my question and if not, let me know so I can clarify.

Deaz

Posted on Apr 17, 2021 2:40 PM

Similar questions

1 reply

Yellowbox

Level 7

22,493 points

Apr 17, 2021 5:44 PM in response to deaz_

Hi Deaz,

The single cell table "Choose Month" is a Pop-Up Menu.

Formula in C2 of Table 1: IF(Choose Month::A$1="Show All","Show",IF(A2=Choose Month::A$1,"Show",""))

Now apply a filter

The Show All option is like turning the filter off to allow you to add more rows.

Regards,

Ian.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Changing data on a sheet with a selector

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up