Increment Hyperlink by +1 to Network Folder Location

[adamsc50]

I have just over 6500 serial numbers I need to add a network hyperlink to in our spread sheet. The serial number column starts at 0001, I added the network folder location "\\server\folder\0001" to that cell. When I drag copy downwards, the hyperlink copies but it stays as "\\server\folder\0001". I need the hyperlink to increment by 1 according to the network folder location for the info on that particular serial number, otherwise I have to manually change each link.

I do not know if this is even possible, but any and all help will be greatly appreciated.

Thank you

[tlafferty]

I'm not sure I'm following exactly what you mean. It sounds like you mean that you have a column with only serial numbers in it: ie 0001, and that you are adding what's in any given cell to a hyperlink. Is this what you mean? Or do youi mean that you are entering the entire text of the hyperlink, including the folder serial number: ie \\server\folder\0001?

Perhaps you would consider attaching your spreadsheet. When I enter the entire hyperlink and fill down, it auto-increments for me, so I'm missing something.

[adamsc50]

Here's an example of my entire spread sheet

[tlafferty]

Add this formula to D3 and fill down:
=HYPERLINK("\\server\folder\"&B3)

[adamsc50]

That formula works, but the serial number doesn't get the link. The column D doesn't exist, it's just an example of what column B should be linked to. I'd like to drag down B3, not D3 and have the hyperlink increment the folder value from 0001, 0002, etc. In theory serial number 3479 should be hyperlinked and goto network folder "\\server\folder\3479".