Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
='[master workbook.xls]3108'!K25 trying to use value of cell for 3
This may be confusing but we have a detail workbook for each job (3107,3108,
3109, ...) each detail workbook has cells tied to the master workbook (the 3108 is the sheet name in the master workbook). When I start a new job I use the workbook from the last job and resave it as the new job I have the job (3107,3108,3109,...) entered in cell a1 how can I use the value of cell a1 in place of the 3108 in my formula(s) so I only change it in cell a1 (one time) Any help would be appreciated it would be a big time saver for me |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet from one workbook to a master workbook | Excel Worksheet Functions | |||
Linking Master Workbook & subordinate workbook | Excel Discussion (Misc queries) | |||
Append workbook into a "Master" workbook | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Master Workbook used as my template? | New Users to Excel |