thanks for taking the time to do this.
I'm a little bit over a novice level so pardon some quick basic questions if you don't mind:
I inserted the macro as is and obviously came back with an run time error 9, subscript out of range, when i debug it shows this highlighted in yellow:
'Clear current TOC
not sure what i need to change it too,
I inserted this in a brand new document too and it came back the same.
what would i need to change it to?
My summary sheet only has a few columns to track info:
Column A = Date
Column B= Customer name
the rest just have sales #'s so only B will be where the info will change.
Also, is this the only way to do this with a macro? Or can the cells in column B be set up initially to automatically change when I rename the ws. Maybe i will understand more / better when I see how you set it up.
|January 20, 2012
|February 28, 2012
||Phillips, Ryan & Maygen
If you could walk me through the steps to get this working.
I open the macro box in developer and create a new macro and save it as an excel macro-enabled file type.
When I run it with the new document I created it comes back with the same error.
Hope this makes some sense,