Is there a easier way to do this?

L

leasaac

I am currently using this excel form to fill in my auction informatio
in order to get it bulk listed. The fields given for the first ro
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 differen
pictures like above mentioned, I have to copy paste the first one int
the other four boxes and edit the numbers all manually. I would like t
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 i
asds1.jpg - asds5.jpg in one line and they can automatically goes t
the correct boxes.

Any suggestion is deeply appreciated
 
D

Dave Peterson

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?
 
Top