Can you not offer me any guidance as to how to write it? i mean i know what
to do but dont really know how to get around it..

thanks in advance.

"Jim Rech" wrote:

No I don't have such a macro. It would probably be highly specific to your
exact situation so you would have to write it yourself or get someone you
work with to do it.

--
Jim
"Zak" wrote in message
...
| OK, if the lookup function wont do what i want it to is there a macro that
| can do the job? do you have a code?
|
| any help would be much appreciated.
|
| "Jim Rech" wrote:
|
| is there not a way that I can just do the one lookup
|
| The Excel lookup worksheet functions all search one range on one sheet
so
| you'd need multiple lookups.
|
| --
| Jim
| "Zak" wrote in message
| ...
| | Hi,
| |
| | I am trying to lookup the value of one column in one worksheet in
another
| | workbook that has about 20 sheets. I know how to do a lookup
seperately in
| | each sheet but is there not a way that I can just do the one lookup
from
| the
| | one sheet which will search the whole workbook (looking into each of
the
| 20
| | sheets) and return what i am looking for. Essentially i just need to
know
| if
| | the people on this one column are presesnt in any of the 20 sheets in
| another
| | workbook.
| |
| | Thanks.
|
|
|