• 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.

I need help for weekly dashboard - How to populate data from different Excels from my local drive folder into dashboard (another Excel)

B

BhanupriyaP

New Member
Please find attached spreadsheet with requested data with proper comments. Can this be automated? Need help.

Very time consuming weekly task. Appreciate your responses.
 
Last edited:
From the beginning we must transfer this post to the VBA. department
Code: 
Sub Update()
Range("H1") = ([H1]) + 7
End Sub
 

Attachments

  • Dashboard- Trial.xlsm
    32.3 KB · Views: 5
You must log in or register to reply here.
Back
Top