| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COPY CELL WITH FILE REFERENCES IN EXCEL
I need to know how to make excel automatically change this when I copy down:
='C:\CP Files\[COT010.xls]Sheet1'!$E$40 to ='C:\CP Files\[COT011.xls]Sheet1'!$E$40 and so on . . . ='C:\CP Files\[COT012.xls]Sheet1'!$E$40 ='C:\CP Files\[COT013.xls]Sheet1'!$E$40 ='C:\CP Files\[COT014.xls]Sheet1'!$E$40 etc . . . Since it is a reference to another file, it will not automatically change the file reference when I fill down. Hopefully this makes sense. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating cells to produce a cell ref from another excel file | Excel Worksheet Functions | |||
| cannot load excel file - "too many different cell formats" error s | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
