Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data from one worksheet to another worksheet
Ok, I am trying to have data automatically update from one file/worksheeet to
another file/worksheet but a certain sheet. First file lets call it Year and a second file lets call it Department. The Year file is set up with columns from A to K with headings like name, department, etc. The Department file is set up with sheets that have a different department name on each one. What I need to do is when typing the information into the Year file that depending on which department it is for that it will automatically put the information into the correct sheet in the Department file. I hope someone can help me. Both files are in excel. Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
Linking rows of data to another worksheet | Excel Discussion (Misc queries) | |||
Linking to Pivot data in another worksheet | Excel Discussion (Misc queries) | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking multiple data into one worksheet. | Excel Worksheet Functions |