ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   bringing data in from one worksheet to another (https://www.excelbanter.com/excel-worksheet-functions/132076-bringing-data-one-worksheet-another.html)

stacy05

bringing data in from one worksheet to another
 
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!


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com