Hello, i have designed a sheet that sources data from about 15 worksheets in the same workbook. I wish to delete these datasheeets and save as a template that i can then reinsert new datasheets using a macro.
My problem is that when i delete the datasheets, the references change from eg. '1BOTTOM'!A:A to #REF!A:A. Can i maintain that link even after deleting the source datasheet?
My problem is that when i delete the datasheets, the references change from eg. '1BOTTOM'!A:A to #REF!A:A. Can i maintain that link even after deleting the source datasheet?