try this idea

=INDIRECT("Sheet1!b"&ROW(A1)*48)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"lil_reeper" wrote in message
...
I am making this excel document and i have data on one sheet but want to
bring it over to sheet 2 to make it neater. when i try to enter in a
formula
that will pull like from every 48th line it doesnt want to work. i tried
=B2
then the next line =B50 and then tried pulling it down but it wanted to
add 3
to each one. I tried =B(2+48) but that just doesnt even work. I know the
basics of excel and can get myself around but this seems to be pretty
complex
stuff and im sure there is a way around this.