View Single Post
 
Old 02-20-2023, 06:52 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 348
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by rkebab View Post
I would like to know if this is possible.

Set up Excel with a main tab, on a worksheet, followed by tab "a", tab "b", and tab "c."

Have it so a line of data on the main tab, identified by an a or b or c in one of the columns, will place the line of data on a list in the proper tab a or b or c.

As new lines of data are added to the main tab, it will continue to update in either tab a or b or c.

Thanks.
If you have the FILTER function, that would be one way of getting a filtered list meeting whatever criteria makes it A, B, or C material.

This video helped me: https://www.youtube.com/watch?v=Onudkw9DMlU&t=52s
Reply With Quote