Thanks for the offer J Latham, much appreciated, however JOHN gave me push I
needed, and I'm up and soaring.

"JLatham" wrote:

If you're still not getting any thrust or lift from the JATO assists that
have been offered so far, then if you will entrust me with a copy of your
workbook, I may be able to help. If you want to try that route, send me an
email with the workbook attached and repeat the post/provide link to this
discussion in the email and I'll see what I can do to get you off the ground.
Send to (remove spaces)
Help From @JLatham site. com


"Jac" wrote:

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.