Is there a easier way to do this?

I am currently using this excel form to fill in my auction information
in order to get it bulk listed. The fields given for the first row
image url is as such:

imageurl1, imageurl2, imageurl3, imageurl4, imageurl5.

Currently I am manually keying in the complete url to the boxes.

i.e

imageurl1- http://wwww.ds.com/asds1.jpg,
imageurl2- http://wwww.ds.com/asds2.jpg,
imageurl3- http://wwww.ds.com/asds3.jpg,
imageurl4- http://wwww.ds.com/asds4.jpg,
imageurl5- http://wwww.ds.com/asds5.jpg into individual boxes.

This is very tiring because if my auction contains five different
pictures like above mentioned, I have to copy paste the first one into
the other four boxes and edit the numbers all manually. I would like to
bulk list 200 auction every day so if each auction contains 5 pictures,
I will have to change 1000 times.

Is there a easier way to do this like for example, I can key in
asds1.jpg - asds5.jpg in one line and they can automatically goes to
the correct boxes.

Any suggestion is deeply appreciated.


---
Message posted from http://www.ExcelForum.com/

You could use the =hyperlink() worksheet function:

=hyperlink("http://www.ds.com/asds" & row()-1 & ".jpg")

if this formula is in row 2, row()-1 will return 1.

If your jpg's looked like: asds001.jpg, you could use:
=hyperlink("http://www.ds.com/asds" & text(row()-1, "000") & ".jpg")

Did you really mean wwww?


"leasaac " wrote:

I am currently using this excel form to fill in my auction information
in order to get it bulk listed. The fields given for the first row
image url is as such:

imageurl1, imageurl2, imageurl3, imageurl4, imageurl5.

Currently I am manually keying in the complete url to the boxes.

i.e

imageurl1- http://wwww.ds.com/asds1.jpg,
imageurl2- http://wwww.ds.com/asds2.jpg,
imageurl3- http://wwww.ds.com/asds3.jpg,
imageurl4- http://wwww.ds.com/asds4.jpg,
imageurl5- http://wwww.ds.com/asds5.jpg into individual boxes.

This is very tiring because if my auction contains five different
pictures like above mentioned, I have to copy paste the first one into
the other four boxes and edit the numbers all manually. I would like to
bulk list 200 auction every day so if each auction contains 5 pictures,
I will have to change 1000 times.

Is there a easier way to do this like for example, I can key in
asds1.jpg - asds5.jpg in one line and they can automatically goes to
the correct boxes.

Any suggestion is deeply appreciated.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson