Re: $$Excel-Macros$$ Some Sorting Technique

2011-08-27 Thread rajan verma
Great Noorain!! Does anybody have more method for sorting.. On Sat, Aug 27, 2011 at 9:06 PM, NOORAIN ANSARI wrote: > Hi Group, > > I have added some extra sorting tips in rajan's Sorting tips. > Like > Sorting through Vlookup/Hlookup > Sorting Through Sumporduct > > Vertical and Horizental both

$$Excel-Macros$$ Need help --------

2011-08-27 Thread jocky Beta
Hi Team, I had create Compound Calculator in Excel VB sheet , i had already set the Formula in VB but when i Click on the Calculate Button it shows error, hence i request you to help me on this. Regards -- -- Som

$$Excel-Macros$$ Conditional Formatting

2011-08-27 Thread Zafar Iqbal
Dear Experts, I am still waiting for reply from you all. Please help me in this matter. Thanks Regards, Zafar Iqbal On Sat, Aug 27, 2011 at 10:29 AM, Zafar Iqbal wrote: > Dear Expert, > > Ref your instructions, please find attached file with conditional > formatting applied. My worry is about

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread Venkat CV
Hi Sajid, Just install the below PDF Printer Driver and use code for Printing... http://www.bullzip.com/products/pdf/info.php *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 3:58 AM, SAJID MEMON wrote: > Dear Experts, > > I want an active sheet with command button (EXCEL 2003) con

Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

2011-08-27 Thread Venkat CV
Dear Noorain, Good solution array formula... *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 8:48 AM, NOORAIN ANSARI wrote: > Dear Kannan, > > Venkat solution is great but you can use one Vlookup Instead of Three > Vlookup. > > Press ctrl+shift+Enter > > {=VLOOKUP(B2,'Aug 11'!$C:$J

Re: $$Excel-Macros$$ Guruuuuuuuu URGENT HELP ME

2011-08-27 Thread mrinal saha
are you sure your data is correct.. because none of the sim or mobile no from last sheet matches to any of the sheet. regards, Mrinal On Sat, Aug 27, 2011 at 4:10 PM, kannan excel wrote: > Dear Guru, > > > Pls find the attachment and help me. > and i want vloopkup formulas. > > Your's > > kannan

Re: $$Excel-Macros$$ Some Sorting Technique

2011-08-27 Thread NOORAIN ANSARI
Hi Group, I have added some extra sorting tips in rajan's Sorting tips. Like Sorting through Vlookup/Hlookup Sorting Through Sumporduct Vertical and Horizental both sorting attached herewith. On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote: > Hi Group, > > Refer the attached sheet with

Re: $$Excel-Macros$$ Some Sorting Technique

2011-08-27 Thread kannan excel
Hi rajan, good work. keep it up. fantastic regards Kannan V Aircel limited On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote: > Hi Group, > > Refer the attached sheet with some Data Sorting Example. Hope you will like > it > > ** ** > > Rajan. > > ** ** > > -- > > -

Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

2011-08-27 Thread kannan excel
Thanks Guru. i am really happy. Regards Kannan V Aircel Limited. Chennai On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote: > Hi Kannan.. > > Look attached... > > On Sat, Aug 27, 2011 at 4:37 PM, kannan excel wrote: > >> Pls help guru, its most urgent for me. >> >> help me >> >> On Sat, Au

Re: $$Excel-Macros$$ Some Sorting Technique

2011-08-27 Thread Venkat CV
Hi Rajan, It's Superb... *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote: > Hi Group, > > Refer the attached sheet with some Data Sorting Example. Hope you will like > it > > ** ** > > Rajan. > > ** ** > > -- > > --

Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

2011-08-27 Thread Venkat CV
Hi Kannan, You are Welcome... *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 27, 2011 at 5:51 PM, kannan excel wrote: > Thanks Guru. > > i am really happy. > > Regards > > Kannan V > Aircel Limited. > Chennai > > On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote: > >> Hi Kannan.. >> >> Loo

Re: $$Excel-Macros$$ Fill empty cells with zero

2011-08-27 Thread Lawali
Rajan's solution is simple, easy and I like it bestbut it does not address the need for formula as requested. On Aug 26, 6:21 am, "Rajan_Verma" wrote: > Press CTRL+G Goto Special Choose Blanks , > > It will select all Blank cell then Press 0 and Ctrl + Enter > > From: excel-macros@googlegroup

Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME

2011-08-27 Thread kannan excel
Pls help guru, its most urgent for me. help me On Sat, Aug 27, 2011 at 4:20 PM, kannan excel wrote: > Sorry Guru, > > Not i attached valid SIM NUMBER. You can match that in sim number > > > thanks & regards > Kannan V > Aircel Limited > Chennai > > > > On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread rajesh a
Hi friend, Pls try this website http://www.ipdfconverter.com/ Regards Rajesh A TCS Chennai On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON wrote: > Dear Experts, > > I want an active sheet with command button (EXCEL 2003) convert into pdf > file. when i click on command button > it convert and

RE: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread Rajan_Verma
See the Below Link .. http://www.mrexcel.com/forum/showthread.php?t=379973 http://www.pcreview.co.uk/forums/convert-excel-pdf-via-vbulletin-code-t95734 4.html http://www.giveawayoftheday.com/vba+code+convert+to+pdf/ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

$$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread SAJID MEMON
Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query i don't want to use any other con

Re: $$Excel-Macros$$ Fill empty cells with zero

2011-08-27 Thread Usha Gusain
Thanks. With regards, Usha On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote: > We have some blank cells in excel (2007), which we want to fill with zero. > what is the formula for the same? > > With regards, > Usha > > -- > > -

RE: $$Excel-Macros$$ Conditional Lookup or data validation

2011-08-27 Thread Daniel
Hello, See attached workbook. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de C.G.Kumar Envoyé : vendredi 26 août 2011 06:14 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Conditional Lookup or data validation Dear All,

Re: $$Excel-Macros$$ 2003 excel to pdf

2011-08-27 Thread Venkat CV
Hi Sajid, Just Upload in this website..and you will get as a PDF http://www.pdftoexcelonline.com/ Install Below application and try Print Option.. http://www.bullzip.com/products/pdf/info.php *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 1:54 PM, SAJID MEMON wrote: > Dear Exper

RE: $$Excel-Macros$$ 2003 excel to pdf

2011-08-27 Thread Rajan_Verma
You can Download DoPDF Printer its Free On Internet .. http://www.dopdf.com/download.php From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAJID MEMON Sent: Saturday, August 27, 2011 1:54 PM To: Excel Group Subject: $$Excel-Macros$$ 2003 excel to pdf

$$Excel-Macros$$ 2003 excel to pdf

2011-08-27 Thread SAJID MEMON
Dear Experts, I want an active sheet (EXCEL 2003) convert into pdf file and after convert it should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query awaiting your positive responce sajid memon

Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns

2011-08-27 Thread STDEV(i)
without macro solution Assuming 1,2,3,4,5 etc is stored in A1:A300 Put this formula in D1 *=OFFSET($A$1,ROW(A1)*3-(4-COLUMN(A1)),0)* copy right & down 3 columns x 100 rows best regards, ~ siti On Fri, Aug 26, 2011 at 8:45 PM, GreenBriar wrote: > Transpose would not work because every 4

RE: [[Released From Quarantine ]-] $$Excel-Macros$$ Fill empty cells with zero

2011-08-27 Thread Amit Desai (MERU)
Use conditional formatting... Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Usha Gusain Sent: Friday, August 26, 2011 12:40 PM To: excel-macros@googlegroups.com Subject: [[Released From Quarantine ]-] $$Excel-Macros$$ Fill empty