Repeating Rows Over and Over

[Muttly]

First off, this is not "How do I print headers on each page".

I have 4 rows of data in a table. I need that to repeat over and over on a page. I know I can just go to e1 and put in =a1 but that's not really what I want. It doesn't allow for changes. ie Its currently 4 rows but 2 weeks ago it was only 3. It could be 5 or even more.

I know I can just copy and paste but I'd rather an automatic option.

Any help would be appreciated. Thanks.

[Fotis1991]

Not sure that i get your goal.. Can you upload a small sample workbook? Perhaps using an if and copy down and across?

Please Login or Register  to view this content.

[Muttly]

This is the resulting look I want. But ideally only input the first table. Then repeat it through the sheet. Again, I know I can do it manually but I'd prefer it to be automated. Plus as the table can change it can be time consuming to update it.

c-display.xlsx

[Fotis1991]

Apologize for this but i missed your reply!

Run this macro to do what you need.

Please Login or Register  to view this content.