Hi Everyone,
I have two workbook, one is data sheet and another one is report sheet.
I am trying to pull out the values from my data sheet workbook to my report sheet wokbook.
I tried both sumifs and sumproduct, but both formula work once the source file gets opened.
I need a formula which can update the value without opening the source file i.e. datasheet workbook.
Datasheet Workbook ( Path :D:\SHIB\BUDGET 2017\Budget Report 2017 Presentation\Datasheet Workbook.xlsm)
<tbody>
</tbody>
<tbody>
</tbody>
Thank you so much.
I have two workbook, one is data sheet and another one is report sheet.
I am trying to pull out the values from my data sheet workbook to my report sheet wokbook.
I tried both sumifs and sumproduct, but both formula work once the source file gets opened.
I need a formula which can update the value without opening the source file i.e. datasheet workbook.
Datasheet Workbook ( Path :D:\SHIB\BUDGET 2017\Budget Report 2017 Presentation\Datasheet Workbook.xlsm)
Year | Quater | Budget Head | Amount |
2016 | Q1 | Professional Charges | 2000 |
2017 | Q2 | Professional Charges | 3000 |
<tbody>
</tbody>
Year | Budget Head | Amount |
2016 | Professional Charges | =Formula |
2017 | Professional Charges | =Formula |
<tbody>
</tbody>
Thank you so much.
Last edited: