-
Excel Help!
I am putting together an excel spreadsheet that does what the stupid expensive programs cannot that we have at work.
I know how to do everything I need to but for one thing. I need a hyperlink to a file on the network that is named the same as a cell. I have searched everywhere, and other than going to school for Visual Basic the only thing I have came up with is this:
=HYPERLINK("\\P:\00_Insurance Jobs_OR_SW_WA\PO Lists\Kevin\PDF\100001.pdf", A2)
That works great, but I need each cell displaying the hyperlink to auto input the number in front of the .pdf which in this case is the A2 cell.
Or another idea to accomplish creating a link in a cell that searches a given network folder for a file name matching a cells contents.
Ideas???
-
shouldn't need "hyperlink"
-
Without the "Hyperlink" you lose the friendly name, and get the full path. No good. As I said this works, but I need a formula/script, or something to get it working in 15 thousand cells.
-
-
Here is an example of a balance of an account off of one spread sheet linked to another spreadsheet that lists all the accounts
='C:\Users\PappBear\Dropbox\Church Financials\2014\[CHECKING ACCOUNT(2014).xlsx]MARCH'!$E$8
so
='path that the spreadsheet is located\[name of spreadsheet]TAB NAME AT THE BOTTOM OF THE SPREADSHEET'!$COLUMN LETTER$ROW NUMBER
-
OK Above my knowledge, sorry
-
Yeah mine as well. I have 11 workbooks all linked to a master, and a bunch of other crap. I just need the ability to assign document copies to a link in cells without manually doing it.
-
I have 8 spreadsheets that I use for balancing the Church accounts, I just established each link individually as needed as I designed them.
-
This is a PO system: 15 users, 1000 allotted numbers each, and a master with linked sheets to each for the controller to access at anytime for data entry into other programs.
I have pads setup in the field so all they need to do is snap picture, and know job name. The pad converts to pdf (needed for another program), and emails to the superintendent where he/she adds PO #/info, saves the pdf on the network in a folder where I need excel to look, and marry each pdf to the row via hyperlink. Simple right?
-
