Macro to Auto generate URLs

**grahammc** · 11-20-2010, 02:14 PM

Hi everyone!

I would like to find out the best way to auto generate a list of URLs based on a field within another column on the spreadsheet.

The spreadsheet only has two columns: one with the name of different manufacturers and the second for the URL.

I'd like to auto generate urls as follows:

Manufacturers URL
Sony UK http://www.exampleurl.com/example&manufact=sonyuk?01
Sony US http://www.exampleurl.com/example&manufact=sonyus?02
Panasonic http://www.exampleurl.com/example&manufact=panasonic?03

etc etc.

Any help or pointers would be really appreciated!

Thanks guys!

**martindwilson** · 11-20-2010, 04:41 PM

you could just join them with & at the right places.but what makes 01/02or 03 at the end?
="http://www.exampleurl.com/example&manufact="&a1&"?01"

**grahammc** · 11-20-2010, 05:51 PM

Originally Posted by martindwilson

you could just join them with & at the right places.but what makes 01/02or 03 at the end?
="http://www.exampleurl.com/example&manufact="&a1&"?01"

Thanks, yes that will work.

The 01, 02, 03 at the end is just a sequential counter. It isn't taken from another field. How do I get this number to automatically increase as I fill the formula down?

Thanks again.