Hi,

you don't need macro just enter this formula in the cell A1 sheet1:

=VLOOKUP(B1,sheet2!$A$1:$B$100,2,false)
assuming you data in sheet 2 is in cells A1:B100 and also names are in the
first column.
you can copy drag down the formula to where ever you want. so you can write
the name in column B ( should be exactlt like the name in sheet 2) and see
the appropriate number in column A.

Thanks,
--
Farhad Hodjat


"eedmonds" wrote:

I am a little new at excel, and have looked for the answer to this a bit, but
I have not been able to find anything.

The spreadsheet has two "sheets" -- the second sheet is a list of names and
their corresponding client number. The first sheet is to record time spent
on each client. There was originally a macro setup so that when someone
wrote in the client name in Column B Sheet 1, the number (from sheet 2) for
that client would automatically come up in Column A Sheet 1. I did not
design the sheet (obviously!!) but I can't seem to make this work now.
Help!

Thanks!!!