Linking Worksheets

  • Thread starter Thread starter Figgy
  • Start date Start date
F

Figgy

I have a workbook which contains 12 worksheets one for each month of the
year. Within these worksheets are entries for office expenses
(supplies, registrations, food service, etc.). I would like for all
entries for a particular vendor to appear in a worksheet (within the
same workbook) for only this vendor. What formula can I use so that
each time an entry is made for this vendor on the monthly worksheets it
also automatically appears in the vendor's worksheet?
 
I’m really quite sure what exactly what you want to do, however for what
I gather ‘SUMIF” could solve your problem by placing in each month a
SUMIF per “vendor” then have it total up where you need it to be, hope
it helps.

Fable
 
Back
Top