LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 07, 01:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Feb 2007
Posts: 9
Default 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 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
it would look like this:
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!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bringing data in one sheet Nad Excel Discussion (Misc queries) 0 June 26th 06 01:19 PM
Bringing together data Emma Hope Excel Worksheet Functions 4 May 25th 06 02:58 PM
Bringing Last line of worksheet to a Summary page Debbie Excel Worksheet Functions 8 January 26th 06 11:36 PM
Bringing partial data from one cell into another Jack Taylor Excel Worksheet Functions 2 April 5th 05 06:43 PM
bringing data from one workbook to another using a date stamp func tifosi3 Excel Worksheet Functions 0 April 5th 05 12:13 AM

All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017