You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Reply
Question marked as Top-ranking reply

Posted on Apr 17, 2021 5:44 PM

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.

Similar questions

1 reply

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.