Importing/Syncing Excel File
I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a new sheet and my formulas won't reference the new sheet. Copying and pasting doesn't work either as I'm over the 500 row limit.
Any ideas on a solution?