| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for automatically entering information from a master sheet
I'm really drawing a blank on this one!!
In my workbook I'm creating a worksheet for each employee. I would like to input all information on a master sheet and have it automatically enter to the correct employee worksheet. MASTER has the following information: A1=Employee #, B1=Employee name, A2=000, B2=Jane Doe. TEMPLATE for Employee worksheet: B3=Employee #, C3=formula that will pull from MASTER, B4=Employee name, C4=formula that will pull from MASTER |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically add records from a new sheet to master sheet | Excel Discussion (Misc queries) | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| Copying (Master) column to another sheet to automatically update | Excel Worksheet Functions | |||
| Changing the Master Sheet Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
