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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com