| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER
I have two excel files - one is a spreadsheet for booking annual leave, the
other is for a weekly duty rota. So that I do not have to go through each file and re-enter the information, can anyone suggest how I might be able to do this. I do not want to link individual cells, since names may change, not in the same order. HELP!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER
Try doing a VLOOKUP or HLOOKUP depending on how your data is located.
Ig. "Andrew Pickles" wrote: I have two excel files - one is a spreadsheet for booking annual leave, the other is for a weekly duty rota. So that I do not have to go through each file and re-enter the information, can anyone suggest how I might be able to do this. I do not want to link individual cells, since names may change, not in the same order. HELP!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
| Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
Linear Mode
