Hi,

I have below formula in Sheet 2. When I copy this table in Sheet1, it copyies the formula but takes the reference of Sheet1 but I want it to take reference of Sheet2 only.

=$O$3/60/60
How can we do it?

Thanks,
Shiva