H
Harry Bo
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
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