Monty
Well-Known Member
Hello everybody.
Very bad took almost 5 hours spent still not achieved...Sorry no attachment as working on mobile.
We have two sheets in sheet2 we have 100 as positive number and it is referred in sheet1 with that cell.... Obviously it shows 100 as a result as u linked from sheet2 to sheet1..
Now question is... I wanted to retain the reference of sheet2 to sheet1 but wanted to show in negative.
Simple wanted result with VBA
Pre
= Sheet2 F8
Post
=-sheet2 F8
Hopefully not confused...I tried all the ways to do it...Having a beer to relax now.
Thanks.
Very bad took almost 5 hours spent still not achieved...Sorry no attachment as working on mobile.
We have two sheets in sheet2 we have 100 as positive number and it is referred in sheet1 with that cell.... Obviously it shows 100 as a result as u linked from sheet2 to sheet1..
Now question is... I wanted to retain the reference of sheet2 to sheet1 but wanted to show in negative.
Simple wanted result with VBA
Pre
= Sheet2 F8
Post
=-sheet2 F8
Hopefully not confused...I tried all the ways to do it...Having a beer to relax now.
Thanks.