I have a workbook with multiple sheets. End users will be entering $
amounts throughout the workbook. On one specific sheet I would like
the format and formulas of the row above automatically copied into the
new row inserted. This needs to be limited to the one worksheet only.

I have seen David McRitchie's page and I don't think those will work
for what I want.

What is the best way to approach this task? I don't think an event
macro will work as users will be entering data into the sheet, which
cause the event macro to fire. I was thinking changing the command
menus would work, but can I limit that to only one worksheet in the
workbook?

Any guidance or coding suggestions are very much appreciated!!!!


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=537473