| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating another sheet using an On Change event
I have two sheets, one which has the latest price of an item and another
which maintains a history of the price per item, I need to be able to update the historical price on sheet 2 in the correct column when the price is changed on sheet1. Example Sheet1 Item Price A 10 B 12 Sheet2 Item Jan Feb Mar Apr... A 8 9 8 10 B 12 11 10 12 The values in sheet2 for April need to be updated by the changes to the values in sheet1 The column offset is particularly perplexing me! Anyone got any ideas Many thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the Sheet name without updating formulas? | Excel Discussion (Misc queries) | |||
| Cancel sheet change event | Charts and Charting in Excel | |||
| Excel VBA - Add Sheet Change Event at Run Time | Excel Programming | |||
| Sheet Name Change Event? | Excel Programming | |||
| Sheet Name Change Event? | Excel Programming | |||
Threaded Mode
