Data Input using vlookup and sumif formula

[webmax]

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

 

[webmax]

Hi

Any body help on the above topic