Can you do this in Excel
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.
|