New worksheet from row in table

[Steve_9]

Hi,

I have a spreadsheet with a fairly large table, around 80 columns with a few hundred rows.

I need to create a new worksheet for each row. the data is simply presented in a nicer looking format, basically transposed with some formatting applied. I have created a template sheet that points to the first row of data in the table, i just need to work out how to replicate it pointing to the second, then the third and so on.

once the sheets are created, i need to PDF them and then they can be deleted to keep the spreadsheet size down. effectively a mail merge, just not using ms word.

Looking for some help on how to do this. I am not very good with VBA, I have a basic understanding, but not good enough to know where to start.

any help will be greatly appreciated

.

[p24leclerc]

I think there is no VBA in Office 365. Right?