formula cut and paste

[Guest]

Can you cut a row out and keep the formulas that were in that row?
Meaning if row 2 has a formula in a,b,c and d and the row continues out to
h. Is there a way I can cut row 2 out without the formulas from a,b,c and d
being cut. I highly doubt it, but i figure its worth a shot.
Thank you for your time

 

[Ian]

If you cut out the cells the data goes too. You can then paste the data
elsewhere. I suspect this doesn't answer your question. What did you want to
happen to your formulae?

 

[Guest]

a macro? ok... here's more detail. I input a trailer number and the
spreadsheet calculates charges for each individual trailer on a daily
basis(never changes format). I'm trying to move any finished trailers to
another spreadsheet(like archiving it), which then makes me ask. Is there a
macro that can be made for when the final column(charge) is filled, that
it'll then be moved to another spreadsheet? or will macros only work within
one spreadsheet?
Thanks