Hi
I am currently in a dilema. I need a multi function excel sheet and have no idea where to start.
I'm looking for a few functions:
First for a row to contain a link to a folder of a location on my computer which will be linked with that item.
The second is that i would like a cell to automatically create a folder with the text that is typed in.
For example i have some meta data, at the end of this meta data is the location. By typing in a name, say "best of album" It will locate the file and move it to the Best of album folder that has been created or already is present.
I hope that makes sense. I would be very greateful of any help
I am currently in a dilema. I need a multi function excel sheet and have no idea where to start.
I'm looking for a few functions:
First for a row to contain a link to a folder of a location on my computer which will be linked with that item.
The second is that i would like a cell to automatically create a folder with the text that is typed in.
For example i have some meta data, at the end of this meta data is the location. By typing in a name, say "best of album" It will locate the file and move it to the Best of album folder that has been created or already is present.
I hope that makes sense. I would be very greateful of any help