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?
Please Login or Register to view this content.
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.
try
=sheet2!$O$3/60/60
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Change the formula to include the sheet reference, i.e. =Sheet2!$O$3/60/60
Thanks.. It works.
Can this be done as other ...Please Login or Register to view this content.
=AVERAGEIF(F3:F12,">0")
add the sheet
=AVERAGEIF(sheet2!F3:F12,">0")
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
Nice.. Reps added.
your welcome - thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks