Hi, I have a workbook, Master sheet containing this info :cell A4 contractor
name, B4 site location, c4 job cost etc to G4. There are several contractors
for the one job, so it may be that a4-a12 contain a contractor name, and
cells c4-g4 are the only cells that have information entered relevant to all
in a4-a12. I then have a worksheet for each contractor. What I need to do
is enter a formula in the individual contractor worksheets that pulls across
the information for each job (up to say 500rows, all roughly the same as
example above). the formula I have entered is only bringing across line
a4-g4 for the contractor who's name appears at a4, and not bringing across
the info relating to him at say cell a25. Using excel '07. Can anybody help
me? Auto filter no good, as I need the individual contractor sheets for
other uses, and must have the info separated out.

Any help much appreciated.