VBA If Macro, Copying one row of text to different spreadsheet per row of Data

[Caldorn]

<o>The title of the thread pretty much explains what i'm looking to do.
But here is a little more details.
Basically what I'm starting with is an Excell spreadsheet First row contains the headers and then the following rows contain the data can be where from 1 to 80 rows of data per report.

What I need this Macro to do is copy the first row of Data and then paste it in another pre-saved report and then save that report as a different name based on data in that row and then check if row two has data do the same thing and so on until no data is found.
</o>

 

[kevatarvind]

hi Caldorn sorry but not getting what you need ?

 

[Caldorn]

What I need this Macro to do is copy the first row of Data and then paste it in another pre-saved excel document and then save that doc as a different name based on data in that row and then check if row two has data do the same thing and so on until no data is found.

Example of spreadsheet above.
Data has been hidden from this view but the report will go from Colum A to T

This Above is the macro that works but will only do one line I need it to run a total of 80 lines if Data in Colum B

Hoping these pics work, It may help in explaining what i'm looking to do.