software

What I am trying to do:
I have a bunch of data on SHEET1. If the value of A7 lt;= 0 I would like
to have a button show up in P7 that says OVE? If you click that
OVE?button it will cut B7 through H7 from the sheet and append it to
SHEET2. Then go back to SHEET1 and (I guess) move up B7 through H7. The
problem is there are formulas in A, I, J, K, L, M, and N. so I just
cant CUT the whole line as it will mess up all my formulas.

Thank you very much for your help in this matter.

Ken--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=537258Do your formulae in A etc reference cols B:H? Iow, If you cut say B7:H7, how
would this affect I7:N7? Being in the same row it is reasonable to suspect
that the data isa all related in some way. If it is, and you move B8:H8 up
to row 7, your formulae in I7:N7 will end up with a #REF! error, and you do
not want that!

quot;sungen99quot; wrote:

gt;
gt; What I am trying to do:
gt; I have a bunch of data on SHEET1. If the value of A7 lt;= 0 I would like
gt; to have a button show up in P7 that says ?OVE?? If you click that
gt; ?OVE??button it will cut B7 through H7 from the sheet and append it to
gt; SHEET2. Then go back to SHEET1 and (I guess) move up B7 through H7. The
gt; problem is there are formulas in A, I, J, K, L, M, and N. so I just
gt; cant CUT the whole line as it will mess up all my formulas.
gt;
gt; Thank you very much for your help in this matter.
gt;
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=537258
gt;
gt;