Create records

[Jaye7]

I have a list of values in column A/ Serial1, I have a list of values in Column E/ Name.

What I want to do is have the records populate like the 2 last columns NAMED OUTPUT SERIAL 1 AND OUTPUT NAME, so for each record in the name column it will have the serial next to it.
Sorry I didn't know how to explain it better, hopefully the example will help.

This is just an example, there are thousands of records to process.

It would be good if I could have an inputbox to ask which column holds the serial1 data and which column holds the name data, just in case the data is entered in a different column.
There are values in columns B to D but it is not required in the output.

I am using excel 2007 and 2010.

SERIAL 1 NAME OUTPUT SERIAL 1 OUTPUT NAME 124 80000 124 8000 635 82004 124 80000 925 820603 124 82004 734 7772526 124 820603 1200 36873 124 7772526 873873 124 36873 87387 124 873873 543 124 87387 8736 124 543 213131 124 8736 876 124 213131 888756 124 876 87 124 888756 124 87 635 8000 635 80000 635 82004 635 820603 635 7772526 635 36873 635 873873 635 87387 635 543 635 8736 635 213131 635 876 635 888756 635 87 <tbody> </tbody>

<tbody>
</tbody>

 

[Jaye7]

Thanks for your help, the script is great, much appreciated.

 

[hiker95]

Jaye7,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.