I was wondering if there was a workaround for an issue i've been having.
I have 2 tabs (lets call them X & Y) which i delete every month and replace with the copy/move tabs option via an import macro. The tab names stay the same. I've linked some information to tabs X & Y which get deleted and replaced causing #REF errors. Is there a way to prevent this without having to copy/paste the information into tabs X & Y?
Bookmarks