Hello,

Currently I have a formula to convert the data of our purchase order from
down wise to sideway ( I do not know how to say it in English). Since the P.O
could be more than one page, although mostly are 1 page,so we need a kind of
formula that say if Cell say C50 (row 50) is blank taken the content of C50 +
51 lines below (C101) otherwise C50. C 50 is the Total P.O after discount.

My problem is how can we say it in formula cell C50 + 50, because if our p.o
is 2 pages the total p.o after discount is in page 2.

I apprecaite your help.

Frank