I have a number of tables on different Excel worksheets that are connected to various charts and are used in Named Ranges. I need to move them to a different worksheet (housekeeping before things get too far out of hand), but there doesn't seem to be a simple way to do so. I'm looking for something similar to the Move Pivot Table option, only for basic tables.
So, how do I move
Worksheet2!Table1 and maintain all of my links?
EDIT: What I've tried so far:
The obvious Copy & Paste, but that requires deleting data sources, renaming Ranges and generally mucking around with a lot of minor (but important) tweaking that seems like it should be managed by Excel. Oh yeah, and Google (to no avail).