I am trying to set up a report to help me out. My problem is that i have to
input 300-500 sheets of information in so i am using formulas to help me
capture that date that i need and i am sending it to another sheet. On the
Other sheet I have formulas set up to capture everything and the formula is
suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it
is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i
can "repeat" these going down so that i don't have to go in and manually
change the cell number. If any one could help it would be apprecitated.
Thank you.

=INDIRECT("Sheet1!H"&(ROW(A1)-1)*50+1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Chad Hable" <Chad wrote in message
...
I am trying to set up a report to help me out. My problem is that i have
to
input 300-500 sheets of information in so i am using formulas to help me
capture that date that i need and i am sending it to another sheet. On
the
Other sheet I have formulas set up to capture everything and the formula
is
suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below
it
is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i
can "repeat" these going down so that i don't have to go in and manually
change the cell number. If any one could help it would be apprecitated.
Thank you.

Chad,

Perhaps this in a cell and dragged down as required:-

=INDEX(Sheet1!H:H,(ROW(A1)-1)*50+1)

Mike

"Chad Hable" wrote:

I am trying to set up a report to help me out. My problem is that i have to
input 300-500 sheets of information in so i am using formulas to help me
capture that date that i need and i am sending it to another sheet. On the
Other sheet I have formulas set up to capture everything and the formula is
suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it
is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i
can "repeat" these going down so that i don't have to go in and manually
change the cell number. If any one could help it would be apprecitated.
Thank you.

=OFFSET($H1,(ROW()-1)*49,0)


"Chad Hable" wrote:

I am trying to set up a report to help me out. My problem is that i have to
input 300-500 sheets of information in so i am using formulas to help me
capture that date that i need and i am sending it to another sheet. On the
Other sheet I have formulas set up to capture everything and the formula is
suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it
is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i
can "repeat" these going down so that i don't have to go in and manually
change the cell number. If any one could help it would be apprecitated.
Thank you.