I have a workbook with about 12 worksheets for each of the various vendors I use.
Each sheet has a column for date-description of items-cost if item-and a column for balance owed.
My question is:
I'd like to create a sumary or compilation worksheet which I can designate one cell per vendor worksheet.
These cells will show the balance owed from each vendor.
Say I have 12 worksheets, then I'll have 12 cells on the Compilation worksheet.
One for each worksheet.
Thank you.
Bookmarks