Automatically Update/Copy Columns between Sheets
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]
Want to read more?
Check out the full article on the original site