Insert Blank Table

Hi Guys,

I have a table on my spread sheet, I'm trying to use a macro to move the five totals at the bottom down and insert a new blank section ready for filling in. I don't know where to start with VBA so I've recorded this manually as a macro.

Surprise surprise it isn't working and isn't pushing the totals down correctly so they get overwritten, can someone please let me know when I'm doing wrong.

Please Login or Register  to view this content.

Thank you!!

hi neil__g, can you post sample workbook showing original data and result you are heading to?

example.xlsx

Example attached.

Thank you

please check attachment, press a button

Hi,

Thank you, that works great, I have another snag now, I've inserted a sum funtion into the totals, is there a way to make that take into account the new templates added?

Thanks

Ignore that last post, I've named all the cells on the template workbook, is there a way to copy the names over as well to allow me to reference the names for totalling the data?

Double post - Sorry