←Back to Beyond Market Intelligence

February 20, 2026•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Having trouble with the logic on how to transfer info from one table to another

Our take

Are you struggling to transfer information between tables in your spreadsheets? With multiple tables across different workbooks and the complexity of tracking data updates, it’s easy to feel overwhelmed. Understanding how to identify the correct table and manage your Quality Assurance (QA) data is crucial for maintaining accurate reporting. This guide will clarify the logic needed to streamline your data transfer process. By mastering these steps, you’ll enhance your workflow and ensure your reports reflect the most current information available. Let’s dive in!

Hi Again,

First, a screenshot of both tables' headers

https://preview.redd.it/cukxw4bobikg1.png?width=615&format=png&auto=webp&s=69c1ceec4141b15ec691b33a4e24466520bb106a

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.

submitted by /u/Difficult_Cricket319
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Related Articles

My conditional formatting and data validation keeps breaking when it wasn't previously.I have a daily report I have to review and I built a workbook to make the process more digestible. Here is the basic structure of my workbook/worflow: Each day I extract a report to a CSV file. I save it in a designated folder and replace the previous days report. Sheet 1 has a power query mapped to where I save to report I refresh the data which updates the table. I apply some filters/delete items/sort rows (I deleted via deleting table rows). I have a macro button that sends all of my filtered and sorted data to my Daily_Maint table on sheet 2. Sheet 2 Daily_Maint table I have additional columns for manual data. One column on the end for comments (which has no issues). Second to last column is a review status column which has data validation to a list on a separate sheet (Completed, outstanding, system maintenance, circle back). I have (or had) conditional formatting for the list options to color code the list options (green,red, yellow, orange respectively). In another column (one which lists different users) I had conditional formatting to change the color for 2 specific users. In a column that lists client number, I have the cells formatted to insert letters before the numbers. Applied to the whole table I have conduit for atting which it looks at the column with client numbers (aka RM #'s) and when the number is diff from the cell above it, I have formatted a border across the whole table. (This visually separates groups of maintenance by customer). Once I have completed my review, I make a copy of the sheet and rename it to the date of the report. I delete the rows in the Daily_Maint table and do it all again the next day. Recently our drives were remapped and I had to remap my power query. When that happened my macro broke... Which didn't make sense because the macro and power query shouldn't talk to each other. As if by magic the macro started working again. What I'm struggling with: Data validation keeps breaking. This was rarely an issue before the remapping. But now it breaks every day and I can't figure out why. Conditional formatting for color coding keeps breaking. Origioally O tried applying it to =$O:$O which worked well until it didn't. I tried applying it to an absurdly large range like =$O$6:$O$20000 but after I delete rows it changes the applied to formula to what ever number was after the range I deleted. (Ex $O$500:$O$19500) Similar situation with the condition l formatting for the usernames. Tried =$M:$M and this worked really well for months... Until it stopped. Conditional formatting for the line to visually separate groups by customer. My original formula was =$F7<>$F6 applied to the full sheet. This would break every day but it was an easy enough fix I was fine living with. But after talking to AI I tried =INDEX($F:$F,ROW())<>INDEX($F:$F,ROW()-1). I thought it was a permanent fix because I tested it several times. But when I actually use it... It duplicates/breaks/still needs fixing every day. I've tried applying the formatting to "This Table", "This worksheet", and "Current Selection" and nothing is working. What am I doing wrong? Would it be more stable if I built everything on the worksheet and not in a table? I think I'm too close to it at this point to have any perspective and I don't have that much excel experience, most of my knowledge I've gained through building this spreadsheet. I appreciate any advice. submitted by /u/jazzlikebridge42 [link] [comments]