LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-fill a sheet reference JOJO193 Excel Worksheet Functions 5 March 5th 13 04:56 PM
Auto fill of cell with information from seperate sheet Ray Excel Worksheet Functions 1 June 14th 07 01:19 AM
how to auto fill information from a table to another sheet cmaki1975 Excel Worksheet Functions 1 January 15th 07 05:34 PM
Auto link rows of information from multiple sheets to single sheet Steve R Excel Discussion (Misc queries) 3 November 8th 06 06:13 AM
Reference information from one sheet to a second sheet Kathleen New Users to Excel 2 March 23rd 06 08:49 PM


All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"