I'm trying to set up Excel to link several rows with several columns. I
guess I could do it manually with the "=" function for everyone, but that'd
take a long time and a chance of a mistake is fairly high. What I have is 2
sheets, On sheet two, I have a chemical that is broken down into 8 pieces of
data going from H3 to H10, I then have a space and then repeat for a another
chemical with 8 pieces of data from H12 to H19 and I repeat for several
hundred.

On sheet one, I need to have those 8 pieces show up in a row, so H3 from
sheet two shows up in N9, H4 shows up in O9, H5 in P9 and so on for all
eight. If I try to propagate it down, instead of N10 linking to H12 from
sheet two, it links to H4.

Is there a way to get it to link column to row and propagate it down without
having to goto each individual piece and using the "=" function??

Thanks,