| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill function with file reference
I want to fill across a row using the pattern:
='Q:\DATA\[TestBook1.xlsx]Sheet2'!$A1 ='Q:\DATA\[TestBook1.xlsx]Sheet2'!$B1 ='Q:\DATA\[TestBook1.xlsx]Sheet2'!$C1 etc. I don't have access to this Q drive, but I need to update the workbook. The problem is that a popup appears every time I try to drag the autofill handle, and it won't let me continue dragging. What can I do to autofill across multiple cells? How can I get rid of the popup? I'm using Excel 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Down reference of even number rows | Excel Worksheet Functions | |||
| Auto fill cell reference | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| LARGE function file reference | Excel Discussion (Misc queries) | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
Hybrid Mode
