Hi, I have 2 issues and would appreciate some assistance please.
(1)
I wish that when entering certain predefined data in a cell that, that another cell enters a certain value.
As an example, IF cell D3 = "Comedy", the H3 should have 25.00
However if cell D3 has "Romantic", then H3 should have 10.00 etc. etc.
There being up to say 50 options for cell D3 and then 50 related amounts for cell H3.
The same equation then exists for D4 and H4 etc. etc
The list of items can be fixed and maybe of it were a drop down box of options that also be helpful.
Can this type of IF scenario be done in excel?
Thank you.
(2)
I wish that when entering a "Y" in a certain cell that it automatically take you to another area of the worksheet or to a separate worksheet or even a separate worksheet in another file.
As an example, IF cell F3 = "Y", then the cursor opens another worksheet or just automatically appears in an other area so that other data can be completed.
If F3 or G3 or H3 etc. etc. has "Y" entered, then I am prompted to another cell (maybe in another worksheet) to prompt me to put in certain data. That data will not be fixed, it will be different every time. it may be; director first name, director second name, genre of film, made in location country etc. etc.
The second of these is the least of the problems as at the worst I can just open a separate area and will just need to remember. Just a thought on the second issue, I wonder if say the "Y" flag is entered, that a warning note appears like a hint.
Anyway the first issue is the main one please so any assistance appreciated.
Again, many thanks
JohnBud
(1)
I wish that when entering certain predefined data in a cell that, that another cell enters a certain value.
As an example, IF cell D3 = "Comedy", the H3 should have 25.00
However if cell D3 has "Romantic", then H3 should have 10.00 etc. etc.
There being up to say 50 options for cell D3 and then 50 related amounts for cell H3.
The same equation then exists for D4 and H4 etc. etc
The list of items can be fixed and maybe of it were a drop down box of options that also be helpful.
Can this type of IF scenario be done in excel?
Thank you.
(2)
I wish that when entering a "Y" in a certain cell that it automatically take you to another area of the worksheet or to a separate worksheet or even a separate worksheet in another file.
As an example, IF cell F3 = "Y", then the cursor opens another worksheet or just automatically appears in an other area so that other data can be completed.
If F3 or G3 or H3 etc. etc. has "Y" entered, then I am prompted to another cell (maybe in another worksheet) to prompt me to put in certain data. That data will not be fixed, it will be different every time. it may be; director first name, director second name, genre of film, made in location country etc. etc.
The second of these is the least of the problems as at the worst I can just open a separate area and will just need to remember. Just a thought on the second issue, I wonder if say the "Y" flag is entered, that a warning note appears like a hint.
Anyway the first issue is the main one please so any assistance appreciated.
Again, many thanks
JohnBud