Create a specific number of consecutive rows based on row count input

[goodlite]

Hi!

I have the following input data in my excel sheet (three columns Prefix, ID, Row count) with some sample data (first three rows):

Prefix ID Row count
XYZ 9000 5
ZDF 7504 2
BBH 1004 3

What i am looking for is a mechanism which will generate the number of new IDs based on the row count input (including the prefix). So the output of the three example rows would look like this:

XYZ-9000
XYZ-9001
XYZ-9002
XYZ-9003
XYZ-9004
ZDF-7504
ZDF-7505
BBH-1004
BBH-1005
BBH-1006

Using a function I can get the prefix and IDs concatenated and ascending from the starting point, but I don't know how to include the row count input to stop after the correct amount of rows. How would I design a macro to take this into account?

Thanks & Regards,
Goodlite

[spitfireblue]

Hi Goodlite,

Try this:

Please Login or Register  to view this content.

[kev_]

Similar but different
With headers in row 1, and data staring in row 2

Please Login or Register  to view this content.

[goodlite]

Thanks a bunch you both! I was able to learn and use this successfully.

[kev_]

You are welcome
Thanks for the rep