Delete values from cell automatically

[ernie]

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]

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

[ernie]

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]

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

[ernie]

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
>

[Dave Peterson]

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:
http://www.contextures.com/xlFunctions02.html

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

ernie wrote:
>
> 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
> >

--

Dave Peterson