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!!!