Re: $$Excel-Macros$$ Excel Test

2011-07-28 Thread Kumar Punnam
On Thu, Jul 28, 2011 at 12:05 PM, NOORAIN ANSARI wrote: > Dear All, > > Please find attached Excel Test. > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* > > -- > > ---

Re: $$Excel-Macros$$ PASSWORD REMOVER

2010-08-18 Thread Kumar Punnam
Hi Viju Please let me know how to use this addin. Thanks in advance With Regards P.V. Ravi Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/ex

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

2010-08-05 Thread Kumar Punnam
On Tue, Aug 3, 2010 at 5:54 PM, Nadine S wrote: > Let me try this again. > > Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, > G, and H. If those all match then I need to check if column AH in Sheet 1 > matches either R2, R1 or R4 in Sheet 2. If so, then I need to sum

Re: $$Excel-Macros$$ Help Urgent Page break Preview Problem

2010-07-31 Thread Kumar Punnam
Hi , Use 'reset print area", or unhide the hiden rows, freeze panes and try it once . i hope this wil help you Ravi Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and lin

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

2010-07-27 Thread Kumar Punnam
=sumproduct(R1:R3,C1:C3) On Mon, Jul 26, 2010 at 1:18 PM, SUMIT VYAS wrote: > good > > On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh > wrote: > >> Hi There, >> >> See attached file. >> >> >> >> Warm Regards, >> >> Harmeet Singh >> IT Analyst >> McKinsey & Company >> http://www.facebook.co

$$Excel-Macros$$ Hide a single work sheet with password

2010-07-22 Thread Kumar Punnam
Dear Friends, I am having important information in Sheet2 which wa named as "Fuel Item" along with Sheet1 "Fuel Summary", i would like to hide the sheet2 and protect it with password so that no one can access it at all, i need a VBA Code or any suggestion Thanking You, With Regards, P.V. Ra