Excel macro help please

Posted by Manchester_man PM | on Thu, 21/02/2013 - 21:40 520 10 comments | report

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

Comments

There are 10 comments. Login or register to view them.

Have you tried

ACDWebb | Thu, 21/02/2013 - 22:21

Thanks

Manchester_man | Thu, 21/02/2013 - 22:30

Yes

ACDWebb | Thu, 21/02/2013 - 23:03

VT cashbook

thacca | Fri, 22/02/2013 - 08:10

Tables is a good

paulwakefield1 | Fri, 22/02/2013 - 08:37

Office 2013

ACDWebb | Fri, 22/02/2013 - 09:08

Is this cost/time effective ....

JC | Fri, 22/02/2013 - 09:19

It's horses for courses

paulwakefield1 | Fri, 22/02/2013 - 09:53

Wow

Manchester_man | Fri, 22/02/2013 - 10:57

Sorry posted twice

Manchester_man | Fri, 22/02/2013 - 11:53