Hi there, I have a status board that I'm trying to set up an automatic archive feature that takes a row of data and drops it into a separate archive sheet. I've gotten the code to move the data how I want, but now I need the rest of the data on the page to shift up and fill in the space.
I have one easy problem, which is I only want it to clear the contents in that row from Column A to T (Beyond column T I have a number of formulas that run metrics in the Archive sheet.)
And I have one not so easy problem. I need the rest of the data in columns A to T to shift up, but I can't just use .delete because I have other pages that reference the cells from this page. When I try .delete, it breaks the references in the other pages and messes up the display page. Here is the code I have so far:
Bookmarks