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

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=quot;C400quot;,quot;quot;,yourotherformulahere)
ernie wrote:
gt;
gt; How can i delete values from different cells on a worksheet by using a cell
gt; with a drop down list, on another worksheet, with different codes. for
gt; example if i enter C400 in a cell from worksheet1, it will delete values from
gt; multiple cells in worksheet2
gt; Is there anyway to get it to work?
gt;
gt; thanks in Advance.
gt; --
gt; help a friend help you

--

Dave Peterson

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 youquot;Dave Petersonquot; wrote:

gt; You could use a macro, but I think you'll have to share more info.
gt;
gt; But could you use a formula in sheet2?
gt;
gt; =if(sheet1!a1=quot;C400quot;,quot;quot;,yourotherformulahere)
gt;
gt;
gt;
gt; ernie wrote:
gt; gt;
gt; gt; How can i delete values from different cells on a worksheet by using a cell
gt; gt; with a drop down list, on another worksheet, with different codes. for
gt; gt; example if i enter C400 in a cell from worksheet1, it will delete values from
gt; gt; multiple cells in worksheet2
gt; gt; Is there anyway to get it to work?
gt; gt;
gt; gt; thanks in Advance.
gt; gt; --
gt; gt; help a friend help you
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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:
gt;
gt; Ok heres the situation:
gt; in cell G27, on worksheet 'Front', contains the cpc codes, example C400, i
gt; need to make cell J31 0% if cell G27 contains C401, if cell G27 contains C400
gt; then cell J31 should remain as is (with the original formula, which is
gt; = Declaration!$H$5).
gt;
gt; Another example is if cell G27 contains S702 then cells J31 and J34 should
gt; be 0%.
gt; --
gt; help a friend help you
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You could use a macro, but I think you'll have to share more info.
gt; gt;
gt; gt; But could you use a formula in sheet2?
gt; gt;
gt; gt; =if(sheet1!a1=quot;C400quot;,quot;quot;,yourotherformulahere)
gt; gt;
gt; gt;
gt; gt;
gt; gt; ernie wrote:
gt; gt; gt;
gt; gt; gt; How can i delete values from different cells on a worksheet by using a cell
gt; gt; gt; with a drop down list, on another worksheet, with different codes. for
gt; gt; gt; example if i enter C400 in a cell from worksheet1, it will delete values from
gt; gt; gt; multiple cells in worksheet2
gt; gt; gt; Is there anyway to get it to work?
gt; gt; gt;
gt; gt; gt; thanks in Advance.
gt; gt; gt; --
gt; gt; gt; help a friend help you
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Please explain this i donot fully understand.
--
help a friend help youquot;Dave Petersonquot; wrote:

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

I would use a table to retrieve the value associated with the thing you put in
G27 of the Front worksheet.

You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html

If that doesn't help, be more specific with what you tried and what didn't work.

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

--

Dave Peterson