| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data in Cell dependant on drop down lists
I'm trying to create an idiot-proof spreadsheet for our family business staff
wages: I have made a drop down list from January - December, and a second list from 2008 - 2019, these values form the headings of each subsequent page inc. staff payslips. I am able to select APRIL from a dropdown in cell B3; 2008 from a dropdown in CELL B5 ... BUT .... when those are selected I would like cell B7 to display "Pay Period 29/03/08 to 28/04/08" (or the appropriate Pay period for the month/year combination) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependant Lists (Data Validation) | Excel Discussion (Misc queries) | |||
| Data Validation w/ Dependant Lists on seperate Wookbooks | Excel Worksheet Functions | |||
| 3 way dependant lists | Excel Worksheet Functions | |||
| Show data dependant on selection from drop down box | Excel Worksheet Functions | |||
| Dependant Lists | Excel Discussion (Misc queries) | |||
Threaded Mode
