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/Collating Data
Hi,
I have a workbook with 31 sheets (diary) A9:F9 (and other rows) is the info I want with the employee's initials in G9 There are multiple entries for the employee so he may reappear in row 13 and 15 I want to pull all the lines that relate to that employee from the 31 sheets into a separate workbook Thanks |
#2
|
|||
|
|||
Pulling/Collating Data
What is the name of the "separate workbook"? And in what sheet of this
"separate workbook" do you want this data placed? Do you want only that data that pertains to that one employee whose initials are in G9? G9 of what sheet? Otto "chrisk" wrote in message ... Hi, I have a workbook with 31 sheets (diary) A9:F9 (and other rows) is the info I want with the employee's initials in G9 There are multiple entries for the employee so he may reappear in row 13 and 15 I want to pull all the lines that relate to that employee from the 31 sheets into a separate workbook Thanks |
#3
|
|||
|
|||
Pulling/Collating Data
Hi Otto, thanks for the reply
What is the name of the "separate workbook"? BOB (employees name) and BOB is the reference in the diary in cell G9 (also in other cells if Bob does more than one job per day) but in the G column. And in what sheet of this "separate workbook" do you want this data placed? There is only one sheet in the separate work book since it only relates to BOB Do you want only that data that pertains to that one employee whose initials are in G9? Yes (G9 or generally somewhere in the G column) G9 of what sheet? G9 of the diary e.g APR is the diary with 30 sheets There is a workbook for each month with 30/31 days (Feb with 28/29) |
#4
|
|||
|
|||
Pulling/Collating Data
You missed what I was asking in my question "G9 of what sheet?" You have a
workbook named APR with 30 sheets. You want to do something with the name that appears in G9. You have 30 sheets. Each sheet has a G9 cell. That's 30 G9 cells. Which of these 30 G9 cells do you want Excel to work with? Another question: I asked you " Do you want only that data that pertains to that one employee whose initials are in G9?" You answered " Yes (G9 or generally somewhere in the G column)". Excel needs to know exactly what name to work with. I understand that the names may repeat on any given sheet, but exactly where is the ONE name that you want Excel to work with? Otto "chrisk" wrote in message ... Hi Otto, thanks for the reply What is the name of the "separate workbook"? BOB (employees name) and BOB is the reference in the diary in cell G9 (also in other cells if Bob does more than one job per day) but in the G column. And in what sheet of this "separate workbook" do you want this data placed? There is only one sheet in the separate work book since it only relates to BOB Do you want only that data that pertains to that one employee whose initials are in G9? Yes (G9 or generally somewhere in the G column) G9 of what sheet? G9 of the diary e.g APR is the diary with 30 sheets There is a workbook for each month with 30/31 days (Feb with 28/29) |
#5
|
|||
|
|||
Pulling/Collating Data
"Otto Moehrbach" wrote: You missed what I was asking in my question "G9 of what sheet?" You have a workbook named APR with 30 sheets. You want to do something with the name that appears in G9. You have 30 sheets. Each sheet has a G9 cell. That's 30 G9 cells. Which of these 30 G9 cells do you want Excel to work with? Its not really G9 its wherever Bob appears in the G column in any and all of the 30 sheets G9 is where the column starts. Another question: I asked you " Do you want only that data that pertains to that one employee whose initials are in G9?" You answered " Yes (G9 or generally somewhere in the G column)". Excel needs to know exactly what name to work with. I understand that the names may repeat on any given sheet, but exactly where is the ONE name that you want Excel to work with? Not always sure but Bob will be in the G column I want to search for Bob throughout the whole diary then pull the data from columns A to F that relate to Bob and put it in the separate workbook called BOB Obviously there are the other 18 employees that I want to do the same with who also populate the G column ChrisK "chrisk" wrote in message ... Hi Otto, thanks for the reply What is the name of the "separate workbook"? BOB (employees name) and BOB is the reference in the diary in cell G9 (also in other cells if Bob does more than one job per day) but in the G column. And in what sheet of this "separate workbook" do you want this data placed? There is only one sheet in the separate work book since it only relates to BOB Do you want only that data that pertains to that one employee whose initials are in G9? Yes (G9 or generally somewhere in the G column) G9 of what sheet? G9 of the diary e.g APR is the diary with 30 sheets There is a workbook for each month with 30/31 days (Feb with 28/29) . |
Thread Tools | |
Display Modes | |
|
|