Loop Without Macros

[purpleozzie]

Hi,

I wanted to solve the following without using a macro if possible..

I have a spreadsheet with two sheets.. The second sheet has a list of products in column A and column B, C, D etc are various costings.. One month there may be 20 products, next 25 the following 15, it varies.. In column A on the first sheet I want all the products in column A on second sheet to be listed from say row 1 to 20, and then I want them listed again from row 21 to 40 and then again for a final third time.. In short I want a formula that can go through a list until a blank cell is reached and then go through that same list a second and then a third time..

Hope this makes sense..

[avk]

Instead of description, attach sample file with desire required result. Enter manually required result in respective cell.

[Kaper]

Hi,

I'd say not "instead" but "also" :-)

But as we have only description, I'd add - and probably in both sheets there is a header row (row 1)
So formula in A2 (and copy down and right):

Please Login or Register  to view this content.

will do the work of displaying 3 copies of data from rows 2:x in sheet2 into sheet1 rows 2:x , x+1:2x-1, 2x:3x-2

[purpleozzie]

Thanks Kaper.. Worked a treat.. You're a star..