Every week I copy this table out of OneNote and paste it into five or six different excel books to get the totals from all of the pages in each book. How do I put this formula into a macro?

Labor =sum('*'!m48)
Equipment =sum('*'!m55)
Materials =sum('*'!m62)
Total =sum('*'!m65)
Hours =sum('*'!k74)



Labor, Equipment, Materials, Total, & Materials are text in column 1 and the formulas are text in column 2. The cells referenced stay the same each week.

With my limited knowledge of macros I was only able to record the process of pasting the table. It worked great until I attempted to use it later. The macro only pasted what was currently on the clipboard, so when I had other data on the clipboard, the whole thing was a colossal failure!

I have tried to learn about the syntax required to build the macro in VBA, but I really suck at it!

Any help at all would be greatly appreciated!!!

Thanks,
Karen