Hi Everyone!
I have long excel formula which takes different values from different cells. I want that when I copy a formula to paste it somewhere else then at that time then some cells' actual values should be present in the formula instead of cell ID. Like I have shown in the attachment, actual formula is =Sin(A1)+Cos(C1) but at the time of copying the same formula I want the copied fomula should be like Sin(150)+Cos(C1) where actual value of A1 is present.
I hope you understand my problem easily.
I will really appreciate your help in this regard.
Regards
Snapshot Excel Formula to Value - Copy.PNG
Bookmarks