I've created a cashbook excel worksheet for clients. Rows 3 down to row 30 has formulas in them. I've created a button and want to assign a macro that will insert say 10 cells at a time below row 30, that automatically include the formulas in the previous rows.
My worksheet has 30 rows and foot totals at row 31, but the idea of the button/macro is so that the client can press it and he will have 10 additional rows, with formulas, so he can enter more transactions.
Google is proving to be NOT my friend on this one.
Can anyone point me toward a code that will achieve this ?
Many many thanks