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!!! |
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!!! |
All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com