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)