LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.

 
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 01:35 PM.

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

About Us

"It's about Microsoft Excel"