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

Data Input using vlookup and sumif formula

webmax

Member
Hi

I am attaching the two sheets

1) Dashboard
2) Template Sample

My requirement is if run the macro automatically the balance data is fetch from the template sample sheet to dashboard sheet using vlookup formula

And the Success status data is fetch from the template sample sheet to dashboard sheet using sumifs formula.

I wrote the macro but it is not working.

Can u help how to fetch data from another workbook to different workbook. And also if the data even increased then i want to select the available range of data for vlookup and sumifs formula.

Regards
Shahul
 

Attachments

  • Template Sample.xlsx
    9.9 KB · Views: 4
  • Dashboard.xls
    38.5 KB · Views: 5
Back
Top