Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

2014-12-22 Thread Vaibhav Joshi
Hi Big smile check this... Mandeep's code is working fine, made few change to it like..if same value is entered then it is not captured...Also restricted cell values to range specified by you..also it works with out dependent sheet! Cheers!! + *I did not do this for you. God is here

Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

2014-12-22 Thread big smile
Respected Vaibhavji I am changing the value of -- Sheet6-C22 - everytime - By formula =H33 Where it values changes as per I change h33 calculate premium But it does not work now. It only works if I change manually c22 If possible you give me the guidelines so

Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

2014-12-22 Thread Vaibhav Joshi
Hi Check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 11:48 AM, big smile bigsmile...@gmail.com wrote: Respected Vaibhavji I am changing the value of -- Sheet6-C22 - everytime - By formula =H33 Where it

$$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

2014-12-21 Thread big smile
Hellow Friends 1] I am changing the value of -- Sheet6-C22 - everytime 2] The same value should be pasted in the box show B4 : g13 3] The 1 st change in c22 - pasted on b4 of sheet1 4] The 2 nd change in c22 - pasted on c4 of sheet1 so on