| 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 |
| 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 | |||
Threaded Mode
