QuestionsReExcel
New Member
- Joined
- Dec 9, 2009
- Messages
- 3
(N.B. I'm trying to do this without VBA, which I don't know. I'm not sure it's possible, even with VBA...)
I'm trying to create a 'data entry form' (i.e. a sheet that looks like a data entry form, complete with Form Control checkboxes, text boxes, maybe some data validation drop down and/or form control combo boxes. I know Excel has a built in data entry form, but it's limited to 32 fields and lacks use of formulae, certain form controls (like check box or option buttons), etc.)
I want the data entered on this 'data entry form' to populate the correct cells in the correct rows on other sheets, such as the 'storage sheet'.
(I might have 25 cases on the 'Case' sheet. I'd like to look at a given case in a more user-friendly GUI. I know Excel can make forms look almost as goods as Access. The forms are good for entering data and entering data. It's easier, especially if one given row might have 150 or more different cells.)
Look at the screen shots on the lower right here: http://www.abacusgov.com/products/specialeditions/personalinjury.html to see the kind of thing I'm trying to emulate. In the latter four shots, a given case name is selected. Then, all the data entered goes to populate the correct cells on the given 'case name' row. I know Access is built for such a thing, but can Excel do it?
Is there a way to 'push' or 'send' the data from the entry cells to the CORRECT ROW on another page? I know Excel can 'pull' data from another cell into a given cell, but can Excel 'push' data from a cell into another cell? Or, regardless, is there a way around this?
E.g., if I have 50 rows in the 'storage sheet', corresponding to cases 1 through 50, and I open up the 'data entry form' on another sheet (by first selecting case name no. 43), is there a way to automagically send the data entered in the 'data entry form' to the underlying 'storage sheet' cells? (Apart from the fact is has to be the correct row.)
I know that if I have a Data Validation dropdown on the 'data entry form' that selects a given case name (case names are unique, sort of like a key field in Access), and I do the MATCH function on the case name selected in order to determine which row should store the data in the 'storage sheet', then I've figured out which row to put the info in. This would be helpful if I was doing it by hand, but that defeats the purpose of automation.
Please help! I've been up all night working on this for 12 hours straight and I can't think straight anymore. Help!!
I mean, what's the point of creating a data entry form in Excel for entering data if it can't be stored?! (And I'm not talking about VBA...)
I'm trying to create a 'data entry form' (i.e. a sheet that looks like a data entry form, complete with Form Control checkboxes, text boxes, maybe some data validation drop down and/or form control combo boxes. I know Excel has a built in data entry form, but it's limited to 32 fields and lacks use of formulae, certain form controls (like check box or option buttons), etc.)
I want the data entered on this 'data entry form' to populate the correct cells in the correct rows on other sheets, such as the 'storage sheet'.
(I might have 25 cases on the 'Case' sheet. I'd like to look at a given case in a more user-friendly GUI. I know Excel can make forms look almost as goods as Access. The forms are good for entering data and entering data. It's easier, especially if one given row might have 150 or more different cells.)
Look at the screen shots on the lower right here: http://www.abacusgov.com/products/specialeditions/personalinjury.html to see the kind of thing I'm trying to emulate. In the latter four shots, a given case name is selected. Then, all the data entered goes to populate the correct cells on the given 'case name' row. I know Access is built for such a thing, but can Excel do it?
Is there a way to 'push' or 'send' the data from the entry cells to the CORRECT ROW on another page? I know Excel can 'pull' data from another cell into a given cell, but can Excel 'push' data from a cell into another cell? Or, regardless, is there a way around this?
E.g., if I have 50 rows in the 'storage sheet', corresponding to cases 1 through 50, and I open up the 'data entry form' on another sheet (by first selecting case name no. 43), is there a way to automagically send the data entered in the 'data entry form' to the underlying 'storage sheet' cells? (Apart from the fact is has to be the correct row.)
I know that if I have a Data Validation dropdown on the 'data entry form' that selects a given case name (case names are unique, sort of like a key field in Access), and I do the MATCH function on the case name selected in order to determine which row should store the data in the 'storage sheet', then I've figured out which row to put the info in. This would be helpful if I was doing it by hand, but that defeats the purpose of automation.
Please help! I've been up all night working on this for 12 hours straight and I can't think straight anymore. Help!!
I mean, what's the point of creating a data entry form in Excel for entering data if it can't be stored?! (And I'm not talking about VBA...)
Last edited:
