Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) |