Linking Worksheets

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?
 
F

Fable

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top