Forum Discussion
Macros and Programming in XCEL
Greetings, I would like to create a macro in XCEL which populates column headers and formulas based upon a number loaded into cell. Example: Cell G3 - 5 gets typed into the cell (number of years)....
Where should the columns appear?
What should the headers contain?
In which rows do you want formulas?
What should the formulas look like?
The column headers are Year 1, Year 2, Year 3, etc... - depending upon the number placed in the cell representing Number of Years. The formulas would be in the rows directly below the Year 1...
Thanks. What formulas do you need?