In excel how do i collaborate data from separate sheets

A

adriantx2001

I would like to track client information on one separate annual sheet
gathered from daily sheets through the year. ie- when I enter a clients name
into a cell, they sevice i performed & price they paid me in the same row,
how can i track how much that particular client has paid and the amount of
visits or the count their name appears in the "client cell column" for the
year. I enter this info on daily sheets and have the month totals on a
separate sheet but cant figure how to do this with text.
 

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