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?