Automatically Update/Copy Columns between Sheets
Our take
I have a MASTER sheet where I input new Jobs in my table "tblMASTER" in Column A, and I want this column to automatically update/copy in "Sheet2" also Column A. The problem I'm facing is that I want it to automatically copy, even when I add a new row/Job Name to my "tblMASTER".
I found that it works fine if I don't create a table in "Sheet2". I just use "=tblMASTER[Job Name]" in my Sheet2 and it updates automatically.
However, I would prefer if "Sheet2" was an actual table that would also automatically add new rows to the table based on "tblMASTER". So essentially, if there are 25 rows (or Job Names) in "tblMASTER", then there will also be 25 rows (or Job Names) in the table from Sheet2.
When I try turning Sheet2 into a table, I either get #SPILL, or it doesn't update as I add to the MASTER.
I made a Sheet3 for reference. Sheet3 is a table, Sheet2 is normal. See screenshots attached. Version 2602.
Is this possible to do? Any help is much appreciated!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience