I would like to link data from files stored on my local drive.
As there many files I would like to link to all with same filename convention, I would like to drag the first cell and go from (row 1 to row 150)
Any ideas on how I can do this? Also, I have some files 113 to 150 that do not exist as yet, how do I stop '#NAME?' from appearing, looks untidy?
Many thanks for any help!!