copy formulas & format of row above when inserting a row, but only on 1 sheet
 

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

copy formulas & format of row above when inserting a row, but only on 1 sheet
 

You can use the command menus if you like and just add code in your macro to
check if the active sheet is the sheet you want, and to do nothing or
display a message box if it isn't.
You can also use a WorkSheet_Change event macro. Just write the code to
check if the Target.Count is equal to Columns.Count. If it is, chances are
that the user just inserted/deleted a row. HTH Otto
"Celt" wrote in message
...

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