View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susy Susy is offline
external usenet poster
 
Posts: 21
Default Automatically insert rows with formula

HI,.........went to hlp to find outwhat is macro and what can I do with it
but the help explanatin are vague. I'm not familair to all th epossibilities
in Excell.

For example help told me to record a code,.......what do they mean with
code, formulas? and if so what fomula should I apply in thiss case?


"Pete_UK" wrote:

You would have to do it with a macro - record a macro (in relative
addressing mode) while you do it once, then you can apply a short-cut
key or button to run the macro whenever you like.

Hope this helps.

Pete

On Oct 5, 6:54 pm, susy wrote:
Hi my name is susy,

I'm working on a finacial structure that should be used for entry of data by
many person. I thought about locking the worksheet, but some else shoul be
able to insert a row a keep working withou messing with my formulas.

What should I do to automatically insert a row with the same formula at
least with the same formats?

susy