In Sheet2 B7 enter the below formula and copy to the right/down as required

=INDEX(Sheet1!6:6,(COLUMN(C6)-2)*3)

If this post helps click Yes
---------------
Jacob Skaria


"Scott A" wrote:

Hello,

I am taking information from one page and placing it into another. On page
one the information is on the same row but 2 cells apart (i.e. C6,F6,I6...),
on the second page I need this information to be right next to each other
(i.e. B7, C7, D7...). Right now I just use the = sign and then have to click
the original cell that I need but I need to do this about 100 times.

Is there a way to make a formula for this?