Copying cells from 1 worksheet to another

[Jeffries' Ex]

I have a job flow sheet, I want to pull the job address', and contact
information off of this worksheet and transfer it to another document so that
I can make cover sheet labels for job files. What is the easiest way to do
this? Thanks you.

 

[Nick Hodge]

You should look up VLOOKUP in help. Without structure of your file, it is
difficult to help too much further, but it is definite you need the VLOOKUP
function

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)