Re: $$Excel-Macros$$ Vlookup
Hi Muralidhar, did u check the attached pivot solution let me know if it is not apt then i will do v-lookup fucntion as u sent. Thanks, Raj On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e emuralidha...@gmail.comwrote: Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. -- Forwarded message -- From: muralidhar e emuralidha...@gmail.com Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Fwd: Hide Protect Sheet from other User
Dear Ayush, Thanks .. it is also usefule for me. But i dont know VBA aslo. If you can breif in detail path then it will be great help for me. Thanks in advance. Regards, Darshil Shah. On Thu, Nov 11, 2010 at 8:38 AM, Ashish Jain 26may.1...@gmail.com wrote: Hi Hemant You can use these VBA methods to solve your problem: Sheets(1).Visible = xlSheetHidden 'Hide the worksheet Sheets(1).Visible = xlSheetVeryHidden 'Hide the worksheet and won't be displayed in Unhide Worksheet dialog list Sheets(1).Protect(Password) 'Replace password with your own password Please modify them as per your need. Please Note: I didn't opened your excel workbook and I suggest you to send your problems rather sending workbook as it's a dangerous practice. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Sep 14, 2:10 am, hemant shah hemanthin...@gmail.com wrote: Hi Team, Please help on the attached. Thanks in advance. Regards, Hemant Shah Hide Protect the Sheet from other Users.xls 54KViewDownload -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Darshil Shah. darshil.m...@gmail.com +91-9725503879 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Refreshable Web Query
Hello Ashish, Thanks for the reply, I think the solution worked just fine. I aint recevng those messages regarding running scripts. thanks a ton buddy. :) On Wed, Nov 10, 2010 at 12:25 PM, Ashish Jain ashishj...@openexcel.comwrote: Hi Kush, The method explained below will stop annoying you because the Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the number of script statements executed, the time-out dialog box will not display during ActiveX control or database-access delays. Endless loops in script will still be detected. Caution: Take a backup of registry before committing this change. 1. To change this time-out value in Internet Explorer 4.0, 5.0, 6, 7, or 8, follow these steps: Using a Registry Editor such as Regedt32.exe, open this key: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Styles *Note If the Styles key is not present, create a new key that is called Styles. 2. Create a new DWORD value called MaxScriptStatements under this key and set the value to the desired number of script statements. If you are unsure of what value you need to set this to, you can set it to a DWORD value of 0x to completely avoid the dialog. For details Refer to MicroSoft Knowledge Base : http://support.microsoft.com/kb/175500 Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 14, 9:02 am, kush sharma kushleshsha...@gmail.com wrote: Heloo Everyone, I have this problem whenever i try to create a refreshable web query. As soon as i eneter the link in the web address bar the window appears which asks something like this page contains a script, do you wish to continue? now i do click yes, but this message appears again so fast that i cannot get past it...is there any particular solution to this thing or any excel setting that i have to do? I'd be glad to have some good response. -- * Regards Kushlesh Sharma * -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- * Regards Kushlesh Sharma Research Analyst Swastika Investmart Limited Email: kushsha...@swastika.co.in * -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Vlookup
hai, sorry like this, it is not useful for me(for my internal office work). for my work i want like this only, Is their any possibility like this plz find the solution, and one more thing is that the batches are like this are nearly 2,so their is no possiblity to use the pivot table, i check like this also. Plz give the solution what i have asked format. it will usefull me. Thanks and Regards, Muralidhar E. On Thu, Nov 11, 2010 at 12:47 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e emuralidha...@gmail.comwrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ search until a blank cell is found.
i have a column filled with month names. but not in order here and there. not in a list. I want to search for all sep in that whole column and put the values next to it another column. but How to end the loop once it reach the last sept in the column. In other words howt to stop it from endless looping -- Sub Macro1() Dim count As Integer Columns(B:B).Select Selection.Find(What:=sep, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Do While ActiveCell Selection.FindNext(After:=ActiveCell).Activate ActiveSheet.Range(DU10).Offset(count, 0).Value = ActiveCell.Offset(0, 5).Value count = count + 1 Loop -- -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Help Required
*No dear its still pending * On Thu, Nov 11, 2010 at 12:59 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: hello rakesh, Only for this attached sheet do you have query or Prior chain mails as well, then i think u can just use this formula for 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 rksharma...@gmail.comwrote: 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. 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards Rakesh Sharma -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: search until a blank cell is found.
Hi Lakshitha There are many ways to find last row, one of them is using End method of range. Here is modified code and try let us know, if it works --- Sub Macro1() Dim count As Integer Dim lstRow As Integer Dim fCell As Range 'First Cell Found Dim fAdd As String 'Adress of First Cell 'To determine the Last Row in the column B lstRow = Range(B65536).End(xlUp).Row Range(B1:B lstRow).Select On Error GoTo ErrorH Selection.Find(What:=sep, After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate fAdd = ActiveCell.Address Do Selection.FindNext(After:=ActiveCell).Activate Range(DU10).Offset(0, count).Value = ActiveCell.Offset(0, 1).Value count = count + 1 Loop While ActiveCell.Address fAdd ErrorH: End Sub --- Try to understand the logic and post back, if need clarifications. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 11, 2:12 pm, Lakshitha luxit...@gmail.com wrote: i have a column filled with month names. but not in order here and there. not in a list. I want to search for all sep in that whole column and put the values next to it another column. but How to end the loop once it reach the last sept in the column. In other words howt to stop it from endless looping --- --- Sub Macro1() Dim count As Integer Columns(B:B).Select Selection.Find(What:=sep, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Do While ActiveCell Selection.FindNext(After:=ActiveCell).Activate ActiveSheet.Range(DU10).Offset(count, 0).Value = ActiveCell.Offset(0, 5).Value count = count + 1 Loop --- --- -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Refreshable Web Query
My pleasure Kush and sorry to see your problem so lately. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 11, 1:15 pm, kush sharma kushleshsha...@gmail.com wrote: Hello Ashish, Thanks for the reply, I think the solution worked just fine. I aint recevng those messages regarding running scripts. thanks a ton buddy. :) On Wed, Nov 10, 2010 at 12:25 PM, Ashish Jain ashishj...@openexcel.comwrote: Hi Kush, The method explained below will stop annoying you because the Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the number of script statements executed, the time-out dialog box will not display during ActiveX control or database-access delays. Endless loops in script will still be detected. Caution: Take a backup of registry before committing this change. 1. To change this time-out value in Internet Explorer 4.0, 5.0, 6, 7, or 8, follow these steps: Using a Registry Editor such as Regedt32.exe, open this key: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Styles *Note If the Styles key is not present, create a new key that is called Styles. 2. Create a new DWORD value called MaxScriptStatements under this key and set the value to the desired number of script statements. If you are unsure of what value you need to set this to, you can set it to a DWORD value of 0x to completely avoid the dialog. For details Refer to MicroSoft Knowledge Base : http://support.microsoft.com/kb/175500 Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 14, 9:02 am, kush sharma kushleshsha...@gmail.com wrote: Heloo Everyone, I have this problem whenever i try to create a refreshable web query. As soon as i eneter the link in the web address bar the window appears which asks something like this page contains a script, do you wish to continue? now i do click yes, but this message appears again so fast that i cannot get past it...is there any particular solution to this thing or any excel setting that i have to do? I'd be glad to have some good response. -- * Regards Kushlesh Sharma * -- --- --- 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. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- * Regards Kushlesh Sharma Research Analyst Swastika Investmart Limited Email: kushsha...@swastika.co.in * -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: OPEN EXCEL - Needs your support and enthusiasm...
Thanks Andy, Anand Rajesh :) I'm working on making more fast, efficient, robust with lot of new user friendly and time-saving tools. Hope it will be blast !! Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 1, 1:55 pm, Rajesh Shah shrej...@gmail.com wrote: Looks very useful Kudos on the good job Regards Rajesh Shah On 1 November 2010 13:10, anandydr anand...@gmail.com wrote: Just downloaded the file. Let me play around with it for some time before I can add any comment on its utilities. Somehow I was able to see a few utilities which would be quite useful. Warm regards, Anand On Oct 31, 10:57 pm, Ashish Jain ashishj...@openexcel.com wrote: Dear Members, We're proud to launch OPEN EXCEL under the GNU Public License v3 which means it's available with source code to reach the maximum users around the globe with rapid development, more robust innovative features. Since, public forums like these are hub of great professionals, knowledge sharers and bug shooters, hence we thought to launch it here. While beginners may download it, use it and can learn from it, amateur, experienced and professionals may contribute their some time and mind in developing it further ... Below are Google project links to download, develop and suggest new features in OPEN EXCEL :) Download -http://code.google.com/p/openexcel/downloads/list Suggest New Feature -http://code.google.com/p/openexcel/issues/list Develop - Reply this post with your mail id, so that you can be added as developer in the project and project's mailing lists. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional)http://www.excelitems.comhttp:// www.openexcel.com -- --- --- 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. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: OPEN EXCEL - Needs your support and enthusiasm...
It amazing tool bro saves lot of time... keep it up and thanks a lot for creating and distributing to us... On Thu, Nov 11, 2010 at 3:36 PM, Ashish Jain ashishj...@openexcel.comwrote: Thanks Andy, Anand Rajesh :) I'm working on making more fast, efficient, robust with lot of new user friendly and time-saving tools. Hope it will be blast !! Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 1, 1:55 pm, Rajesh Shah shrej...@gmail.com wrote: Looks very useful Kudos on the good job Regards Rajesh Shah On 1 November 2010 13:10, anandydr anand...@gmail.com wrote: Just downloaded the file. Let me play around with it for some time before I can add any comment on its utilities. Somehow I was able to see a few utilities which would be quite useful. Warm regards, Anand On Oct 31, 10:57 pm, Ashish Jain ashishj...@openexcel.com wrote: Dear Members, We're proud to launch OPEN EXCEL under the GNU Public License v3 which means it's available with source code to reach the maximum users around the globe with rapid development, more robust innovative features. Since, public forums like these are hub of great professionals, knowledge sharers and bug shooters, hence we thought to launch it here. While beginners may download it, use it and can learn from it, amateur, experienced and professionals may contribute their some time and mind in developing it further ... Below are Google project links to download, develop and suggest new features in OPEN EXCEL :) Download -http://code.google.com/p/openexcel/downloads/list Suggest New Feature -http://code.google.com/p/openexcel/issues/list Develop - Reply this post with your mail id, so that you can be added as developer in the project and project's mailing lists. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional)http://www.excelitems.comhttp:// www.openexcel.com -- --- --- 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. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;. .. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ LOOK
Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward muralidhar eDear all, This is urgent to me, plz suggest solution as early as possible. Wa... 12:49 PM (4 hours ago) muralidhar eLoading...12:49 PM (4 hours ago) Reply |muralidhar e to excel-macros show details 12:49 PM (4 hours ago) Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. - Show quoted text - -- Forwarded message -- From: muralidhar e emuralidha...@gmail.com Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward Rajasekhar PraharajuHello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good ... 12:47 PM (4 hours ago) Rajasekhar PraharajuLoading...12:47 PM (4 hours ago) Reply |Rajasekhar Praharaju to excel-macros show details 12:47 PM (4 hours ago) Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj - Show quoted text - On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e emuralidha...@gmail.com wrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Solved key.xlsx 15K View as HTML Open as a Google spreadsheet Download Reply Forward Reply |Rajasekhar Praharaju to excel-macros show details 1:05 PM (3 hours ago) Hi Muralidhar, did u check the attached pivot solution let me know if it is not apt then i will do v-lookup fucntion as u sent. Thanks, Raj - Show quoted text -
Re: $$Excel-Macros$$ LOOK
check the attachment see if it helps you On Thu, Nov 11, 2010 at 5:02 PM, muralidhar e emuralidha...@gmail.comwrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward muralidhar eDear all, This is urgent to me, plz suggest solution as early as possible. Wa... 12:49 PM (4 hours ago) muralidhar eLoading...12:49 PM (4 hours ago) Reply |muralidhar e to excel-macros show details 12:49 PM (4 hours ago) Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. - Show quoted text - -- Forwarded message -- From: muralidhar e emuralidha...@gmail.com Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward Rajasekhar PraharajuHello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good ... 12:47 PM (4 hours ago) Rajasekhar PraharajuLoading...12:47 PM (4 hours ago) Reply |Rajasekhar Praharaju to excel-macros show details 12:47 PM (4 hours ago) Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj - Show quoted text - On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e emuralidha...@gmail.com wrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Solved key.xlsx 15K View as HTML Open as a Google spreadsheet Download Reply Forward
$$Excel-Macros$$ Corrupted Excel File
Hi everybody I have an important excel file which i have been working on. All of a sudden i am not able to open the file It says it is corrupted How can i recover the file. I am not able to copy it to another location or attach the same here. Trust this group will provide me a solution for this . I need this as i have no backup and it a important file Thanks Regards Rajesh M Shah -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Excel Encyclopedia ppt
Excellent one Vijay,Thanks a lot,, I need a help on the below one,, is it possible to get a formula to solve this I need all the data in the column B for the name raju, (no sum or no count) result should be in each field one data (as in master data) Hi, I need a formula for the below codition, In normal vlookup formula , I getting the reuslt as 45 (for the look up value of Raju )becuase it looks only the first row(Raju) what about others, I need a formula to get the details of B coloumn for the all * Raju. * *For example* Column A column B Raju 45 Raju 96 Kamal 87 Raju 45 Kamal 25 Appreciate your help in advance. Thanks Manjunath On Thu, Nov 11, 2010 at 6:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear All, Here are some of files which may be helpful to our friends. Regards, Vijaykumar -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Openings in Bangalore
Hi I am looking for reporting job in Bangalore. Let us know if any. Chanra Shekar B 98459 76015 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Excel Encyclopedia ppt
HI Manjunath check the attachment next time when you will post any query shoot a new email... On Thu, Nov 11, 2010 at 6:34 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Dear All, Here are some of files which may be helpful to our friends. Regards, Vijaykumar -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts TEST1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ how to know the content of a text box of user form
Hi, Please let me know how to obtain the content of a text box of user form? Thanks Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mis-transmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to use imcro application
Thanks raj On 11/10/10, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi Vilas, Please find the doc attached, which contains the basic procedure for recording macros. Just go through this doc, mean while i will be forwarding you the PowerPoint presentation in detail. Thanks, Raj On Wed, Nov 10, 2010 at 8:19 PM, VILAS CHAVAN vilaschav...@gmail.comwrote: Hi Friends, Any knw how to use imcro we all of u need to discuss about that, please share your Knowlege -- With Best Regards, - Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- With Best Regards, - Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ how to know the content of a text box of user form
Hi Hiren, Suppose I have a veriable called Fname now I have to get this variable's value from a Texbox in a user control. Lets take this Text Box name as Textbox1 now I will use Fname = Textbox1.value to populate my Fname variable with the value present in the Text Box. Textbox1.value is the answer of your question. :) Hope this example will help you. Regards, Deepak On Thu, Nov 11, 2010 at 8:52 PM, Hiren Sheth hiren.sh...@viteos.com wrote: Hi, Please let me know how to obtain the content of a text box of user form? Thanks Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mis-transmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Deepak Rai -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Auto Number Template
I wish to create an auto number Returns Order template. I've never used VBA or MACROS in Excel before although I did do some basic stuff with MS Basic back in the DOS days. I wish to create a template consisting of 10 fields. I would like for each time the template is opened, an auto generated sequential number in cell B1. I would like the auto generated number to start 21, and when the template has been filled, a print button that when clicked, will print 2 copies of the completed form, and auto save to a specific location, the filename same as auto generated number. I would also like the date to be automatically entered into cell B2. If this saved file is opened edited etc in the future, I need the auto number and date to not change. I've copied vba examples which say they will do what I want, but I must be doing something wrong, because I can't get any to work. I've created template and I've view code and selected workbook and pasted following code, but nothing happens! Private Sub Workbook_Open() Const DEFAULTSTART As Integer = 1 Const MYAPPLICATION As String = Excel Const MYSECTION As String = myInvoice Const MYKEY As String = myInvoiceKey Const MYLOCATION As String = A1 Dim regValue As Long With ThisWorkbook.Sheets(1).Range(MYLOCATION) If .Text Then Exit Sub regValue = GetSetting(MYAPPLICATION, MYSECTION, _ MYKEY, DEFAULTSTART) .Value = Format(date,YY) - format(regValue,0) SaveSetting MYAPPLICATION, MYSECTION, MYKEY, regValue + 1 End With End Sub Am I pasting in the wrong place? Can anybody help. I've seen commercial options to achieve what I require, but I want to learn how to do it myself, as I have many other projects I could use this experience for. Regards enquirer -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ seqence no using vba macro
hi experts good morning, thanks in advance i want to print in excel sheet cells to 1,2,3,4,5,6,.in the selected rang, can u help me any one vba code for that macro. thanking you for kind attention. -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Please help regard this question
Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts LEFT DATE.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Please help regard this question
Hey Jai, Supposing the dates are in cells A1 and A2, you can use the following in cell A3: =DATEDIF(A2,A1,y)IF(DATEDIF(A2,A1,y)1, years ,, year ,)DATEDIF(A2,A1,ym)IF(DATEDIF(A2,A1,ym)1, months ,, month ,)DATEDIF(A2,A1,md)IF(DATEDIF(A2,A1,md)1, days left., day left.) Please modify accordingly. Cheers, Andy On Fri, Nov 12, 2010 at 11:17 AM, Jai jaihumtu...@gmail.com wrote: Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Please help regard this question
Dear Jai... Please see attachment.. =TEXT(D5-D6,YY )YEAR, TEXT((D5-D6),mm) MONTH, TEXT((D5-D6),dd) DAYS Thanks, Noorain On Thu, Nov 11, 2010 at 9:47 PM, Jai jaihumtu...@gmail.com wrote: Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Thanks regards, Noorain Ansari -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts LEFT_DATE(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ VBA Code Required
Dear All Can Anyone help me for following problem. I want to compare 2 column (which are in different different file). Example, Consider File A and File B I want to compare column of (File A ,sheet 1, column X) to (File B, sheet 2, Column Y) There are chances that in (File A ,sheet 1, column X) there are 25 items and in (File B, sheet 2, Column Y) there are only 21 items then balance 4 items should get highlight . I want VBA code which will do following thing. Ask me the file ,ask me the sheet and aske me the column to be compare then compare the column and highlight -- Shrini -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts