I am making a spreadsheet to track Breast cancer donations.
I have 7 colums, Date, daily total,running total,amt. raised by a certin time, person who raised it, amt. after that time, person who raised it.
I need to enetr yesterday's info every morning.
What I would like to do is to be able to open the spreadsheet and have the form dialog box open automatically. Then in put the info from there.
Is this possible and how would I do that, or how could I insert a button in one of the cells so when I open the spreadsheet I could go to A1 and click that button and it would open the form dialog box ??
Any help is greatly appreciated !!
Thanks
I have 7 colums, Date, daily total,running total,amt. raised by a certin time, person who raised it, amt. after that time, person who raised it.
I need to enetr yesterday's info every morning.
What I would like to do is to be able to open the spreadsheet and have the form dialog box open automatically. Then in put the info from there.
Is this possible and how would I do that, or how could I insert a button in one of the cells so when I open the spreadsheet I could go to A1 and click that button and it would open the form dialog box ??
Any help is greatly appreciated !!
Thanks