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
 
You must log in or register to reply here.

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

Similar Threads

correlating and summing data from multiple spreadsheets 1
trying to create a link to a link in Excel (2007) 3
Excel lookup across entire workbook 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I find like data in multiple worksheets? 1
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Appending Rows to a Worksheet from a Template 6
Excel Vba to change displayed year automatically. 14

Back
Top