Hello, I'm trying to simplify the addition of thousands of hyperlinks in a spreadsheet. I have the pictures in a folder and just need to figure out how to get autofill to work with the addressing.
The formula below points to the beginning of a series of pictures. How can I drag down and have the file name increment numerically?
=HYPERLINK("20181109 Audit Items\IMG_1364.JPG","IMG_1364.JPG")
This is what I'd like to happen when I drag down.
<tbody>
</tbody>
The formula below points to the beginning of a series of pictures. How can I drag down and have the file name increment numerically?
=HYPERLINK("20181109 Audit Items\IMG_1364.JPG","IMG_1364.JPG")
This is what I'd like to happen when I drag down.
=HYPERLINK("20181109 Audit Items\IMG_1364.JPG","IMG_1364.JPG") | |
=HYPERLINK("20181109 Audit Items\IMG_1365.JPG","IMG_1365.JPG") | |
=HYPERLINK("20181109 Audit Items\IMG_1366.JPG","IMG_1366.JPG") | |
=HYPERLINK("20181109 Audit Items\IMG_1367.JPG","IMG_1367.JPG") | |
<tbody>
</tbody>