Hi,

Can anybody tell whether it possible to apply formulas like vlookup, countifs, sumifs etc to get record auto updated from different workbook.

It is known that to get record auto update in a worksheet we can use formulas like countifs and sumifs on the basis of another worksheet.

But is it possible to apply formulas like vlookup, countifs, sumifs etc in a workbook to get record auto updated from different workbook.