Having trouble with the logic on how to transfer info from one table to another
Hi Again,
First, a screenshot of both tables' headers
The one in black is the source. Agent's Team Lead = Sheet Name in the destination wb.
The Orange is the destination, it's also in a separate wb.
The problem, there are two tables on each sheet. There are a total of 4 teams. The tables are named T1_In, T1_Ex to T4_In, T4_Ex.
How do I know which T? they are on?
Once I have that figured out, I need to check if they are already on the table.
...If they are on the table, I have to find out which QA it is (1st, 2nd, 3rd, 4th) based on which is empty
...If not, add them to the table
I can't seem to wrap my head around the logic in how to do the above.
The source of the sourceTable is a Power Query which pulls from am Excel file. It only has daily updates, meaning only shows new QA from the previous report. These daily reports are not saved, but the wb is.
The destination table will then become the source for other Power Queries on that wb's other sheets for daily reporting of the current state of the month.
[link] [comments]
Want to read more?
Check out the full article on the original site