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
Bookmarks