View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz Liz is offline
external usenet poster
 
Posts: 133
Default 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!