C
callmark1
11:39 AM 1/24/2009
Well this is so easy a child could do it! Problem is, I don't have a child
handy.
In my spreadsheet, I have a series of values that might (or might not) repeat.
If they DO repeat, then I want a column that I can click a drop-down box or
enter "Yes" (or "No") in order to fill the remaining cells that will have the
same value (or Not).
If they do NOT repeat, I want to enter "No" and then proceed to enter
whatever values ARE necessary for the subsequent cells.
I can't remember what this type of action is called so I can't even do a
proper SEARCH in HELP. I know this will involve some sort of "if-then"
statement, but I rarely work with those and was hoping someone could shove me
in a good direction. I think it should sound something like this--
"if collumn F = 'Yes', then fill collumn G (same row) with the same value in
collumn B (same row) ... OR ... if collumn F = 'No', then do not fill
collumn G (same row) with the same value in collumn B (same row), but rather
permit me to fill in something else without restrictions"
I tried typing this in but the little dog-wizard only sneered.
Oh, I have Excel in Office 2003.
Thank you in advance for the shove. : ^ )
Well this is so easy a child could do it! Problem is, I don't have a child
handy.
In my spreadsheet, I have a series of values that might (or might not) repeat.
If they DO repeat, then I want a column that I can click a drop-down box or
enter "Yes" (or "No") in order to fill the remaining cells that will have the
same value (or Not).
If they do NOT repeat, I want to enter "No" and then proceed to enter
whatever values ARE necessary for the subsequent cells.
I can't remember what this type of action is called so I can't even do a
proper SEARCH in HELP. I know this will involve some sort of "if-then"
statement, but I rarely work with those and was hoping someone could shove me
in a good direction. I think it should sound something like this--
"if collumn F = 'Yes', then fill collumn G (same row) with the same value in
collumn B (same row) ... OR ... if collumn F = 'No', then do not fill
collumn G (same row) with the same value in collumn B (same row), but rather
permit me to fill in something else without restrictions"
I tried typing this in but the little dog-wizard only sneered.
Oh, I have Excel in Office 2003.
Thank you in advance for the shove. : ^ )