creating new worksheets from a template for each row of data

[So_much_to_learn]

Hi there, i have often come here to look up answers to vba questions and this is my first post for help.

i have a spreadsheet of data that needs to go into a template format.

so far the macro can successfully look down column A, create a new worksheet for each row,
- it does not rename the worksheet to the respective cell reference for each row

i can get a single row/sheet to copy cell data to the correct location
- though i cannot get it to repeat for the next row i

i have included the xlsx that i was working on for a trial.

there are many more rows (hundreds) and columns (~20) in the final version, though i am sure i will be able to expand once these problems are solved.

Please Login or Register  to view this content.

any help would be greatly appreciated

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[royUK]

Why not simply use VLOOKUP?

[So_much_to_learn]

Nice Work!

thanks JBeaucaire for your help, works a charm.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.