Pulling/Collating Data

[chrisk]

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

 

[Otto Moehrbach]

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]

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)

 

[Otto Moehrbach]

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]

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