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.
How can we do it?![]()
=$O$3/60/60
Thanks,
Shiva
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.
How can we do it?![]()
=$O$3/60/60
Thanks,
Shiva
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks