| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference workbook name to cell reference
Hi,
I have this line of code in workbook "Team 3.xls": Sheets("Output").Copy After:=Workbooks("11_07 Summary Team 3.xls").Sheets(1) Rather than manually replacing the name of the workbook each month (eg to 12_07 Summary Team 3.xls etc), is it possible to reference the workbook name ("11_07 Summary Team 3.xls") to a cell reference, say Sheets("Data").Range("J11") which resides in Team 3.xls. Any assistance appreciated. Cheers Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Providing a reference to another cell in a different workbook | Excel Worksheet Functions | |||
| workbook/cell reference w/ formula | Excel Worksheet Functions | |||
| Use the value of a cell within a reference to another workbook? | Excel Worksheet Functions | |||
| cell reference in another workbook | Excel Discussion (Misc queries) | |||
| cell reference in another workbook | Excel Programming | |||
Threaded Mode
