Well I guess my question still stands, though I did find a way to get around
it.

Is there a way to make what I asked happen (it would save me a bit of time
over what I am doing now)?

"seed" wrote:

New job-rewriting the spreadsheet we use for scheduling. What I have is one
sheet detailing test scheduling with one day every three rows and one sheet
detailing man-hours with one day per row. Is there a way I can pull the
daily hours from each row of the one sheet to every third row of the other?

i.e.

A3=A1
A6=A2
A9=A3... etc.