Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel how do i collaborate data from separate sheets
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - How to print areas in separate sheets to 1 pdf file | Excel Discussion (Misc queries) | |||
How do i distribute columns of data to separate sheets? | Excel Worksheet Functions | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Splitting Data into separate sheets | Excel Discussion (Misc queries) | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |