You say you have done all these things. It is unclear what you need help with.

What do you mean by autoadvance a row. Do you mean select A84. If so, what
determines what the row is. Are the printareas affected by this? If so,
how.

--
Regards,
Tom Ogilvy


"kevatt" wrote:


i have created in a worksheet 4 command buttons one for resetting a form
called (reset)this would clear all cells that would be pre selected
(built into program) one for printing a form in a pre selected print
area(ie from cell a1 down to a32 and across from m1 to m32) called
(print form) one for printing a 2nd pre (a44 down to a71 and across
from m44 down to m71) selected print area called (print invoice) one
called (new booking) once clicked it would need to auto advance a
row(would need to specify start cell ie a84) enabling the newly inputed
data to be duplicated into a log further down the work sheet all are on
the same worksheet need advice on how this could work.

thanx


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=523674