| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-fill text - links to other sheets
Hi
I need to link cells from many excel sheets into one master file. Is there a way to auto fill the cells so that A1 ='\\Ausyd1fp002\projects\60097281_Pmatta_River\4. Tech work area\4.8. Field work\Asset Logs\Hunters Hill\Facilities\HUN_F01\[HUN_F01.xlsx]GIS Details'!A3 And then A2 ='\\Ausyd1fp002\projects\60097281_Pmatta_River\4. Tech work area\4.8. Field work\Asset Logs\Hunters Hill\Facilities\HUN_F02\[HUN_F02.xlsx]GIS Details'!A3 and then A3 ='\\Ausyd1fp002\projects\60097281_Pmatta_River\4. Tech work area\4.8. Field work\Asset Logs\Hunters Hill\Facilities\HUN_F03\[HUN_F03.xlsx]GIS Details'!A3 and so on. i.e is there a way to automatically increase the numbers mid formula? Would be very appreciative of any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| source sheet to auto fill 2 other sheets | New Users to Excel | |||
| source sheet to auto fill 2 other sheets | New Users to Excel | |||
| Auto Fill Different Sheets same cell on each sheet? | Excel Discussion (Misc queries) | |||
| Auto Fill Links with a Pattern | Excel Discussion (Misc queries) | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
