Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-05 Thread respuzy
2013 19:32:40 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Auto Sum in Macro Recording This message is eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-05 Thread Hilary Lomotey
Wow Great VBA sorry for replying late, but this is great. Just a little adjustment i realized you were dividing it by the sum total of the capital gains, it should rather be dividend by the market value instead for the % of equities , however the % of portfolio should be the total of the equities m

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread P.VIJAYKUMAR
Respected Vikas, Select the sheet and go to the format tab then protection tab of the dialiog box and remove the checkmarks for locked and hidden boxes.T hen select the cell for which that contain the formulas,then go gain to the format tab and recheck the locked and hidden boxes.Now,go to the rev

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread vba
Dear Vikas, Pl start new thread!! You will get response though. Thanks On Sat, Aug 3, 2013 at 8:05 PM, vikas tyagi wrote: > Hallo...experts. > How I can hide formulas to others in a sheet. > On Aug 3, 2013 2:24 PM, wrote: > >> ** >> Hi bosses >> >> Any assistance with this? Cheers >> Sent fr

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread vikas tyagi
Hallo...experts. How I can hide formulas to others in a sheet. On Aug 3, 2013 2:24 PM, wrote: > ** > Hi bosses > > Any assistance with this? Cheers > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Hilary Lomotey > *Sender: * excel-macros@googleg

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread vba
Hey Hillary Can you show an example of what you want in tustee sheet & also highligh the same with yellow color. Thanks On Fri, Aug 2, 2013 at 5:10 PM, Hilary Lomotey wrote: > Hello Experts, > > In the attached file, i have created two database, FIS and Equities > Database, and based on the d

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread respuzy
Hi bosses Any assistance with this? Cheers Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Fri, 2 Aug 2013 12:40:20 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$