Creating on loop

Hi Everyone,

Attached is a sample workbook, i have tables that are filled in 1 tab and using a vlookup get the data on a main tab.

I am wanting to create the templates for the vlookup for however many rows of data i have (so they are self creating)

However not sure how to make it create the front page templates for however many rows of data i have.

Because i want them down and not accross im not sure how to do this (have only worked with loops that have same data go down for x amount of rows with x amount of columns)

Any help would be great!

sample.xlsx

Hi..

To be honest.. your post is really hard to understand what the exact requirements are (even with an attachment)..

I am wanting to create the templates for the vlookup for however many rows of data i have (so they are self creating)

Are you saying you want to insert a vlookup formula into each cell down to the last row of data?

Not having a go at you.. but your 1st and 3rd sentences in your post leave someone reading it playing a guessing game..

The only concrete thing i can offer at this point is:

To find the Last Row that has Data in it in a particular column (Column A for example)..

Please Login or Register  to view this content.

To find the Last column with data in it in a particular row (Row 2 for example).

Please Login or Register  to view this content.