Delete values from cell automatically
Please explain this i donot fully understand.
--
help a friend help you
"Dave Peterson" wrote:
I would use a table with all the possible values to get J31.
then in J31
=vlookup(front!g27,sheet99!a:b,2,false)
I'm not sure how the other stuff fits in.
ernie wrote:
Ok heres the situation:
in cell G27, on worksheet 'Front', contains the cpc codes, example C400, i
need to make cell J31 0% if cell G27 contains C401, if cell G27 contains C400
then cell J31 should remain as is (with the original formula, which is
=+Declaration!$H$5).
Another example is if cell G27 contains S702 then cells J31 and J34 should
be 0%.
--
help a friend help you
"Dave Peterson" wrote:
You could use a macro, but I think you'll have to share more info.
But could you use a formula in sheet2?
=if(sheet1!a1="C400","",yourotherformulahere)
ernie wrote:
How can i delete values from different cells on a worksheet by using a cell
with a drop down list, on another worksheet, with different codes. for
example if i enter C400 in a cell from worksheet1, it will delete values from
multiple cells in worksheet2
Is there anyway to get it to work?
thanks in Advance.
--
help a friend help you
--
Dave Peterson
--
Dave Peterson
|