Forum Discussion
Data entry solution
Shazzj333 it is unclear what you need or problem is. I would recommend a simple 3 column entry table with week, ID and Amount as the 3 columns. You can use Data Validation to make sure the week and ID meet those criteria and even make sure there isn't a duplicate already in the list. If you need to have a 'form' to print you can create that form to the right on that page and populate it unsing the last entry in those columns and then define that as the print area. But like I said I'm not clear on what or which problem you are having.
mtarler thank you for your response.
Hope the following makes my query a little clearer....
I have a spreadsheet which records charity donations.
There are 236 contributors, who all have an ID number which are entered in D3:D252
The amount donated needs to be entered against the ID number and the week date they made donation. There are 52 or 53 date headers depending on number of weeks in year which are entered in H2:BG2.
The person entering the weekly data is not proficient in using computers so rather than have them enter the data directly into each cell and be confused by all the cells, I was thinking it would be easier for them to open spreadsheet and enter data using a form that contained 3 entries:
ID No.
WEEK DATE:
VALUE:
My problem: Excel will not create a simple data entry form as my spreadsheet has too many fields.
I want the monetary value [VALUE] to be recorded in the spreadsheet at the relevant Id No. and week date within cell range H3:BG252 using the 3 entry headers given above, but I don't know how to do it.
I'm not sure which of the Form Controls in Developer tab (if any) will solve this problem, so I would be grateful for advice on how best to simplify data entry.