$$Excel-Macros$$ Need Access help

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 0191247

$$Excel-Macros$$ Help req

*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

; 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 > wrote: > >> * >> >> >> Dear Sir, >> >>

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

* Dear Sir, Plz if any other formula... plz * On Tue, Dec 21, 2010 at 12:46 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > Please see attached sheet.. > > Thanks, > Noorain Ansari > > On Mon, Dec 20, 2010 at 11:02 PM, Rakesh Sharma > wrote: > >> * >

Re: $$Excel-Macros$$ Help Required

the attached sheet > replacing 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 wrote: > >> Dear All, >> >

$$Excel-Macros$$ Help Required

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

PM, anil panchal wrote: > >> Dear Rakesh, >> >> Please find the attached solution. >> >> Thanks & Regards >> Anil Kumar >> 113784 >> >> >> >> On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma wrote: >> >>> *Dear

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

t;> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> >>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref

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

*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$$ Help Required - Gantt Chart

Hi Maniyan, Here is the solution which I think my help you.  Regards Rakesh The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/-- -- Some important links for excel use

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

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 Fld

$$Excel-Macros$$ Re: Excel and Access connectivity

Hi, You can use DAO or ADODB to connect excel and access. For your referance : http://doc.ddart.net/mssql/sql2000/html/mdacxml/htm/wpmigratingopening.htm http://www.winsoft.sk/daofaq.htm http://vbatalent.blogspot.com/2009/05/create-select-query-using-sql-in-vba.html Regards Rakesh On Jul 27, 9

$$Excel-Macros$$ Re:

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 wrote: > HI All, > > Name : Rakesh Shar,ma > Subject : Show formulas in printable

$$Excel-Macros$$ Re:

Hi All, Name : Rakesh Shar,ma Subject : Remove Border formatting Tip : Press Ctrl + Shift + _ (Under Score) On Jun 10, 5:15 pm, Rakesh Sharma wrote: > HI All, > > Name : Rakesh Shar,ma > Subject : Show formulas in printable format > Tip     :  Press Ctrl + ~  ( To V

$$Excel-Macros$$ Re:

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 wrote: > Hello Everyone, > > Please submit your tip in this post for Week

$$Excel-Macros$$ Re: Custom function for cell color

Hi you can follow this link below. i have used a custom function for conditional formatting. http://groups.google.co.in/group/vbatalent/web/Consolidate%20Transaction%20Type.xls?hl=en Regards Rakesh On May 15, 7:07 am, zek2005 wrote: > Hi! > > I need to create a function to define a color of

$$Excel-Macros$$ Re: Concatenating Problem

Hi You can try this. Column A Column B Column C 5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm")," ",B1) Result would be : 5/13/2009 07:33:00 PM ABC Regards Rakesh On May 12, 12:57 pm, jamadagnira...@gmail.com wrote: > Hello, > > I have a proble