• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Productivity Report

Hi ,


Like I mentioned in my last post , I'm having problems uploading a workbook which contains macros. This is the reason I copied and pasted the macros over here. Can you copy + paste these macros from here into your workbook ?


Narayan
 
Hi ,


Open your Summary_Report.xlsm ( the file extension has to be .xlsm since these macros need to be saved ) , click on the Developer tab , Visual Basic ; you should see the Project explorer window.


Under an item labelled VBAProject (Summary_Report.xlsm) , you should see an item labelled ThisWorkbook. Double click on this ; a blank window should open up. Copy the code that is posted here into that.


Make the changes necessary to tailor the addresses to whatever your worksheet data requires. Position your cursor in the Incorporate procedure , and click the Run button.


However , I suggest that if you are not familiar with macros , and you need to run these on a regular basis , it would be better if you took the help of a colleague or friend who is more familiar with Excel macros to help you out , since you might to need to modify this in future.


Narayan
 
You must log in or register to reply here.
Back
Top