Easy Excel Macro Or Application

IN PROGRESS
Bids
10
Avg Bid (USD)
$10 / hr
Project Budget (USD)
$8 - $15 / hr

Project Description:
I have an excel file with 2 Columns. Column A and Column B. Column A has images names that i already have in folder on my local pc. Column B has new names of images. I want images to be renamed with new names mentioned in column B. However there is one more thing i want to mention if you open file and in first row you see in Column A "WOF19271564326.jpg" . In folder i have image with same name already exist but there are 2-3 more images also available for same name like this "WOF19271564326_01.jpg "WOF19271564326_02.jpg" "WOF19271564326_03.jpg" Sometime these exist and sometime not so i want to rename those also but keep "_01.jpg" "_02.jpg" etc... and rename rest of the name.

Also in column B u will see some of the rows has duplicate names also so if this case appears i want macro to add -1,-2 etc.. at the end of images so they will become unique instead of overwrite previous image. In column B sometimes names are too big more then 260 characters i think so just cut the names which are more then 260 characters because i think max limit for name is 260 characters.

So this is what i need.
1. Read names of images from Column A search for the image in Folder.
2. Rename image with new name mentioned in Column B including sub images _01,_02,_03.... but keep _01,_02,_03 etc...
3. Add -1 , -2, -3 etc.. if duplicates found.
4. Limit the characters to 260 if found more then 260 characters.

I need this quick so i will select a bidder in 1 to 2 hours. My budget for this is $10.

Hours of work: 2 Hr / week Project Duration: < 1 week Skills required:
Excel, Javascript, PHP, Visual Basic, Windows Desktop
Additional Files: images-new-names-89-265.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$10 / hr
Hours: 1 hr/ week
Hire excel4engineers
$8 / hr
Hours: 1 hr/ week
$10 / hr
Hours: 2 hr/ week
$15 / hr
Hours: 2 hr/ week
Hire Maria6868
$8 / hr
Hours: 2 hr/ week
$10 / hr
Hours: 2 hr/ week
Hire vanpham
$8 / hr
Hours: 2 hr/ week
$8 / hr
Hours: 4 hr/ week
$8 / hr
Hours: 20 hr/ week
$10 / hr
Hours: 2 hr/ week