On second thought, maybe some VLOOKUP formulas on second sheet could work.

No "clicking on the sheet" however.

You would have to select a cell and enter a name


Gord


On Wed, 8 Oct 2008 14:29:00 -0700, Danielle
wrote:

I have a spreadsheet with employees in rows and courses taken in columns. I
have a seperate sheet with one cell for employee and the courses taken in
rows. I would like to click on the spreadsheet with all the info on it and
have it automatically fillin my second sheet with the employees name and the
courses that employee has taken.