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.
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
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..
<td bgcolor="#271e19"><div align="center"><font color="#ffffff"
size="2" face="arial,verdana,helvetica,sans serif">
<table align="center" bordercolor="#ededd9" cellpadding="4" cellspacing="0"
<td bgcolor="#ededd9"><div align="center"><table align="center"
border="0" cellpadding="10" width="100%"><tbody><tr>
<td align="right" bgcolor="#ededd9"><p align="center">
<a href="http://www.mysite/folder/1200.JPG" target="_blank">
<img src="http://www.mysite/folder/th_1200.JPG" border="0"/></a></p>
<a href="http://www.mysite/folder/1201.JPG" target="_blank">
<img src="http://www.mysite/folder/th_1201.JPG" border="0" /></a></p>
<p align="center">Click either image above for larger more detailed image(image in pop up
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.
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...
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!!!