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

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 impedimenta.st...@gmail.comwrote: Transpose

$$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$$ 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

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

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$$ 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 ushadhvin...@gmail.comwrote: 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 --

$$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

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

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 sajidwi...@hotmail.com wrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command

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 kannan.ex...@gmail.comwrote: 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,

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 rajanverma1...@gmail.com wrote: Press CTRL+G Goto Special Choose Blanks , It will select all Blank cell then Press 0 and Ctrl + Enter From:

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 kannan.ex...@gmail.comwrote: Thanks Guru. i am really happy. Regards Kannan V Aircel Limited. Chennai On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV venkat1@gmail.com

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 rajanverma1...@gmail.comwrote: 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 venkat1@gmail.com wrote: Hi Kannan.. Look attached... On Sat, Aug 27, 2011 at 4:37 PM, kannan excel kannan.ex...@gmail.comwrote: Pls help guru, its most urgent for

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 rajanverma1...@gmail.comwrote: Hi Group, Refer the attached sheet with some Data Sorting Example. Hope you will like it ** ** Rajan. ** ** --

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 rajanverma1...@gmail.comwrote: Hi Group, Refer

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 kannan.ex...@gmail.comwrote: Dear Guru, Pls find the attachment and help me. and i want vloopkup formulas.

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 sajidwi...@hotmail.com wrote: Dear Experts, I want an active sheet with command