Populate Data from one spreadsheet to another.

[Jake87]

I need help populating a spreadsheet. I have a large spreadsheet with all the data, and I need to look up this data from within another tab. See below.

This is the data:

Site--------Vendor---- -Month----Use---Cost
SiteA--------Bob---------Jan------1------2
SiteA--------Bob---------Feb-----3-------6
SiteA--------Karen-------Jan------2-------4
SiteA--------Karen-------Feb------4------8
SiteB--------Cody-------Jan-------5-----10
SiteB--------Cody-------Feb------6------12

In a separate tab is this:

Site----Jan/Use---Feb/Use----Jan/Cost----Feb/Cost
SiteA
SiteB

I need something that grabs the data from the first sheet, and then enters it into the second. However, the part I can't figure out, is how to do this to get a TOTAL for both Bob and Karen's January numbers and, separately, February numbers.

After sheet is completed it should look like this:

Site----Jan/Use----Feb/Use----Jan/Cost----Feb/Cost
SiteA-----3----------7-----------6-----------14
SiteB-----5----------6----------10-----------12


Any help would be appreciated.

Thanks in advance!

 

[lenze]

Hi and wecolme to the board!!!
The operative word is "Pivot Table"
Site in Row Field
Vendor in Row Field
Dat ien Column Field
Cost in Data Field
This

  A      B      C    D    E    
1 Site   Vendor Date Use  Cost 
2 Site A Bob    Jan  1    2    
3 Site A Bob    Feb  3    6    
4 Site A Karen  Jan  2    4    
5 Site A Karen  Feb  4    8    
6 Site B Cody   Jan  5    10   
7 Site B Cody   Feb  6    12   
Sheet1
[Table-It] version 09 by Erik Van Geit

Becomes

   F            G      H    I   J           
12 Sum of Cost         Date                 
13 Site         Vendor Jan  Feb Grand Total 
14 Site A       Bob    2    6   8           
15              Karen  4    8   12          
16 Site A Total        6    14  20          
17 Site B       Cody   10   12  22          
18 Site B Total        10   12  22          
19 Grand Total         16   26  42          
Sheet1
[Table-It] version 09 by Erik Van Geit

NO FORMULAS

lenze

 

[Jake87]

Thanks for the welcome and the quick response! I've used a few pivot tables before, (read under 10) but the problem with a pivot table, at least I think it's a problem is, that the sheet that i need the raw data entered into is a prebuilt sheet with various other formulas and columns that take advantage of the use and cost numbers.(I dumbed it down for my example)

Is there some way to get around this or a different way to do this?

Thanks again for the help and the quick response.

-Jake