I need help with a formula that will be created on the spreadsheet, but will
place data in cells others cells based on the result.

I have a table of codes that is used in a form drop-down, or could remain
blank. Then based on the selection in the code drop-down, I would like to
either clear two additional cells in the form or enter text in each of the
two cells based on the code selection. I do not want the formula to be in
the two cells, because the user my need to type data when the one of the
codes is not applicable. Additionally, I have a code selection for
blank....which I would want to clear any data in the two other corresponding
cells. The form is used over and over.

At first I was thinking IF OR, but can't seem to get it to work when the
formula can't be in the cells for the result or clear previous data entered.

Any thoughts or areas of help to pursue, would be greatly appreciated!

Thanks so much for any help you can provide!

Office ButtonExcel OptionsFormulasCalculation Options

Like this:
http://www.mdmproofing.com/iym/tutor...o-calculation/

Make sure you read this too:
http://www.pcreview.co.uk/forums/thread-1790649.php

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"lldiel" wrote:

I need help with a formula that will be created on the spreadsheet, but will
place data in cells others cells based on the result.

I have a table of codes that is used in a form drop-down, or could remain
blank. Then based on the selection in the code drop-down, I would like to
either clear two additional cells in the form or enter text in each of the
two cells based on the code selection. I do not want the formula to be in
the two cells, because the user my need to type data when the one of the
codes is not applicable. Additionally, I have a code selection for
blank....which I would want to clear any data in the two other corresponding
cells. The form is used over and over.

At first I was thinking IF OR, but can't seem to get it to work when the
formula can't be in the cells for the result or clear previous data entered.

Any thoughts or areas of help to pursue, would be greatly appreciated!

Thanks so much for any help you can provide!

Just thought of something else. You can use this technique to seep up your
calculations:

Speed up Workbook:
put these at the beginning of your code:
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

and these at the end
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ryguy7272" wrote:

Office ButtonExcel OptionsFormulasCalculation Options

Like this:
http://www.mdmproofing.com/iym/tutor...o-calculation/

Make sure you read this too:
http://www.pcreview.co.uk/forums/thread-1790649.php

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"lldiel" wrote:

I need help with a formula that will be created on the spreadsheet, but will
place data in cells others cells based on the result.

I have a table of codes that is used in a form drop-down, or could remain
blank. Then based on the selection in the code drop-down, I would like to
either clear two additional cells in the form or enter text in each of the
two cells based on the code selection. I do not want the formula to be in
the two cells, because the user my need to type data when the one of the
codes is not applicable. Additionally, I have a code selection for
blank....which I would want to clear any data in the two other corresponding
cells. The form is used over and over.

At first I was thinking IF OR, but can't seem to get it to work when the
formula can't be in the cells for the result or clear previous data entered.

Any thoughts or areas of help to pursue, would be greatly appreciated!

Thanks so much for any help you can provide!