$$Excel-Macros$$ Access Problem

Hi Guys, Some time when i want to import any data in Access then i get an error "* is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.*" can Any one suggest me how to remove this error. Thanks Yo

Re: $$Excel-Macros$$ Fwd: Plz help me

Check this might be it help On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya wrote: > > All Friends > > I have some solution. I have problem to create the report look in attached > Excel Sheet. > > -- > ***Thanks & Best Regards** > Sanjay Kumar Maurya* > > * > Life is Very beautiful !!! > * > * >

$$Excel-Macros$$ Please Complete this Calculator

Hi All, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Exce

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

Sorry Renuka, Not TRIM use Clean Formula. =Clean(A1) TRIM formula use to clean unnecessary space from the text. On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help me plz > > -- > > -

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

Hi Renuka, You can use TRIM formula. Like =TRIM(A1) Thanks and Regards Yogesh Gohil On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help

Re: $$Excel-Macros$$ Help me in this

Its works. Thanks Dave. On Sun, Apr 24, 2011 at 5:50 PM, Dave Bonallack wrote: > Hi Yogesh, > I only have one other idea to stay with your worksheet functions. All your > Countifs functions contain whole column references. > > eg: =COUNTIFS(DB_Sheet!*$D:$D*,$A16,DB_Sheet!*$E:$

Re: $$Excel-Macros$$ Help me in this

Thanks Dave, for your suggestion. but problem is that i want to update all sheets on daily basis. If i'll do this, it also be take same time. If you have any other idea please share with me. I am also working on it if i will get any solution then i will tell you. Thanks & Regards Yogesh

$$Excel-Macros$$ Help me in this

Hi Experts, Actually, this waterfall made by me but its take 3hour to complete. Please help me out to make easy and time reducer format. This format have Excel function and VBA coding. *For the attachment you can click on* http://www.megaupload.com/?d=8KTIVGZX Thanks & Regards Yogesh G

Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

Thanx Ansul, This code really works. Regards Yogesh Gohil On Sun, Apr 17, 2011 at 11:13 AM, ashish koul wrote: > try this > > Sub method2() > Dim i, j, k, s As Long > s = Sheets.Count > Sheets.Add After:=Sheets(Sheets.Count) > For i = 1 To s > Sheets(i).Select > &#x

$$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

Hi Experts, Please provide me the solution for this. Regards Gohil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linked

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

by Text to Column you change its format. Short Key is ALT+D+E Select *Delimited -> Click Next -> Click Next -> Select Date Format (DMY) -> Click Finish* On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor wrote: > Dear all, > > Would like to seek your kind assistance/help on the date f

Re: $$Excel-Macros$$ Problem in pivot table

Like this??? On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each catego

Re: $$Excel-Macros$$ New Rupee Symbol

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

Re: $$Excel-Macros$$ Integrating Outlook with Excel

Hello Group, Any updates regarding my query? Thanking you in anticipation. Yours truly, Yogesh Kudva On Nov 29, 11:27 am, Yogesh Kudva wrote: > Hi, > > Thanks for your prompt response. > > I am using Office 2007. > > My requirement is to first create a rule that will sor

Re: $$Excel-Macros$$ Integrating Outlook with Excel

Hi, Thanks for your prompt response. I am using Office 2007. My requirement is to first create a rule that will sort the mails depending on the deadlines. Secondly create a list of mails received. Thanks & Regards, Yogesh Kudva On Sun, Nov 28, 2010 at 11:59 AM, wrote: > Dear Yogesh,

$$Excel-Macros$$ Integrating Outlook with Excel

creates a list of mails received in Excel but that too works only for the mails of the Primary Inbox and not of the Mailbox Inbox. Could anyone of you help me with the same? Thanking you in anticipation. Yours truly, Yogesh Kudva

$$Excel-Macros$$ Re: Ayush Jain – Microsoft MVP 20 10

Hi Ayush, Heartiest Congratulations Regards, Yogesh Kudva On Oct 3, 3:17 pm, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing technical expertise > in Excel technical commu

$$Excel-Macros$$ Re: New to the group - basic question

Hi, 1 - 65% = 100% - 65% = 35% 18.25 / 35% = 52.14 Regards, Yogesh On May 27, 11:45 pm, markndawoods wrote: > what is this formula designed to provide? > > =F24/(1-F25) > > where cell F24 is a dollar figure of $18.25 > and cell F25 is a percent 65% > > It is in a s

Re: $$Excel-Macros$$ Need help in automating this report

Hi Girish, Thanks a ton for working on this report. You are great. You have made my day. Thanks & Regards, Yogesh On May 20, 10:21 am, girish naik wrote: > Hi Mate your work is done. > > Please check if this meets your requirement.. > > Click on the button which is on Do

$$Excel-Macros$$ Tip: How to use excel

"Number of items to retain per field" is set to "Automatic". By changing it to "None", the pivot table does not retain the items deleted from the data source. Thanks & Regards, Yogesh Kudva 9224283092 -- ---

$$Excel-Macros$$ Re: Urgent need some about how can calculate week

Hi, You may use the following formula: ="Week "&WEEKNUM(A2) This would give the week number of the calendar year. Thanks & Regards, Yogesh Kudva On Mar 23, 2:41 pm, prabhakar thakur wrote: > Dear All, >                           I need Urgent Help, How can  calcul

Re: $$Excel-Macros$$ Re: vba code password protected pls help

Hi Roshan, Requesting you to read the reply which I have provided. You may download the file from the link mentioned in the mail. Thanks & Regards, Yogesh Kudva On Mar 17, 3:00 pm, Roshan Mathew wrote: > Pls forward us Hex Editor > > > > > > On Wed, Mar 17, 2010 a

$$Excel-Macros$$ Re: vba code password protected pls help

H Yogesh, To crack the password of an VBA Macro / coding first download an HEX Editor. It is available from the site http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm (its a very small file of 0.5 MB capacity). Close the workbook and open the workbook file in the hex editor. Find

$$Excel-Macros$$ Re: Need help to save data from one file to another

Hi Team, Could anyone of you provide me the solution? Thanks in advance. Regards, Yogesh Kudva On Nov 23, 9:54 am, "Yogesh V. Kudva" wrote: > Hi Team, > > I need help regarding the attached file. > > PFA the sample file in which I enter the data in the form and w

$$Excel-Macros$$ Need help to save data from one file to another

anticipation, Yours truly, Yogesh V. Kudva --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

$$Excel-Macros$$ Re: How to copy Excel files thru Command prompt

Hi, copy filename destination path eg. copy book1.xls c:\my documents 2009/5/5 singla.kris...@gmail.com > > Hi eveybody, > > can anyone tell me how to copy excel files using command prompt. > > thanx in advance > > > > -- Than

$$Excel-Macros$$ Re: FIND / (RELACE) data in a hidden HYPERLINK

Hi, This looks very easy... There is one utility called ASA utility. you can easily extract the hyperlinks with the help of this utility. Anywz i am providing the URL for this utility... www.*asap*-utilities.com/ Regards and a nice day. yogesh * *2009/2/11 jmsprof <1su...@gmail.com>

$$Excel-Macros$$ Re: Help-Excel files formula

Hi Rabindra, Please find attached updated sheet with solution. Thanks, yogesh 2009/2/3 Rabindra Thapa > > Please help me on attach files. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep

$$Excel-Macros$$ Re: $$Excel-Macros$$

Hi Dude... Yes it is there for that you need to install add in - --- Analysis Tool pack the FUNCTION name is =WEEKNUM(A1). hope this will work.. Thanks, yogesh 2008/9/18 Lakshmanan T S <[EMAIL PROTECTED]> > Hi friends, > > Is there any predefi