Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using information in one excel file in another
I am try to "automate" some systems at work to save time. We use an excel
spreadsheet to allocate Annual Leave. This is a file that contains a colum of names and columns for each weeks of the year, were entered into the cell are the number of hours staff have booked. We also have an duty rota in an excel file. This contains colums with each staff member and the a row for each day, with the shift expected to work. At present some poor person goes through the annual leave file and re-enters all the information onto the duty rota file. I wondered if any one know how to link these files. I have been sussessful to link two individual celss from each file using and IF formula. But often people come and go, names are changed frquently and I did not want to put in individual formula - since this would be time consuming to change them each time. Any Ideas An Excel intermediate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Retaining formats | Excel Discussion (Misc queries) | |||
excel file lost | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) |