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

"Grandslam90" wrote:


Not that I know of :-)
Depending on what you want to do you could copy the row and paste the
data as values elsewhere, anssuming you want to work with the data that
you are copying.

Alternatively, if you have a standard form (i.e. never changes in
format), you could write a simple macro to empty the cells from column
e out to column h.

Difficult to really help as it's not entirely clear what you want to
do. Hoep this helps though.

Mike


--
Grandslam90