is there a way to copy the formulas of the cells when inserting a new row?
is there a way to copy the formulas of the cells when inserting a new row?
only by writing a short macro that inserts a new row, rather than using insert, row. Then within that macro you can insert code to copy formulas. You can do all this with record new macro, but make sure you use relative references,
Position cursor in cell G1 - assuming you want a new row after row F. Tools, macro, record new macro, select relativ references, insert, new, row. Highlight row F, edit copy, highlight row G, edit paste, STOP MACRO.
Now go to Y1 for example, and run the macro. It will create a new row and copy down the formulas from row X.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks