Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 15th 06, 04:10 PM posted to microsoft.public.excel.misc
ernie
 
Posts: n/a
Default Delete values from cell automatically

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

  #2   Report Post  
Old February 15th 06, 05:38 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Delete values from cell automatically

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
  #3   Report Post  
Old February 15th 06, 06:36 PM posted to microsoft.public.excel.misc
ernie
 
Posts: n/a
Default Delete values from cell automatically

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

  #4   Report Post  
Old February 15th 06, 07:49 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Delete values from cell automatically

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
  #5   Report Post  
Old February 15th 06, 08:36 PM posted to microsoft.public.excel.misc
ernie
 
Posts: n/a
Default 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



  #6   Report Post  
Old February 15th 06, 09:01 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Delete values from cell automatically

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
How do I automatically fill a cell based on another cell in Excel SouthCarolina Excel Discussion (Misc queries) 3 January 13th 06 12:52 AM
How to take a cell that has 3 values and make 2 more new lines Phil Excel Worksheet Functions 4 October 23rd 05 10:53 PM
How can I break values apart that are in the same cell? Phil Excel Worksheet Functions 3 October 4th 05 03:41 PM
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017