I have a document that I am having trouble with coding.
1st - the top row will remain locked (freeze panes).
I have added an active button that will add additional rows when selected.
Currently Column H is suppose to be a percentage. So I entered =average(g2/f2); however, the formula will remain when I need the colum to say Percentage Filled.
Also - I need the data to be locked once entered.
Lastly, I do not want the new rows to contain any highlighting.
I hope this makes sense. I've tried doing some of the coding myself but I'm not that great. I've attached the form.
Bookmarks