trying to archive need suggestions
 

I've recently set up a few worksheets(with the very impressive minds of the
people here) that has four consistent formulas across every row. Now Im
trying to be able to cut and paste a row to an archive without losing the
formulas or the formulas staying in their columns. Is this possible? Or do I
have other options, such as linking the worksheet so that it will archive
itself? I really dont know how to save or move this info without having to
delete the non formulated cells and then adjusting the whole worksheet.
Any help comes highly appreciated
Thank you
Bryan Bloom