Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 11th 04, 03:19 AM
Jim
 
Posts: n/a
Default pull data from sheet two, then fill in the data to sheet one (part

Hello,

I would like to pull data from sheet two, then fill in the data to sheet
one.

Here is what the data from sheet 2 looks like:

A B C D
A1100 Dan 14 311.85714
A1102 Jason 12 296.83333
A1103 Brian 1 518
A1104 John 57 267.36842
A1105 Beverly 0 0
A1106 Jennifer 0 0
A1107 Chad 35 342.6
A1108 Brenda 1 243
A1109 Tina 2 193.5
A1110 Marcus 23 237.34783
A1111 Kelly 28 244.92857
A1112 Jim 19 425.94737
A1113 Michael 58 236.81034
A1115 Amy 9 282.77778
A1116 Teena 28 346.39286
A1117 Laura 65 204.04615
A1118 Randy 34 236.67647
A1119 Laura 4 278.5

Column A is the phone extension
Column B is the name of the Rep
Column C is the number of calls taken
Column D is the talk time in seconds

Although the data in the columns will never change, the rows in which the
data fills may vary.

I would like to populate sheet one A1 with Dan, B1 with 14, and C1 with the
311.85714.

Thanks for the help.


  #2   Report Post  
Old December 11th 04, 03:55 AM
R.VENKATARAMAN
 
Posts: n/a
Default

use vlookup function
anycell in sheet1 type

=VLOOKUP("dan",Sheet2!$B$1:$D$18,2,FALSE)
note the data base is from B1 to D18 and not from A1. the third argument is
2

similary on the right cell to this (or an;y cell) type

=VLOOKUP("dan",Sheet2!$B$1:$D$18,3,FALSE)
the third argument is 3

you will get the hang of it and modify to suit you.
=================

if change jason for dan you get
Jim wrote in message
...
Hello,

I would like to pull data from sheet two, then fill in the data to sheet
one.

Here is what the data from sheet 2 looks like:

A B C D
A1100 Dan 14 311.85714
A1102 Jason 12 296.83333
A1103 Brian 1 518
A1104 John 57 267.36842
A1105 Beverly 0 0
A1106 Jennifer 0 0
A1107 Chad 35 342.6
A1108 Brenda 1 243
A1109 Tina 2 193.5
A1110 Marcus 23 237.34783
A1111 Kelly 28 244.92857
A1112 Jim 19 425.94737
A1113 Michael 58 236.81034
A1115 Amy 9 282.77778
A1116 Teena 28 346.39286
A1117 Laura 65 204.04615
A1118 Randy 34 236.67647
A1119 Laura 4 278.5

Column A is the phone extension
Column B is the name of the Rep
Column C is the number of calls taken
Column D is the talk time in seconds

Although the data in the columns will never change, the rows in which the
data fills may vary.

I would like to populate sheet one A1 with Dan, B1 with 14, and C1 with

the
311.85714.

Thanks for the help.



  #3   Report Post  
Old December 11th 04, 04:43 AM
K.S.Warrier
 
Posts: n/a
Default

Hi,
In sheet 2 ,put in cell
A1=sheet1!B1
B1=sheet1!C1
C1=sheet1!D1
Then select A1:C1 in sheet 2 and copy this down for getting the desired
result.
Thank you,
K.S.Warrier

"Jim" wrote:

Hello,

I would like to pull data from sheet two, then fill in the data to sheet
one.

Here is what the data from sheet 2 looks like:

A B C D
A1100 Dan 14 311.85714
A1102 Jason 12 296.83333
A1103 Brian 1 518
A1104 John 57 267.36842
A1105 Beverly 0 0
A1106 Jennifer 0 0
A1107 Chad 35 342.6
A1108 Brenda 1 243
A1109 Tina 2 193.5
A1110 Marcus 23 237.34783
A1111 Kelly 28 244.92857
A1112 Jim 19 425.94737
A1113 Michael 58 236.81034
A1115 Amy 9 282.77778
A1116 Teena 28 346.39286
A1117 Laura 65 204.04615
A1118 Randy 34 236.67647
A1119 Laura 4 278.5

Column A is the phone extension
Column B is the name of the Rep
Column C is the number of calls taken
Column D is the talk time in seconds

Although the data in the columns will never change, the rows in which the
data fills may vary.

I would like to populate sheet one A1 with Dan, B1 with 14, and C1 with the
311.85714.

Thanks for the help.

  #4   Report Post  
Old December 11th 04, 04:51 AM
Max
 
Posts: n/a
Default

Assuming you have a *unique* list of all the names
in col A in Sheet1, in A2 down, viz.:

Name Total Calls Total Talk Time
-------- -------------- --------------------
Amy
Beverly
Brenda
Brian
Chad
Dan
Jason
Jennifer
Jim
John
Kelly
Laura
Marcus
Michael
Randy
Teena
Tina

To sum up and fill in cols B and C, viz.
"Total Calls" and "Total Talk Time" cols

Put in B2:
=IF(ISNA(MATCH(TRIM(A2),Sheet2!B:B,0)),"",SUMIF(Sh eet2!B:B,TRIM(A2),Sheet2!C
:C))

Put in C2:
=IF(ISNA(MATCH(TRIM(A2),Sheet2!B:B,0)),"",SUMIF(Sh eet2!B:B,TRIM(A2),Sheet2!D
))

Select B2:C2 and fill down

Any unmatched names in col A will return blanks: ""
in cols C and D

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"Jim" wrote in message
...
Hello,

I would like to pull data from sheet two, then fill in the data to sheet
one.

Here is what the data from sheet 2 looks like:

A B C D
A1100 Dan 14 311.85714
A1102 Jason 12 296.83333
A1103 Brian 1 518
A1104 John 57 267.36842
A1105 Beverly 0 0
A1106 Jennifer 0 0
A1107 Chad 35 342.6
A1108 Brenda 1 243
A1109 Tina 2 193.5
A1110 Marcus 23 237.34783
A1111 Kelly 28 244.92857
A1112 Jim 19 425.94737
A1113 Michael 58 236.81034
A1115 Amy 9 282.77778
A1116 Teena 28 346.39286
A1117 Laura 65 204.04615
A1118 Randy 34 236.67647
A1119 Laura 4 278.5

Column A is the phone extension
Column B is the name of the Rep
Column C is the number of calls taken
Column D is the talk time in seconds

Although the data in the columns will never change, the rows in which the
data fills may vary.

I would like to populate sheet one A1 with Dan, B1 with 14, and C1 with

the
311.85714.

Thanks for the help.





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
Transfer data from sheet to sheet Jenn Excel Discussion (Misc queries) 4 January 20th 05 03:07 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
Help!: lead sheet data needs to fill appropriate subject sheets carebear Excel Worksheet Functions 0 November 17th 04 07:43 PM
Help!: lead sheet data needs to fill appropriate subject sheets carebear Excel Worksheet Functions 1 November 12th 04 09:03 PM


All times are GMT +1. The time now is 02:58 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