Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions |