Hello , I created a snap sheet in excel which contains multiple listed vendors. I linked in snap sheet, so that whenever i select any vendor, i can directly go to that particular vendor excel sheet. Now i want to know that how do i set formula so that current outstanding balance of every vendor automatically should show in snap sheet , whenever i update the purchase and payment entry in particular vendor excel sheet.