I need the following:
In an excel sheet, I have multiple cells (in a column); each cells contains 3-12 links that point to jpg files. Within the cell, links are separated by ";) symbol.
So the cell is like this:
[url removed, login to view];[url removed, login to view];[url removed, login to view];[url removed, login to view];[url removed, login to view]
I need a macro that wil:
(actions that follow are to executed within each cell, not all cells)
read each and every one link (within the cell)
present the relevant photos in one screen
Each photo will have tick underneath. If I click on the tick, the photo should be deleted from cell.
Each photo will have a radio button underneath. If the button is pressed, the photo becomes the first one to be inserted in the cell.
When the above is done, the software must prepare the new contents of the cell:
(suppose we delete picture2 and we make photo5 as the first on)
[url removed, login to view];[url removed, login to view];[url removed, login to view];[url removed, login to view];
The software will have to give us the option to run sequentially for all cells (if I select a range of cells, then the procedure will go to cell2, then cell 3, etc
Additionally, upon exiting, I would like the program to :
- download the pictures in a local folder
- give me the option to save the pictures in the local folder with a new name (instead of the old SKU number, with the new Greek SKU Number)
see attached for details
5 freelancers are bidding on average $48 for this job
Having more than 11 years of experience MS Excel & VBA. Completed several VBA projects in the past with excellent customer satisfaction. Hence I can complete the task with a high standard and quality.