Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 07, 07:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 9
Default bringing data in from another worksheet

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!

  #2   Report Post  
Old February 23rd 07, 07:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 751
Default bringing data in from another worksheet

Stacy,
in your summary sheet, put the month names (or sheet names) in cells,
say G1:G12.

Now, still in the summary sheet, names are in A2:Ax. For Training
(assuming in all month sheets training in column B:B and Mission in
column C:C). In B2:

=SUMPRODUCT(SUMIF(INDIRECT($G$1:$G$12&"!A:A"),A2,I NDIRECT($G$1:$G$12&"!
B:B")))

For the Mission use the same formula, only replace the last B:B with
C:C

HTH
Kostis Vezerides



On Feb 23, 9:04 pm, stacy05 wrote:
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!





Reply
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 from one worksheet to another stacy05 Excel Worksheet Functions 0 February 23rd 07 01:51 PM
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


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

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