$$Excel-Macros$$ Need Access help

2013-07-05 Thread Rakesh Sharma
9 Mohit12 Raman 9 Thanks in advance...!!! ** RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442

$$Excel-Macros$$ Help req

2011-01-20 Thread Rakesh Sharma
*Hi ,* * * * * *Please help me to make simple dashboard to modified .* * * *for reference see attachment,* * * * * *thanks in adv..* -- Regards Rakesh Sharma -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-21 Thread Rakesh Sharma
* Dear Sir, Plz if any other formula... plz * On Tue, Dec 21, 2010 at 12:46 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rakesh, Please see attached sheet.. Thanks, Noorain Ansari On Mon, Dec 20, 2010 at 11:02 PM, Rakesh Sharma rksharma...@gmail.comwrote: * HI

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-21 Thread Rakesh Sharma
... Please see attachments.. =SUMPRODUCT(($A$2:$A$1081=$H3)*($C$2:$C$1081=I$2)*($B$2:$B$1081)) -- Thanks regards, Noorain Ansari On Tue, Dec 21, 2010 at 12:32 AM, Rakesh Sharma rksharma...@gmail.comwrote: * Dear Sir, Plz if any other formula... plz * On Tue, Dec 21, 2010

Re: $$Excel-Macros$$ Help Required

2010-11-11 Thread Rakesh Sharma
date =A2+30 By adding 30days u are getting the answer...Please let me know if this resolves your query or not. Thanks, Raj On Thu, Nov 11, 2010 at 10:48 AM, Rakesh Sharma rksharma...@gmail.comwrote: Dear All, Can i replace the date as per my requirement. if yes plz suggest me

$$Excel-Macros$$ Help Required

2010-11-10 Thread Rakesh Sharma
Dear All, Can i replace the date as per my requirement. if yes plz suggest me how it possible. Thanks in advance plz do the needful ASAP. -- Regards Rakesh Sharma -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ macro to save it to a particular drive / file location.

2010-09-30 Thread Rakesh Sharma
*Hi , I am rakesh from Jammu and i want to know more about macro, and i also want to know how to use macro and whats the functions of macro, and my another question is can we add 2 values in vlookup . please get the attached sheet for exp. Rakesh Sharma * On Thu, Sept 30, 2010 at 1:00 PM

$$Excel-Macros$$ Re: Excel vba for outlook

2009-08-13 Thread Rakesh Sharma
Hi, If you use the below code, you don't need to use any mail client (i.e outlook). you can send mail using any application either excel, access etc Sub Sendmail() Set imsg = CreateObject(CDO.Message) Set iConf = CreateObject(CDO.Configuration) iConf.Load -1 ' CDO Source Defaults Set Flds =

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-11 Thread Rakesh Sharma
Hi All, Name : Rakesh Shar,ma Subject : Remove Border formatting Tip : Press Ctrl + Shift + _ (Under Score) On Jun 10, 5:15 pm, Rakesh Sharma rak_sha...@yahoo.co.in wrote: HI All, Name : Rakesh Shar,ma Subject : Show formulas in printable format Tip     :  Press Ctrl + ~  ( To View

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-11 Thread Rakesh Sharma
HI All, Name : Rakesh Shar,ma Subject :For Quick Chart Tip : Press F11 To prepare quick chart based on data, Just select the your data and press F11. On Jun 10, 5:15 pm, Rakesh Sharma rak_sha...@yahoo.co.in wrote: HI All, Name : Rakesh Shar,ma Subject : Show formulas in printable

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-10 Thread Rakesh Sharma
HI All, Name : Rakesh Shar,ma Subject : Show formulas in printable format Tip : Press Ctrl + ~ ( To View formulas in printable format or to take a printout for forumlas enter in cells) On Jun 5, 8:41 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, Please submit your tip in