If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form validation determines which sheet to add data
Let's say I'm creating a form that a non tech savvy used car dealer uses to
enter his newly acquired vehicles to the excel workbook. Each sheet of the workbook is a unique model year of the car. (That would allow him to quickly refer to all vehicles of a given year.) On the input form, I would like validation such that if he selected "2006" from the drop down list of vehicle years, the data from the form would be AUTOMATICALLY be added to sheet "2006", regardless of which sheet is currently showing at the time. What would the code look like? I suspect it may require several rows of "if ' ' =" sorta statements. |
#2
|
|||
|
|||
form validation determines which sheet to add data
Hi
Don't!! Enter all of the data onto one sheet, with a column for Year, then turn the data into a List (XL2003) or a Table (XL2007) XL2003palace cursor within data areaDataListclick my List has headers XL200tpalace cursor within data areaInsert tabTableclick my Table has headers You will now have dropdowns at the head of each column. Use the dropdown on Year to select 2006, and you will see a filtered list of all 2006 Cars Similarly, if one of the column headings is Fuel, with entries of petrol or diesel, then the list can be quickly filtered to show only the cars of a given fuel type Equally, you can choose to sort the whole set of data by any of the column headings you have used for your table. -- Regards Roger Govier VTkelly wrote: Let's say I'm creating a form that a non tech savvy used car dealer uses to enter his newly acquired vehicles to the excel workbook. Each sheet of the workbook is a unique model year of the car. (That would allow him to quickly refer to all vehicles of a given year.) On the input form, I would like validation such that if he selected "2006" from the drop down list of vehicle years, the data from the form would be AUTOMATICALLY be added to sheet "2006", regardless of which sheet is currently showing at the time. What would the code look like? I suspect it may require several rows of "if ' ' =" sorta statements. |
Thread Tools | |
Display Modes | |
|
|