Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formula
I know there has to be an easy way to do this. I have a
spreadsheet that I need to update on a weekly basis. All the report weeks are in 1 column and they need to be updated to increase by 1 each time I update the sheet. Is there an easy way to write a macro to update the cell to increase by 1. Ex. Field A Field B Mail Date Report Week 05.14.04 3 03.31.04 9 03.17.04 11 I want it to update to 4, 10, and 12 Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |