Re: $$Excel-Macros$$ Need to be able to find duplicates before a space
select the range of your Numbers for example: B2:B200 you can apply a conditional formatting on that range the condition FORMULA is =COUNTIF($B$2:$B$200;B2)>1 On Thu, Dec 23, 2010 at 2:04 AM, Superkermit wrote: > I have a excel spreadsheet that has model numbers on the start of a > column and then a space and a description, what I need to do is be > able to have excel find all the duplicate model numbers and highlight > them, how should I go about doing this? > > -- -- 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=wall&ref=ts ctv conditional formatting for duplicated datas.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ new que - help required for large range of data filteration
hi Guys, have similar kinda que. sometimes when we filter on large data and simply select those rows and delete entire rows i.e. Alt+E+D+R data which is present in those filtered rows also get deleted. what is the reason behind this. From: Ms-Exl-Learner . To: excel-macros@googlegroups.com Sent: Wed, 22 December, 2010 11:22:11 PM Subject: Re: $$Excel-Macros$$ help required for large range of data filteration Excel 2003:- You can see only 1000 records in the Autofilter Dropdown. Not more than that. Excel 2007/2010:- You can see 1 records in the Autofilter Dropdown. Not more than that. So try to use some helper column based on your data criteria use some formula in helper column like Istext, Isnumber, Isblank, which will make the output as boolean and the result will be True or False and if you apply the auto filter for that then your drop down will show only 2 records True / False and you will be having another (Excel 2003-998 in your hand to show in Autofilter Dropdown) (Excel 2007/2010-9998 in your hand to show in Autofilter Dropdown) and you can try len function also. So it's purely based on the data and your requirement and how you use the functions. Hope it's clear and helpful to you! --- Ms.Exl.Learner --- On Wed, Dec 22, 2010 at 8:58 PM, renuka chari wrote: hi >good evening to all experts > >currentely i am trubling in large range data with filtaration > >my company data having nearly 4lac of rows in one file > >i need to sort that data using auto filter Option then it was not >showing all filterd data i don't know how to filter that large rang of >data > can u help me any one > if possible give me example > >thanks in advance > >-- >-- > >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=wall&ref=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=wall&ref=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=wall&ref=ts
$$Excel-Macros$$ Need to be able to find duplicates before a space
I have a excel spreadsheet that has model numbers on the start of a column and then a space and a description, what I need to do is be able to have excel find all the duplicate model numbers and highlight them, how should I go about doing this? -- -- 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=wall&ref=ts
Re: $$Excel-Macros$$ help required for large range of data filteration
Excel 2003:- You can see only 1000 records in the Autofilter Dropdown. Not more than that. Excel 2007/2010:- You can see 1 records in the Autofilter Dropdown. Not more than that. So try to use some helper column based on your data criteria use some formula in helper column like Istext, Isnumber, Isblank, which will make the output as boolean and the result will be True or False and if you apply the auto filter for that then your drop down will show only 2 records True / False and you will be having another (Excel 2003-998 in your hand to show in Autofilter Dropdown) (Excel 2007/2010-9998 in your hand to show in Autofilter Dropdown) and you can try len function also. So it's purely based on the data and your requirement and how you use the functions. Hope it's clear and helpful to you! --- Ms.Exl.Learner --- On Wed, Dec 22, 2010 at 8:58 PM, renuka chari wrote: > hi > good evening to all experts > > currentely i am trubling in large range data with filtaration > > my company data having nearly 4lac of rows in one file > > i need to sort that data using auto filter Option then it was not > showing all filterd data i don't know how to filter that large rang of > data > can u help me any one > if possible give me example > > thanks in advance > > -- > > -- > 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=wall&ref=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=wall&ref=ts
Re: $$Excel-Macros$$ xlsb files
The Personal.xlsb "Project" is only an Excel workbook that is hidden. So.. no, the VBA EDITOR cannot create a new workbook. But you could write some VBA code that can create a new workbook and hide it. If you want to copy Modules from one workbook to another, there is vba code to export and import modules too. Paul From: ray To: MS EXCEL AND VBA MACROS Sent: Wed, December 22, 2010 10:05:29 AM Subject: $$Excel-Macros$$ xlsb files i can copy and rename the personal.xlsb in explorer; when i do alt- F11, both the personal.xlsb and the new renamed xlsb are listed in the VBAProject Window with all modules intact. Is there a way within the VBA editor to create a new VBAProject(NewName.xlsb)? -- -- 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=wall&ref=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=wall&ref=ts
Re: $$Excel-Macros$$ help required for large range of data filteration
Is it possible that there are some blank rows? Before turning "on" the autofilter, select the top-left box where the A-Z column heading and row numbers meet. (or hit ctrl-A) then turn on AutoFilter. By default, autofilter only selects the block of data until it reaches a blank row. hope this helps, Paul From: renuka chari To: MS EXCEL AND VBA MACROS Cc: jva.ch...@gmail.com Sent: Wed, December 22, 2010 10:28:45 AM Subject: $$Excel-Macros$$ help required for large range of data filteration hi good evening to all experts currentely i am trubling in large range data with filtaration my company data having nearly 4lac of rows in one file i need to sort that data using auto filter Option then it was not showing all filterd data i don't know how to filter that large rang of data can u help me any one if possible give me example thanks in advance -- -- 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=wall&ref=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=wall&ref=ts
$$Excel-Macros$$ Re: help required for large range of data filteration
Hi Renuka, In excel 2003 you can only see 1000 unique items in autofilter,however in excel 2007 and 2010 you can view upto top 10001 unique items in Autofilter. In your case, You should use simple sort or Pivot table to manage your large data set. I hope it helps. Thanks. Best Regards, Ayush Jain Microsoft MVP -- -- 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=wall&ref=ts
$$Excel-Macros$$ help required for large range of data filteration
hi good evening to all experts currentely i am trubling in large range data with filtaration my company data having nearly 4lac of rows in one file i need to sort that data using auto filter Option then it was not showing all filterd data i don't know how to filter that large rang of data can u help me any one if possible give me example thanks in advance -- -- 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=wall&ref=ts
$$Excel-Macros$$ xlsb files
i can copy and rename the personal.xlsb in explorer; when i do alt- F11, both the personal.xlsb and the new renamed xlsb are listed in the VBAProject Window with all modules intact. Is there a way within the VBA editor to create a new VBAProject(NewName.xlsb)? -- -- 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=wall&ref=ts
$$Excel-Macros$$ Re: Lock the Object
I believe you just need to set the locked object on your item (already done in your sheet), and then put protection on the sheet. (Tools| Protection|Protect Sheet) On Dec 22, 7:08 am, Chandra Shekar wrote: > Hello, > > How to lock the object? User should not edit the object or delete the > object. > > Please find attached file. > > Thanks > > Chandra Shekar > > Object_Lock.xls > 25KViewDownload -- -- 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=wall&ref=ts
Re: Fwd: $$Excel-Macros$$ Values Against Max Values
Hi Saggi, Please see the attached solution which is now customized as per your need. Thanks. Best Regards, DILIPandey On Wed, Dec 22, 2010 at 3:52 PM, saggi wrote: > Dear Noorani, > > Thanks for help, kindly go through my question, Its easy to retrieve > Max value but i need Value againt the max value. > > On Dec 22, 1:18 pm, NOORAIN ANSARI wrote: > > Dear VJ, > > > > Please see attachment. > > > > Thanks, > > Noorain Ansari > > > > > > > > -- Forwarded message -- > > From: Vj Realsaggi > > Date: Tue, Dec 21, 2010 at 9:27 PM > > Subject: $$Excel-Macros$$ Values Against Max Values > > To: excel-macros@googlegroups.com > > > > Kindly Consider the Previous Mail > > > > -- > > > ------ > > 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 linkhttp:// > www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... > > > > -- > > Thanks & regards, > > Noorain Ansari > > > > > > > > Book1(Solved).xls > > 26KViewDownload- Hide quoted text - > > > > - Show quoted text - > > -- > > -- > 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=wall&ref=ts > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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=wall&ref=ts values against max values by DILIPandey.xls Description: MS-Excel spreadsheet
Fwd: Fwd: $$Excel-Macros$$ Values Against Max Values
Dear Saggi, Please see attachement as per your requirement,, Thanks, Noorain Ansari -- Forwarded message -- From: saggi Date: Wed, Dec 22, 2010 at 2:22 AM Subject: Re: Fwd: $$Excel-Macros$$ Values Against Max Values To: MS EXCEL AND VBA MACROS Dear Noorani, Thanks for help, kindly go through my question, Its easy to retrieve Max value but i need Value againt the max value. On Dec 22, 1:18 pm, NOORAIN ANSARI wrote: > Dear VJ, > > Please see attachment. > > Thanks, > Noorain Ansari > > > > -- Forwarded message -- > From: Vj Realsaggi > Date: Tue, Dec 21, 2010 at 9:27 PM > Subject: $$Excel-Macros$$ Values Against Max Values > To: excel-macros@googlegroups.com > > Kindly Consider the Previous Mail > > -- > ------ > 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 linkhttp:// www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... > > -- > Thanks & regards, > Noorain Ansari > > > > Book1(Solved).xls > 26KViewDownload- Hide quoted text - > > - Show quoted text - -- -- 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=wall&ref=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=wall&ref=ts Copy of Book1(Solved)(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Lock the Object
Hello, How to lock the object? User should not edit the object or delete the object. Please find attached file. Thanks Chandra Shekar -- -- 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=wall&ref=ts Object_Lock.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ how to use the macros in a closed book
Hi Experts Is it possible to use a macro in a workbook to another workbook when that book having the macro is closed.If possible pls let me know how to do it. Regards Rajesh Kainikkara -- -- 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=wall&ref=ts
Fwd: $$Excel-Macros$$ Excel userform & Vlookup List iteam help
-- Forwarded message -- From: vidyut more Date: Sun, Dec 19, 2010 at 10:46 AM Subject: $$Excel-Macros$$ Excel userform & Vlookup List iteam help To: excel-macros@googlegroups.com Dear experts I want use userform and in that a list iwant to use iteam from that list.More i want to use vlookup function or similar code when in list box we enter known iteam then by vlookup its info shold populated on user form and that data should copy to another sheet. Thanks -- -- 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=wall&ref=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=wall&ref=ts
Re: Fwd: $$Excel-Macros$$ Values Against Max Values
Dear Noorani, Thanks for help, kindly go through my question, Its easy to retrieve Max value but i need Value againt the max value. On Dec 22, 1:18 pm, NOORAIN ANSARI wrote: > Dear VJ, > > Please see attachment. > > Thanks, > Noorain Ansari > > > > -- Forwarded message -- > From: Vj Realsaggi > Date: Tue, Dec 21, 2010 at 9:27 PM > Subject: $$Excel-Macros$$ Values Against Max Values > To: excel-macros@googlegroups.com > > Kindly Consider the Previous Mail > > -- > ------ > 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 > linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > -- > Thanks & regards, > Noorain Ansari > > > > Book1(Solved).xls > 26KViewDownload- Hide quoted text - > > - Show quoted text - -- -- 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=wall&ref=ts
Fwd: $$Excel-Macros$$ Critical Doubt
Dear Joseph, Can u send sample excel sheet.. -- Thanks & regards, Noorain Ansari -- Forwarded message -- From: Joseph Date: Wed, Dec 22, 2010 at 12:21 AM Subject: $$Excel-Macros$$ Critical Doubt To: MS EXCEL AND VBA MACROS Hi! I am Having one query i hope i can free at the end of the session. Please help me we are educational industry maintaining student attendance i am expecting report like this. now a days we are maintaining student attendance in excel 2007 when ever students comming in they are placed "X" mark end of the result cell will disply how many days "X" and how many day they are "A" now i am looking students those comming "X" >3 days Continuously result cell should disply "REGULAR STUDENT" IF THE "A" BEYONDS <3+ Days Continuously the result cell should disply "IRREGULAR STUDENT" for your clarification student John from 1st - 4 attended classes regulary the result cell should disply "Regular Student" from 5,6,7 he is on leave now it self the result cell should be in "Regular student" when he falls leave from 8th that is more than 3days the result cell should Automatically disply "irregular student" .I hope you got my point. so, Those who is on leave more than 3 days we have to follow the student status. for that i am breaking my head for last some months pls help me in this regard regards -- -- 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=wall&ref=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=wall&ref=ts
$$Excel-Macros$$ Query Excel File
Hello Friends, Below is a snapshot of code I use to query any excel worksheet having tabular data. Do somebody have idea how to query excel file if i need distinct value from a particular column or I want to use some type of query like updated? *** Set Conn = New ADODB.Connection FFULLName = PI_FileName ConnStr = "Data Source=" & & FFULLName ConnStr = ConnStr & & ";Extended Properties=""Excel 8.0;HDR=NO;""" With Conn .Provider = "Microsoft.Jet.OLEDB.4.0;" .ConnectionString = ConnStr .Open End With Set RST = New ADODB.Recordset strQuery = "SELECT * FROM [RECEIVE$];" RST.Open strQuery, Conn, adOpenDynamic, adLockOptimistic *** Do somebody have idea how to query excel file if i need distinct value from a particular column. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 -- -- 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=wall&ref=ts
$$Excel-Macros$$ Critical Doubt
Hi! I am Having one query i hope i can free at the end of the session. Please help me we are educational industry maintaining student attendance i am expecting report like this. now a days we are maintaining student attendance in excel 2007 when ever students comming in they are placed "X" mark end of the result cell will disply how many days "X" and how many day they are "A" now i am looking students those comming "X" >3 days Continuously result cell should disply "REGULAR STUDENT" IF THE "A" BEYONDS <3+ Days Continuously the result cell should disply "IRREGULAR STUDENT" for your clarification student John from 1st - 4 attended classes regulary the result cell should disply "Regular Student" from 5,6,7 he is on leave now it self the result cell should be in "Regular student" when he falls leave from 8th that is more than 3days the result cell should Automatically disply "irregular student" .I hope you got my point. so, Those who is on leave more than 3 days we have to follow the student status. for that i am breaking my head for last some months pls help me in this regard regards -- -- 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=wall&ref=ts
Fwd: $$Excel-Macros$$ Values Against Max Values
Dear VJ, Please see attachment. Thanks, Noorain Ansari -- Forwarded message -- From: Vj Realsaggi Date: Tue, Dec 21, 2010 at 9:27 PM Subject: $$Excel-Macros$$ Values Against Max Values To: excel-macros@googlegroups.com Kindly Consider the Previous Mail -- -- 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=wall&ref=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=wall&ref=ts Book1(Solved).xls Description: MS-Excel spreadsheet