HI
Hope someone can help me.... I am guessing its some sort of INDIRECT, but not sure how exactly I go about it
I have the below example table. This is in a tab called "MAIN"
Also, I have tabs called "Team_A" "Team_B" "Team_C" etc.
These names are in Column D on the MAIN tab
What I need to do is have something that will extract all the lines to the correct tab.
(On my real data there are currently around 200 lines and 7 tabs, but more data will be added as I go along, so not really practical to filter and cut and paste as I want the data to be in real time, and not have anything missed.
Thanks
Hope someone can help me.... I am guessing its some sort of INDIRECT, but not sure how exactly I go about it
I have the below example table. This is in a tab called "MAIN"
Also, I have tabs called "Team_A" "Team_B" "Team_C" etc.
These names are in Column D on the MAIN tab
What I need to do is have something that will extract all the lines to the correct tab.
(On my real data there are currently around 200 lines and 7 tabs, but more data will be added as I go along, so not really practical to filter and cut and paste as I want the data to be in real time, and not have anything missed.
Thanks
Column A | Column B | Column C | Column D (TAB NAMES) | ||
Adam | Smith | Blue | TEAM_A | ||
Peter | Jones | Blue | TEAM_A | ||
Steven | Hayes | Green | TEAM_C | ||
Peter | Caddick | Orange | TEAM_A | ||
Andrew | Bell | Orange | TEAM_B | ||
Tim | Lovejoy | TEAM_D |