I would like to past a new worksheet into an existing workbook. The objective is the replace an existing worksheet with this new worksheet. Is there a way to use find/replace to have any formula references to the prior worksheet point to the new worksheet. Using Excel 2013 in Windows 7 Professional. Is it better to just paste one worksheet over the other?
Bookmarks