bringing data in from one worksheet to another

S

stacy05

hi..I was hoping that someone could help me with this..

I want to be able to bring in data from previous woksheets and then total
them on another...my workbook looks like this:

October Travel COST
last name Training Mission
Smith $2000
Jones $4000

November Travel COST
last name Training Mission
Smith $6000
Jones $5000

December Travel COST
last name Training Mission
Smith $1000
Jones $3000

**I want to sum up "training" and "mission" for each person(sorted by last
name)
it would look like this:
END OF THE YEAR TOTALS TRAVEL COSTS
last name Training Mission
Smith $3000 $6000
Jones $5000 $7000

How do I pull in the right type of data from the other sheets only from the
person I want?

Any help is greatly appreciated!
THANKS!
 

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

bringing data in from another worksheet 1
How to select one record of each from a column 1
How do I copy cells from one worksheet to another based on values 2
Auto populate value from one task to another in MS PROJECT 0
Moving data from multiple rows to single rows 5
How to find and move a value based on multiple criteria 2
Reference function from an out of sort table 5
Particulars data Filter from sheet 1 to sheet 2 automatically 4

Top