If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pulling data from 1 sheet to another
I am working with several large excel sheets(stats, employees etc.). I am
trying to tie all 4 of these sheets into 1 sheet that will pull data from the main raw data sheets. So far I have been able to pull data from all the sheets and create the reports and charts I need using vlookup etc., but I am stumped on this one problem. I keep thinking it is very easy, but I think I am missing something obvious. Here is the scenario: 1 of the data sheets includes in column 1 the employees number and then various data collected on performance...this employees number and data can be in several rows denoting different data pulls... IE: c1 c2 c3 etc... r1 emp 1 data data data... r2 emp 2 data data data... r3 emp 3 data data data r4 emp 1 data data data r5 emp 3 data data data What I need to do is pull all of emp 1 rows of data and put it in a seperate sheet. The user will just input the emp # and the sheet will read through the raw data and create a list in another sheet with all emp# listed as pulled from the main sheet. I hope this long explanation gives the required info to find a solution to this query. Thanks in advance for any help in this matter. Dave V. |
#2
|
|||
|
|||
Have you tried VLOOKUP? That might help you. I am wondering if you came up
with a solution to your issue as I am having a similar one. I am trying to extract rows from a table based on a condition that a specific text string is found in that table under the appropriate column. So what would happen is if a certain cell equals this string, the entire row where it is located would be updated into another worksheet. Any help would be great. Thanks. "Dave1155" wrote: I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main raw data sheets. So far I have been able to pull data from all the sheets and create the reports and charts I need using vlookup etc., but I am stumped on this one problem. I keep thinking it is very easy, but I think I am missing something obvious. Here is the scenario: 1 of the data sheets includes in column 1 the employees number and then various data collected on performance...this employees number and data can be in several rows denoting different data pulls... IE: c1 c2 c3 etc... r1 emp 1 data data data... r2 emp 2 data data data... r3 emp 3 data data data r4 emp 1 data data data r5 emp 3 data data data What I need to do is pull all of emp 1 rows of data and put it in a seperate sheet. The user will just input the emp # and the sheet will read through the raw data and create a list in another sheet with all emp# listed as pulled from the main sheet. I hope this long explanation gives the required info to find a solution to this query. Thanks in advance for any help in this matter. Dave V. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Entering data in one sheet and have it appear in second Sheet? | Don | Worksheet Functions | 0 | June 3rd, 2004 06:12 AM |
Entering data in one sheet and have it appear in second Sheet? | Don | Worksheet Functions | 0 | June 3rd, 2004 06:10 AM |
Help - Linking sheets and data from Sheet 1 to blank worksheet | Bimmy | Worksheet Functions | 1 | March 11th, 2004 06:51 AM |
Relative transfer of data from the last sheet | Mahendra | Worksheet Functions | 2 | February 13th, 2004 04:10 PM |
Dropdown Box to Select Data from Another Sheet | Annabelle | Worksheet Functions | 2 | November 10th, 2003 03:39 PM |