Re: $$Excel-Macros$$ querry

2011-04-09 Thread ashish koul
see if it helps On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote: Please reply. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ querry

2011-04-09 Thread Mahesh parab
Hi Nemi find attach On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote: Please reply. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Command button

2011-04-09 Thread Jai
Dear Expert i Have a Excel file, i Want to use Command button in vba code please help me. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Re: Macro to generate PDF document

2011-04-09 Thread Simran Singh
Hello Experts, I have an excel sheet, wherein I have list of candidates joined in a particular week. Now I have to prepare their offer letter in a PDF format. I am looking for a macro which takes the name, salary and DOJ form the excel sheet and generate a PDF format document with the help of

Re: $$Excel-Macros$$ Re: Macro to generate PDF document

2011-04-09 Thread ashish koul
can u attach the sample and also r u using excel 2007 On Sat, Apr 9, 2011 at 3:55 PM, Simran Singh simran@gmail.com wrote: Hello Experts, I have an excel sheet, wherein I have list of candidates joined in a particular week. Now I have to prepare their offer letter in a PDF format. I

Re: $$Excel-Macros$$ Re: Macro to generate PDF document

2011-04-09 Thread Sanjoy Nath
in the pdf writer there is thedirect options to do this. If you dont have the pdf writer , you will have to develop the pdf file format as binary file from scratch.Thats touh. On 4/9/11, ashish koul koul.ash...@gmail.com wrote: can u attach the sample and also r u using excel 2007 On Sat,

$$Excel-Macros$$ calcutation of Tax for UK employees

2011-04-09 Thread srinivas m
Hi Team, This is srinivas. I am working in a MNC company. I need to calculate tax for UK employees every month. UK tax works on different tax codes basis and slabs which are mentioned below. example is attached : Slabs are 0-35000 -20% 35001 -150-40% 15 -50%

$$Excel-Macros$$ Help needed to Protect cells

2011-04-09 Thread Rambabu Mudiraj
Dear Friends, Help needed in Cells Protection can any one tell me that i cant able to put cursor in some cells how it is possible i want to know the option -- Regards Rambabu. G -- -- Some important links for excel

Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-09 Thread John A. Smith
Again, thank you Ashish very much. You have taught me a lot. John On Sat, Apr 9, 2011 at 6:27 AM, ashish koul koul.ash...@gmail.com wrote: in excel 2007 format On Fri, Apr 8, 2011 at 2:49 AM, John A. Smith johnasmit...@gmail.comwrote: Ashish, One more thing please; that macro in a

Re: $$Excel-Macros$$ querry

2011-04-09 Thread Dhananjay Pinjan
Dear Ashish, Pl. explain what is *=_xlfn.*SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5) Regards, Dhananjay On Sat, Apr 9, 2011 at 4:07 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote: Please reply. --

Re: $$Excel-Macros$$ Help needed to Protect cells

2011-04-09 Thread ashish koul
check out this link http://www.techonthenet.com/excel/cells/protect.php On Sat, Apr 9, 2011 at 6:44 PM, Rambabu Mudiraj rambabu1...@gmail.comwrote: Dear Friends, Help needed in Cells Protection can any one tell me that i cant able to put cursor in some cells how it is possible i want to

Re: $$Excel-Macros$$ querry

2011-04-09 Thread ashish koul
sumifs function is avaliable in excel 2007 onwards check out the link below http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan dppin...@gmail.com wrote: Dear Ashish, Pl. explain what is