Conditional Formatting

[Worried Guy]

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.

 

[Mark W.]

On 2002-05-12 16:35, Chris Davison wrote:
sorry, so was I...

yours is obviously better, but the year increases when January is reached...(financial years) is this possible ?

=TEXT(MOD(A1+2,12)+1&"/"&YEAR(TODAY())+(A1>9),"mmmm yyyy")
This message was edited by Mark W. on 2002-05-12 16:59

 

[Worried Guy]

Thanks for all your help guys. I've cracked the first problem thanks to Sam.

It might be easier to conceptualise if I explain the second part as a kind of form/database structure. The first sheet acts as the form, initially capturing the data and also displaying any existing data with various subtotals and calculations.

The second sheet will be hidden from view and will contain the entered data, each month having its own named table.

Each input field on the first sheet needs to check the month and then the data can be correctly referenced to the named table on second sheet....

How do I do that?

 

[SamS]

Lee - have returned your spreadsheet with changes.

Mark/Chris - I didn't know you could do that with a vlookup but I also liked the CHOOSE function. I keep learning every day from this site.