Multiple occurances

[HPD]

Hello,

I don't know if someone has asked this before...

In my spreadsheet I have 2 tabs; one called '2007' and one called 'Progress'
(this links in with my question of yesterday 'rows to columns')

On tab '2007' I have data in A2 which I want to be replicated in cells A2:A7 in tab 'Progress'. Okay I can do this (='2007'!$A$2) BUT the data in tab 2007 stretches of 100 rows. It is not simply dragging it down to replicate the formula (even with the '$' removed) as it copies the incorrect data.

So what I want is to copy data from tab '2007' cells A2:A100 to tab 'Progress' but replicated 6 times. I hope this makes any sense.

Tab '2007'
ENQ/001/07
ENQ/002/07
ENQ/003/07

To copy and replicated into:
Tab 'Progress'
ENQ/001/07
ENQ/001/07
ENQ/001/07
ENQ/001/07
ENQ/001/07
ENQ/001/07
ENQ/002/07
ENQ/002/07
ENQ/002/07
ENQ/002/07
ENQ/002/07
ENQ/002/07
ENQ/003/07
ENQ/003/07
ENQ/003/07
ENQ/003/07
ENQ/003/07
ENQ/003/07

Thanks

HPD

[VBA Noob]

Maybe

=OFFSET('2007'!$A$1,INT((ROW(A1)-1)/6),0)

VBA Noob

[HPD]

Excellent!!!

Thanx, it did what I wanted it to do.

Cheers
HPD