View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danielle Danielle is offline
external usenet poster
 
Posts: 31
Default Reference a cell on another sheet and have the information auto up

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.