Hi, I don't know if anyone here on this forum can help out with this as I'm not sure if it is even excel related, if not I wonder if anyone can suggest a program or even a starting point for me to develop a solution.
Quite a long text I'm afaid so thanks to all who go to the trouble of reading this.
I frequently have a large number of pictures (sometimes in the thousands) which I have to match with an excel list. For example I might have say 2000 photo's of cars and an excel list of makes and models. What I have to do is look at the pictures and insert the picture filename in a cell on the same row as it's correct make and model. sometimes there is only one picture sometimes there may be many if there are multiples then the filenames would all be in the same cell separated by a comma.
Although I have come up with different ways of doing this over the years it is still very time consuming. The solution I dream of is having a the picture in one window and the list in another, being able to advance to the next or previous picture easily (as in say windows picture viewer) and then just clicking with my mouse on the excel cell and the program inserting the filename in it. That way I could scroll throught the pictures at quite high speed and assign each one to the relevent cell with just a click.
I realise this is probably not possible but any thoughts along these lines would be really appreciated and may at least enable to look for the right kind of program.
If you made it this far down without nodding off -- thanks