Hi Everyone,
I am looking for a macro that would be able to perform this function in a table, with an example below
1. User starts with any cell in column E as the active cell
2. User presses Control+Shift+B to run the macro
3. Macro inserts a table row below the active cell
4. Macro inserts formulas into the newly created row that make the values in cells C, D, H, I and J equal to the cells in the same columns one cell above
5. Macro sets the active cell to column E in the newly created row
thank you - any help at all is much appreciated
I am looking for a macro that would be able to perform this function in a table, with an example below
1. User starts with any cell in column E as the active cell
2. User presses Control+Shift+B to run the macro
3. Macro inserts a table row below the active cell
4. Macro inserts formulas into the newly created row that make the values in cells C, D, H, I and J equal to the cells in the same columns one cell above
5. Macro sets the active cell to column E in the newly created row
A | B | C | D | E | F | G | H | I | J | K | |
6 | TableHeader1 | TableHeader2 | TableHeader3 | TableHeader4 | TableHeader5 | TableHeader6 | TableHeader7 | TableHeader8 | TableHeader9 | TableHeader10 | TableHeader11 |
7 | |||||||||||
8 | starting active cell | ||||||||||
9 new row | =c8 | =c8 | ending active cell | =h8 | =i8 | =j8 |
thank you - any help at all is much appreciated