A friend of mine at uni has seen the database that I've made for all my uni data and wants something similar, but instead he'd like it to be a lot less complicated and he just wants a spreadsheet. He's asked me to help since he hasn't got a clue how to go about it and I would/should/might.
Anyway, looked at it and as ever it's actually far easier to "code" such a thing in PHP, but since we won't be using that it's hardly relevant.
What I want to do, I think, is fairly simple. Into the spreadsheet he will enter a code in one cell, eg:
2009-04-28-XX-45
He will then enter a number in the next cell, eg:
10
I want there to then be a link made in the following cell along the lines of:
file://c:/NMR/
2009-04-28-XX-45/
10/fid
I've thought about putting:
file://c:/NMR/
in one cell, and putting:
/fid
in another and then somehow combining them but I have no idea how to do so in Excel.
Will I need to use some sort of VBA? Please help!