Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation list in data entry form | Excel Discussion (Misc queries) | |||
Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
data validation list form sheet | Excel Worksheet Functions | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions |