Draging a vertical formula horizontell

Hello,

I have a formula in N4 which have been dragged down to N108 in sheet 2.

In sheet 1, I want to be able to drag this formula N4-N108 but horizontell instead in the cells b2-AC2

I have tried using the Indirect function like this: INDIRECT("B" & COLUMN('Sheet 2'!N1))

But it doesnt seem to be working, solutions please?

Can you explain it this way..

"If I had my way, I would put this formula xxxxxxx in Cell xx. I would then drag it right to cell xx and it would appear as xxxxxx"

I have managed to do it within the sheet using
INDIRECT("B" & COLUMN(B1))

But i want it to get the data from sheet 2

Originally Posted by ramananhrm

Im not sure if i have answered you correctly.

You can use the logic i tried.

Thank you very much, this worked :D Repping!