Forum Discussion

Vicki_Giron's avatar
Vicki_Giron
Copper Contributor
Jan 23, 2023

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).  Result - 5 columns appear in the xcel spreadsheet with header and formula.  I have tried using the "if" formula in the columns to say if it's above 1 populate, if it's above 2 the next populates, etc...  Didn't work.  Not sure how to accomplish this but I am quite sure the program can.  Thank you!

 

Vicki

excel

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 23, 2023

    Vicki_Giron 

    Where should the columns appear?

    What should the headers contain?

    In which rows do you want formulas?

    What should the formulas look like?

    • Vicki_Giron's avatar
      Vicki_Giron
      Copper Contributor
      Jan 23, 2023
      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...

Resources