Hello everyone!

I am going to try and explain this as best as possible....

I would like to import data to my website in high volume and I need to create an excel sheet that does a few advanced things that are out of my league.


My process starts with me taking pictures of items and then renaming them starting with the number 1000..



1ST PART OF MY SHEET!!!

The first thing i would like to do in my excel sheet I would like to figure out how to custom fill just the last numbers in a string of a field.

Example:

http://www.mysite.com/folderwithimage/1200.jpg <--- this is line one
http://www.mysite.com/folderwithimage/1202.jpg <--- this is line two


So say I had 700 items the last line would read:

http://www.mysite.com/folderwithimage/1550.jpg <--- last line


How can I do a fill down method that just modified the last number in the string??

2ND PART OF MY SHEET!!


Ok the next part is similar to the first part but it has alot more characters within it before the change takes place...

In the same row as the image location.. Which is the information in part one is the description of the item.. here is the html template for what will be the exact same in every item except the few numbers that go with the image of the product..

HTML Code: 
Now inside this series of code the only thing that needs to change is the numbers inside the code.. so in the first product the 1200 will need to be changed twice.. once for the thumbnail and once for the large viewing file.

also the numbers 1201 will need to be changed as well for that is the 2nd photo that does with the product..


So basically I just need those numbers to change with each row and each product..

I would like to be done either with a automated process once the sheet recognizes the number change in the 1st part of sheet to change those areas of the field...

CONCLUSION:


I am trying to explain this to the best of my ability.. I would be more than happy to talk on the phone or an instant messenger and also pay someone to assist me with this... With this sheet I would be able to list up to 700 items a day on my site as opposed to 100 that i can do now..

Thank you for your time and I hope someone can help me!!!

Nick

numismattica.com