What I am trying to accomplish is quite simple:
I have two worksheets: "Packages" and "Archive". Both worksheets have information in columns A:K from the 8th row down.
Whenever rows A:K in "Packages" worksheet (below the 8th) are all not blank (i.e. have text typed into them), I want the entire row to be cut, and pasted directly below the 7th row in the "Archive" worksheet (becoming the new 8th row of the "Archive" worksheet.
I feel like this should be really easy to do, but I haven't been able to figure it out.
any help will be appreciated!
Bookmarks