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!!!!

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>