MachaMacha
11-28-2007, 08:16 AM
Hello All,
I have attached an image of what I am trying to do. In cell O11 there is a formula =B17+C10+...+M20+N11. I am trying to make a macro that each time I run the macro on an active cell, the formula is displayed in a new worksheet called "Formulas". I would like the formula to be displayed according to the column headings instead of the Column Labels (A-IV).
For Example
I run the macro on cell O11
A new worksheet in the same workbook called "Formulas" is created
In cell A1 of "Formulas" I get the location of the cell that the
macro was run on (Sheet1!O11)
In Cell B1 I get a string of the formula,
'AL17+AK10+...+ME11
Each time I run the macro, the cell location and formula should be added to the next cell offset by 1 row in the Formulas worksheet. Also sometimes the precedent cells may be from many different cells from different worksheets within the same workbook, not just from one worksheet like in this example. In that case I would like the Worksheet name to precede the cell reference. Assume that all row2's of every sheet has a column name/label/heading.
Thanks.
I have attached an image of what I am trying to do. In cell O11 there is a formula =B17+C10+...+M20+N11. I am trying to make a macro that each time I run the macro on an active cell, the formula is displayed in a new worksheet called "Formulas". I would like the formula to be displayed according to the column headings instead of the Column Labels (A-IV).
For Example
I run the macro on cell O11
A new worksheet in the same workbook called "Formulas" is created
In cell A1 of "Formulas" I get the location of the cell that the
macro was run on (Sheet1!O11)
In Cell B1 I get a string of the formula,
'AL17+AK10+...+ME11
Each time I run the macro, the cell location and formula should be added to the next cell offset by 1 row in the Formulas worksheet. Also sometimes the precedent cells may be from many different cells from different worksheets within the same workbook, not just from one worksheet like in this example. In that case I would like the Worksheet name to precede the cell reference. Assume that all row2's of every sheet has a column name/label/heading.
Thanks.