Dynamic formats/formulas

[Guest]

Hi

I've set up a number of dynamic ranges in a data entry spreadsheet and would like to know if it is possible to set up the sheet so that when the user types data into a new row , all the formats and formulas are copied down...

cells in rows would have borders and different font styles and a concat formula and an index/match formula.

Much the same as an access form.

Is this possible?

Thanks

Harry

 

[Frank Kabel]

Hi
this would require VBA. You may have a look at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm