Forum Discussion
Data entry solution
I want to create a data entry form that will enable me to add a weekly monetary value against a Identity number (rows D3:D252) and a weekly date (columns H2:BG2).
I want to the form to have the following headings:
ID Number: (any from 1-250)
Date: (a weekly date - 52/53 weeks)
Value: £
I want the £ value to be displayed against both the ID Number and the weekly date in the spreadsheet.
What is the best way to solve this?
8 Replies
- If I could add something to Mr. mtarler's comments and at the same time recommend to you,add a file (without sensitive data) and describe it in relation to the file in more detail about your plans. Thus help yourself to get a quick answer and to be able to propose the best possible solution to all others who want to help you. Win-win for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Example worksheet as requested
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.
