First off, I am very new to Excel and am using Excel 2013
I have a report created in Excel. Currently the report requires users to copy and paste data into an existing table (old_table). I have created a database connection that loads the data into another table (new_table). These tables are identical.
I would like to be able to somehow link these two tables so that all the data in new_table gets populated in old_table because all the functions and macros reference old_table. I don't want to go through all the functions and update the reference. Is there any way to accomplish this? Or will I ultimately have to just do it the hard way and go through everything and change the reference to the new table.
Even if I deleted old_table and renamed new_table to old_table the reference would still not be the same one correct?