Quote:
Originally Posted by rkebab
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