View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
seed seed is offline
external usenet poster
 
Posts: 27
Default Consecutive cells pulling data from non-consective cells

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.