Luke_Uk_Baggy
In Runtime
- Messages
- 320
Hi all, a quick query im having withing excel, cant think of what to put.
Basically, the whole spreadsheet is completed and filled with info, now doing stats page.
I have a field (Column D row 3) that is drop down list. I have another field (E3) that is dependant on whatever is selected in D3, via an IF (which is what im stuck on atm)
Heres the basic code (written logically) that i want it to do, with a rough example.
-----------------------------
IF
D3 = 'Week'
THEN Allow user to enter a xx/xx/xxxx format into E3
ELSE
IF
D3 = 'Month'
Produce a drop down lists of the months in E3
etc etc
-----------------------------
(Im then gonna run other IF'S and queries off the resulting data in E3, which will have been entered / selected by the user, and collected form various worksheets)
Shouldnt be too hard as D3 is a list, and will allways be one of 4-5 constants.
Etc, etc, I assumed I would be using a nested if.. I am pretty fluent in excel. just havent done this sort of 'multiple format' formula before. Anyone got the answer / or help / or point me to some direct reading on this specific area (most reading just talks about generalistic IF's etc)
Thanks in advance.
(if you need anything else as it might not be clear gimme a shout)
EDIT: Anyone ideas? or is it a case of VB coding?
Basically, the whole spreadsheet is completed and filled with info, now doing stats page.
I have a field (Column D row 3) that is drop down list. I have another field (E3) that is dependant on whatever is selected in D3, via an IF (which is what im stuck on atm)
Heres the basic code (written logically) that i want it to do, with a rough example.
-----------------------------
IF
D3 = 'Week'
THEN Allow user to enter a xx/xx/xxxx format into E3
ELSE
IF
D3 = 'Month'
Produce a drop down lists of the months in E3
etc etc
-----------------------------
(Im then gonna run other IF'S and queries off the resulting data in E3, which will have been entered / selected by the user, and collected form various worksheets)
Shouldnt be too hard as D3 is a list, and will allways be one of 4-5 constants.
Etc, etc, I assumed I would be using a nested if.. I am pretty fluent in excel. just havent done this sort of 'multiple format' formula before. Anyone got the answer / or help / or point me to some direct reading on this specific area (most reading just talks about generalistic IF's etc)
Thanks in advance.
(if you need anything else as it might not be clear gimme a shout)
EDIT: Anyone ideas? or is it a case of VB coding?
