Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell change
I have a range of cells that will users can put information in. If anyone of
those cells are entered then in a separate section of the same worksheet, those numbers are used to calculate a percentage. A B 1 2 3 4 5 Column B1 = A1 * A3 Column B2 = A5 * A2 etc etc. I want Column B to automatically generate the answer upon a change in Column A. I have read that worksheet_change would work.. but i'm not sure how that will work with implementation of change in several different cells. Any help would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell change
Are you sure you don't just want formulas in column B?
-- steveB Remove "AYN" from email to respond "Monique" wrote in message ... I have a range of cells that will users can put information in. If anyone of those cells are entered then in a separate section of the same worksheet, those numbers are used to calculate a percentage. A B 1 2 3 4 5 Column B1 = A1 * A3 Column B2 = A5 * A2 etc etc. I want Column B to automatically generate the answer upon a change in Column A. I have read that worksheet_change would work.. but i'm not sure how that will work with implementation of change in several different cells. Any help would be greatly appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell change
Its not clear from your description exactly what you're trying to put into
column B However, the following code will express the value entered in any of cells A1:A5 as a ratio to A6....put this in the sheet's code page Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1:A5")) Is Nothing Then Target.Offset(0, 1).Value = Target / Range("A6") End If End Sub "Monique" wrote: I have a range of cells that will users can put information in. If anyone of those cells are entered then in a separate section of the same worksheet, those numbers are used to calculate a percentage. A B 1 2 3 4 5 Column B1 = A1 * A3 Column B2 = A5 * A2 etc etc. I want Column B to automatically generate the answer upon a change in Column A. I have read that worksheet_change would work.. but i'm not sure how that will work with implementation of change in several different cells. Any help would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |