Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a fill down that increments based on the workbook name
I would like to know if it is possible to fill down a formula, which includes a workbook name. I have many job workbook files (all closed) in same folder as masterworkbook file. I only use sheet1 in each book. I'd like to link or copy certain cells - but the same cells in each job workbook - to the masterworkbook, with the data from each job workbook taking up a row in the masterbook. I have in cell A2 of the masterbook the following link: =[job1.xls]Sheet1!$B$2 I would like to have: =[job2.xls]Sheet1!$B$2 in cell A3, and =[job3.xls]Sheet1!$B$2 in cell A4 and so on. Over time, as new job files get created (job4.xls, job5.xls ....), I would see data appreaing in the next row in the masterbook; ideally nothing would be displayed when the next job file has not been created yet (no errors). I hope someone could assist with a simple solution. I greatly appreciate your help! Mike -- MikeExcel ------------------------------------------------------------------------ MikeExcel's Profile: http://www.excelforum.com/member.php...o&userid=36265 View this thread: http://www.excelforum.com/showthread...hreadid=560537 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
question about formula based on another workbook info | Excel Discussion (Misc queries) | |||
How do I create a commission chart based on dates worked? | Excel Worksheet Functions | |||
Create a list based on single shared criteria | Excel Worksheet Functions | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) |