| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a cell on another sheet and have the information auto up
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-fill a sheet reference | Excel Worksheet Functions | |||
| Auto fill of cell with information from seperate sheet | Excel Worksheet Functions | |||
| how to auto fill information from a table to another sheet | Excel Worksheet Functions | |||
| Auto link rows of information from multiple sheets to single sheet | Excel Discussion (Misc queries) | |||
| Reference information from one sheet to a second sheet | New Users to Excel | |||
Threaded Mode
