Linking of Excel sheet balance to main snap sheet

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.

I think we need to clarify terms.

Usually when we talk about sheets we are refering to worksheets WITHIN the current workbook.

I assume you are using hyperlinks to go directly to the vendor sheet.

To get the balance, it is a good idea to have the balance in a consistent cell.

You can simply have a formula =Sheet2!A1 where Sheet2 is the sheet name, and A1 is the balance.

OR you could use =INDIRECT("'" & A1 & "'!C1") where A1 contains the vendor sheet name, and C1 is the balance on that sheet. This one you could copy down your "Snap" sheet.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Reply, then Click on Go Advanced and scroll down to Manage Attachments.

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".