Worried Guy
New Member
- Joined
- May 11, 2002
- Messages
- 6
I've been landed with a stinker of a project by my boss with an even worse deadline.
I've got two major problems.
1. I have two cells, one is a drop-down list with numeric values 1-12 and the other is a blank cell that I want to change automatically with the selection of the first cell. It should be of date form with 1=April 2002 through to 12=March 2003 (Financial Year)
2. The next problem I have is that I want to link two spreadsheets so that the first sheet updates values in the second and the second spreadsheet looks to the first to check what month is selected so it can update the values in the correct cells. In addition to this <phew>, each time the drop-down list date in the first spreadsheet is changed, it checks those values in the cells in the second sheet.
I've got two major problems.
1. I have two cells, one is a drop-down list with numeric values 1-12 and the other is a blank cell that I want to change automatically with the selection of the first cell. It should be of date form with 1=April 2002 through to 12=March 2003 (Financial Year)
2. The next problem I have is that I want to link two spreadsheets so that the first sheet updates values in the second and the second spreadsheet looks to the first to check what month is selected so it can update the values in the correct cells. In addition to this <phew>, each time the drop-down list date in the first spreadsheet is changed, it checks those values in the cells in the second sheet.