Re: $$Excel-Macros$$ Re: How to remove space in excel cell
Hi Prabhu, see if the enclosed file helps Regards Umesh On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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/discussexcel -- -- 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/discussexcel Space removed.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Automation of formula
Hi, What's the code you want to pass and to which cell. mention that also Regards Umesh Dev On Mon, May 23, 2011 at 11:32 PM, Skanda skanda.pokkun...@gmail.com wrote: The column difference highlighted in green is calculated as the difference between the two cells to its left.Then %difference is the percentage in their difference and abs difference is their absolute difference. How to code such that if i pass the formula these three fields are calculated for rest of the columns. attached is the worksheet. -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Need mis in excel vba format must in search engine
Hi Kannan, To create a report in this format is not advisable. The data have to be in contiguous, there should not be merged cell in between them. Maintain listing productivity and broker productivity separately. if you maintain it this way the data can be pulled in a numbers of ways in seconds. Regards Umesh Dev On Sat, May 21, 2011 at 5:35 PM, kannan excel kannan.ex...@gmail.comwrote: If i put my executive name, his weekly and monthly perfomance will come automatically On Sat, May 21, 2011 at 5:31 PM, kannan excel kannan.ex...@gmail.comwrote: Hi rajan, i am maintain our office Productivity tracker. my boss asked our executive weekly and monthly perfomance sheet. now i want, if i put my executive name, his details all will come automatically. include also formulas, macros, vba any thing... tomorrow sunday i want to submit my productivity tracker. i attached my company productivity excel. i don't know how i manage this problem. pls help me. urgent. give my excel sheet perfectly. today or tomorrow morning before 12pm. Kannan V 9941077703 On Sat, May 21, 2011 at 5:00 PM, rajan verma rajanverma1...@gmail.comwrote: we cant understand your problem Please Explain More.. On Sat, May 21, 2011 at 3:28 PM, kannan excel kannan.ex...@gmail.comwrote: Pls me ya. I want excel Vb coding format in Mis executive's - weekly and monthly Productivity. Broker's- weekly and monthly productivity. Broker's given listing for - weekly and monthly productivity and our company weekly and monthly producivity. need searching option in vb coding excel. like macro. I don't have any examble. but i attached my excel sheet. u just see and help me. (must in search engine) like if any executive name i type and click search button means his details ll appear immediatly. pls help urgent. thanks regards Kannan V 9941077703 onechennaiproperty.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 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/discussexcel -- Regards Rajan verma +91 9158998701 -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Formula required
Hi Vikram, Find the sheet enclosed Regards Umesh Dev On Mon, May 16, 2011 at 11:07 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding formula for validation: If we enter any numeric value in particular column it does not allow a duplicate entry and shows error message. For example;if we enter 1 to 5 numeric value in particular column and try to enter 1 again or any value between already entered value it shows error message and does allow user to enter any value. Regards, Vikram Download: www.eType.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 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/discussexcel -- -- 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/discussexcel Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent Formula Required Help me
Hi Puttu, explain it in excel sheet and also mention all the possibilities. Regards Umesh On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote: awaiting for your replay please. On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote: Experts please help me on this it's bit urgent sorry to bother. On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote: Hi Experts, I have list of items which have not full codes. I need them to convert full code. Could you please help me. Item code column has either 3, 2, 4 5 digits no. but by default they should be either 6 or 7 or 8 digits code. What best formul I need to use to get that output. Item Full Code output column has the correct answers which I manually entered. I want the same way answer using the formulas Item Full Code output Give the formula for output Item Code 200990 990 200991 991 300011 11 300014 14 300104 104 520901 20901 520902 20902 500450 450 500451 451 203529 3529 203538 3538 8515959 15959 8516271 16271 8203892 3892 8203893 3893 1620224 224 1620225 225 -- Putta -- -- 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/discussexcel -- Putta -- Putta -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income groups in the row range as other two groups don't match the filter criteria. I want the pivot table to keep all five groups and if a group doesn't match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs
Hi John, change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10),) Regards Umesh On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith johnasmit...@gmail.comwrote: I have like tabs from different departments and need to summarize an average score by day. But if there were no scores in a particular day, I get #DIV/0!. Please help with the formula that eliminates it. I tries an IFERROR in front of the AVERAGE but got a blank cell. Thank you. John -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ discussexcel.com Launched today
Hi Ayush, Congrats to you and the team. Regards Umesh On Mon, Mar 21, 2011 at 10:08 PM, neil johnson neil.jh...@googlemail.comwrote: Hi , Congratulation to you sir On 3/20/11, Ayush Jain jainayus...@gmail.com wrote: Dear Excel Group Members, I am very glad to share that* discussexcel.com http://www.discussexcel.com *website is launched today. The website development was initiated three months back and here is what I achieved. As promised with you, The site is launched on on the *4th Anniversary* of the group. [image: discussexcel_Logo.jpg] http://www.discussexcel.com The website is launched with some cool sections like *Excel Interview QA* and *Excel Blog of the month*. I am also planning to add a new section *Excel Expert Interview* soon. I hope you like them. I have selected the simplest tagline *Excel Simplified* as suggested by Balbir Kumar. The website content development is still in progress, I will keep sharing Excel tips and tricks through this portal over the time. Feel free to submit any content you want to be appear on website. *I really want to see this website as largest Excel Knowledge base.* * Finally , Thanks to all excel enthusiasts for keeping me motivated all the time. This is my personal achievement and I duly appreciate your support for the same.* Please go through this portal and provide your valuable feedback/suggestions/comments/inputs on the form located at 'Contact ushttp://www.discussexcel.com/contact-me' Page. Best regards, Ayush Jain Excel Group Owner Manager Microsoft Excel 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Please Help
Hi Sudhir, Check if its working. I have done it for only Running Balance. I am not clear with the Pending Amount the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code. Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar bluecore...@gmail.comwrote: Hi Running balance mean's outstanding of Parties on left side display date. Pending amount mean's pending bills upto outstanding. thanx On 19 March 2011 05:27, Umesh Dev umesh.d...@gmail.com wrote: Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar bluecore...@gmail.comwrote: Dear Experts, Please read my attachment and solve it. thanx Sudhir Verma Asstt. Mngr. A/c's 9818479722 -- -- 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/discussexcel -- -- 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/discussexcel -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ *Drink Bear Save Water* * * -- -- 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/discussexcel -- -- 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/discussexcel Day Book-1.xlsm Description: Binary data
Re: $$Excel-Macros$$ Please Help
Hi Sudhir, In the excel sheet which you have send me, for the party name b on 14th March you have mentioned 1700 as the pending amount. My question is How do you come to arrive at this figure? 1700 Regards Umesh On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar bluecore...@gmail.com wrote: Hi, Thanx and It's feel good to see done with macro. And how to copy it to my main workbook. Meaning of Pending Amount : It mean's payment which was not collected yet. Regards Sudhir On 21/03/2011, Umesh Dev umesh.d...@gmail.com wrote: Hi Sudhir, Check if its working. I have done it for only Running Balance. I am not clear with the Pending Amount the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code. Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15 PM, sudhir kumar bluecore...@gmail.com wrote: Hi Running balance mean's outstanding of Parties on left side display date. Pending amount mean's pending bills upto outstanding. thanx On 19 March 2011 05:27, Umesh Dev umesh.d...@gmail.com wrote: Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar bluecore...@gmail.comwrote: Dear Experts, Please read my attachment and solve it. thanx Sudhir Verma Asstt. Mngr. A/c's 9818479722 -- -- 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/discussexcel -- -- 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/discussexcel -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ *Drink Bear Save Water* * * -- -- 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/discussexcel -- -- 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/discussexcel -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ *Drink Bear
Re: $$Excel-Macros$$ combining averageif with time into one formula
Hi Susan, Assuming that the formula is right. To change the number to time format. Do it this way mentioned below:- Right Click the cell - Click on* format cells* * *- Select *Time* from *Category(Number) *- Choose the format you want. Regards Umesh Dev On Sat, Mar 19, 2011 at 2:23 AM, Susan 1 sunni...@gmail.com wrote: Hi, I am trying to change a number to a time format after excel averages out certain criteria. This is the average formula I am using: =AVERAGEIF($F$5:$F$17,=1,$G$5:$G$17) This is the Time Formula I'd like added to the average formula, so my number changes to a time style like 11:22 AM or 11:22 PM =TIME I tried adding =TIME to the end of the formula , didn't work. I've attached the spreadsheet Thanks! ~Susan -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Please Help
Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar bluecore...@gmail.comwrote: Dear Experts, Please read my attachment and solve it. thanx Sudhir Verma Asstt. Mngr. A/c's 9818479722 -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Looping-stopping to process when cell starts with a D
sample excel sheet would be easier to understand and solve Reg Umesh On Thu, Mar 17, 2011 at 11:20 PM, Preston Moore moor...@ldschurch.orgwrote: I am just starting to use VBA so I am a neophyte. I have data that shows units sold by product listed by store for over 40 stores. Each store has its own ID code and they all start with the letter D. When I encounter each new store I want to copy and past the units sold of each product to a pre-formatted spreadsheet. I think I want to do this by looping using the FOR EACH-NEXT construct. My question is: how do I write an instruction that says stop and evaluate the data (for copying pasting) each time a new store code is encountered? I think I need to write something to the effect that whenever a line starts with a D to stop and process? How would I go about doing this? Thanks. NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member
Congrats Ashish On Wed, Mar 2, 2011 at 5:36 PM, DILIPandey dilipan...@gmail.com wrote: Congrats Ashish...!! Best Regards, DILIPandey On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as *'Most Helpful Member'* for the month of Feb 2011. He has posted 97 posts (13% of total posts) in February 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition consistently from last three months.This is really amazing. Ashish, You are not only helping on excel queries but inspiring many people to support voluntarily. *Many Many Thanks Ashish for wonderful support to group. * *About Ashish Koul* Ashish resides in Delhi, India and currently working with CSC. He is automation expert and his role is to automate tasks using VBA Macros and Advanced Excel. His favorite pass time is solving Excel Queries, Listening Music Traveling. Regards Ayush Jain Group Manager -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq
There is no attachment On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso jcmat...@gmail.com wrote: Ww NOORAIN ANSARI noorain.ans...@gmail.com escreveu: Dear Experts.. Please find attached query sheet...I want to add a seperate row after every semicolon.. Please see attached sheet.. -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Shorting Problems
Hi Sudhir, Select the row A = Click on Data Tab = Click on Advanced = Select Unique Records Only. That's it. Regards Umesh On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ $$Excel and macros$$
Hi Mujeeb, attach an excel sheet with example. Reg Umesh On Mon, Feb 7, 2011 at 4:38 PM, Mujeeb mujeebrahman...@gmail.com wrote: Hi team, Could you pls help me in solving this excel formula. Eg; If A1 has some text for eg My name is Google In B1 if we type any text from A1, Eg name C1 should appear as TRUE. If we type text which is not in A1 Eg yahoo C1 should appear as FALSE. Note : A1 must be changeable and I don't in Macros. Best Regards Mujeeb rahman.K -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11
congrats Ashish Regards Umesh Dev On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote: Ashish Koul has been selected as *'Most Helpful Member'* for the month of Jan 2011. He has posted over 75 posts (11% of total posts) in January 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum. *Many Many Thanks Ashish for wonderful support to group.* *About Ashish Koul* Ashish resides in Delhi, India and currently working with CSC. He is automation expert and his role is to automate tasks using VBA Macros and Advanced Excel. His favorite pass time is solving Excel Queries, Listening Music Traveling. Best Regards, Ayush Jain Group Manager. -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$Help with macros automatic formulas.
Hi Hector, Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you have mentioned is esblanco Regards Umesh Dev On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz hector.ru...@gmail.com wrote: Hi all, I made a macro to do a consultation with automatic cell ranges, with letters running but when the result is number does not work, I have to double click to run the Forumula. Attached my question. -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ How to extract data from an array
Hi, If you kindly put the data in excel it would be easy. Reg Umesh On Tue, Feb 1, 2011 at 12:22 AM, jmccaski jmccask...@gmail.com wrote: I have an arry of over 21,000 rows with data in this format: VarName TimeString VarValue Pos 27.01.2011 12:49:35 32 Pres27.01.2011 12:49:35 -2 Setpt 27.01.2011 12:49:35 100 Gain27.01.2011 12:49:35 1 Int 27.01.2011 12:49:35 10 Pos 27.01.2011 12:49:36 32 Pres27.01.2011 12:49:36 -2 Setpt 27.01.2011 12:49:36 100 Pos 27.01.2011 12:49:37 32 Pres27.01.2011 12:49:37 9 Setpt 27.01.2011 12:49:37 100 Pos 27.01.2011 12:49:38 32 Pres27.01.2011 12:49:38 9 Setpt 27.01.2011 12:49:38 100 Pos 27.01.2011 12:49:39 32 Pres27.01.2011 12:49:39 24 Setpt 27.01.2011 12:49:39 100 Pos 27.01.2011 12:49:40 32 Pres27.01.2011 12:49:40 24 Setpt 27.01.2011 12:49:40 100 Gain27.01.2011 12:49:40 1 Int 27.01.2011 12:49:40 10 I'm trying to get it into a format something like this in order to chart it: TimeString Pos Press Setpt GainInt 27.01.2011 12:49:35 32 -2 100 1 10 27.01.2011 12:49:36 32 -2 100 27.01.2011 12:49:37 32 9 100 27.01.2011 12:49:38 32 9 100 27.01.2011 12:49:39 32 24 100 27.01.2011 12:49:40 32 24 100 1 10 Any help would be greatly appreciated. -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Problem in excel
Hi jitender, Find the enclsd sheet if it could help. Regards Umesh On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar jk9779771...@gmail.comwrote: Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender -- -- 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/discussexcel -- -- 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/discussexcel Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ removing multiple data and converting column into row
Hi I hope the enclsd sheet will help you. Regards Umesh Dev On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Vikalp, Please refer the attached excel for solution. I have automated everything in formula and you need not to do any manual input in Solution Sheet. Just you need to Copy and paste the formula to the rest of the rows based on your requirement. In Data Sheet you have to extend the formula used as Helper Column1 and Helper Column2 (Column F Column G) based on the Unique ID No data of Column B. I hope its Clear to you! --- Ms.Exl.Learner --- On Fri, Jan 28, 2011 at 1:31 PM, vikalp dostvik...@gmail.com wrote: hellow everybody, kindly help me with the problem i am facing i want to remove repititive record from folloeing data and get useful data for the perpose of mailmerge example is given bellow example data I have a b c d 1 x 20 35 1 x 25 35 1 x 26 145 1 x 35 2568 2 y 24 85 2 y 25 7431 2 y 620 556 3 z 25 451 3 z 25 451 data format I require a d c1 d1 c2 d2 c3 d3 c4 d4 1 x 20 35 25 35 26 145 35 2568 2 y 24 85 25 7431620 556 3 z 25 451 25 451 knly help me please -- -- 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/discussexcel -- -- -- 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/discussexcel -- -- 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/discussexcel Solution-1.xlsm Description: Binary data
Re: $$Excel-Macros$$ Please help
Hi sudhir, Click *Conditional formatting* tab -Select *New Rule* - Select *Format only cells that contain* - click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Experts please hep me for a formula which worked on color. please see attachment. -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * -- -- 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/discussexcel -- -- 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/discussexcel
Re: FW: $$Excel-Macros$$ Help Required_pdf file conversion
Hi Vikram, Its working in my sys. if its not working on your sys then let me know where the file is saved and also where your acro-reader is saved. Regards Umesh Dev On Sat, Jan 29, 2011 at 12:50 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding below query as I need this on urgent basis to complete the report. Regards, Vikram Ahuja *From:* vikram [mailto:vikramahuj...@gmail.com] *Sent:* Thursday, January 27, 2011 10:49 PM *To:* 'excel-macros@googlegroups.com' *Subject:* $$Excel-Macros$$ Help Required_pdf file conversion Hi Umesh, Please find enclosed macro enabled sheet for converting pdf data to excel data but I am still getting error message as mentioned below. I have done below steps for running this macro: 1) Saved Pdf data on “D:\VIKRAM FILES\process data\asl” and changed this path on macro coding as well. 2) Saved macro coding and run this macro for execution but still getting error message as “error message 400”. Kindly help in this regard to get this data converted in excel format. For your reference please find enclosed pdf data which needs to be converted. Regards, Vikram Ahuja *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Thursday, January 27, 2011 12:58 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I clearly did not understand your query, however I have rectified the code. Regards Umesh Dev On Wed, Jan 26, 2011 at 9:32 PM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, Thanks a lot for your help. I need one more help regarding below macro for converting PDF files to excel .Below macro coding is showing error while running this macro as I have to convert around 100 pdf files to excel and for your reference I have enclosed one of the PDF file. Kindly help in this regard. Sub BackToA1() Range(A1).Select End Sub Sub GetPDFnow() Dim varRetVal As Variant, strFullyPathedFileName As String, strDoIt As String 'Add a new worksheet Sheets.Add After:=Sheets(Sheets.Count) 'Name it ActiveSheet.Name = Input01 'Back to A1 Range(A1).Activate 'HERE YOU DEFINE THE FULLY PATHED PDF FILE strFullyPathedFileName = C:\Documents and Settings\ayujain1\Desktop\Excel_Tutorials\Ayush ebooks\14 secret shortcuts of Excel.pdf 'HERE YOU SET UP THE SHELL COMMAND strDoIt = C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe strFullyPathedFileName 'The Shell command varRetVal = Shell(strDoIt, 1) 'Clear CutCopyMode Application.CutCopyMode = False AppActivate varRetVal 'Wait some time Application.Wait Now + TimeValue(00:00:03) ' wait 3 seconds DoEvents 'IN ACROBAT : 'SELECT ALL SendKeys ^a 'COPY SendKeys ^c 'EXIT (Close Exit) SendKeys ^q 'Wait some time Application.Wait Now + TimeValue(00:00:03) ' wait 3 seconds DoEvents 'Paste ActiveSheet.Paste 'Go back to cell A1 Call BackToA1 End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Tuesday, January 25, 2011 10:10 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Sunday, January 23, 2011 7:43 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram vikramahuj...@gmail.com wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: *Code* *Category* 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any
Re: $$Excel-Macros$$ Please help to get result through Formule
Hi CS, If you want to color the band. You can Conditional Formatting to get the result. Regards Umesh On Thu, Jan 27, 2011 at 3:04 PM, Born to Win cs4...@gmail.com wrote: Hello Expert, In Attached Sheet i am making a tracker For Attrition In first summary sheet i have to show Band with Colour corresponding to his Last Dated Status. Please help me to get that Result on Summary sheet through formula . Thanks, CS -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Help Required
Hi Vikram, I clearly did not understand your query, however I have rectified the code. Regards Umesh Dev On Wed, Jan 26, 2011 at 9:32 PM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, Thanks a lot for your help. I need one more help regarding below macro for converting PDF files to excel .Below macro coding is showing error while running this macro as I have to convert around 100 pdf files to excel and for your reference I have enclosed one of the PDF file. Kindly help in this regard. Sub BackToA1() Range(A1).Select End Sub Sub GetPDFnow() Dim varRetVal As Variant, strFullyPathedFileName As String, strDoIt As String 'Add a new worksheet Sheets.Add After:=Sheets(Sheets.Count) 'Name it ActiveSheet.Name = Input01 'Back to A1 Range(A1).Activate 'HERE YOU DEFINE THE FULLY PATHED PDF FILE strFullyPathedFileName = C:\Documents and Settings\ayujain1\Desktop\Excel_Tutorials\Ayush ebooks\14 secret shortcuts of Excel.pdf 'HERE YOU SET UP THE SHELL COMMAND strDoIt = C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe strFullyPathedFileName 'The Shell command varRetVal = Shell(strDoIt, 1) 'Clear CutCopyMode Application.CutCopyMode = False AppActivate varRetVal 'Wait some time Application.Wait Now + TimeValue(00:00:03) ' wait 3 seconds DoEvents 'IN ACROBAT : 'SELECT ALL SendKeys ^a 'COPY SendKeys ^c 'EXIT (Close Exit) SendKeys ^q 'Wait some time Application.Wait Now + TimeValue(00:00:03) ' wait 3 seconds DoEvents 'Paste ActiveSheet.Paste 'Go back to cell A1 Call BackToA1 End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Tuesday, January 25, 2011 10:10 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Sunday, January 23, 2011 7:43 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram vikramahuj...@gmail.com wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: *Code* *Category* 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- -- 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/discussexcel -- -- 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
Re: $$Excel-Macros$$ Help Required
Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram vikramahuj...@gmail.com wrote: Hi Umesh, I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Umesh Dev *Sent:* Sunday, January 23, 2011 7:43 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram vikramahuj...@gmail.com wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: *Code* *Category* 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Re: Excel Help
Hi David, let me know the fields and how would you want it to be created. Umesh On Mon, Jan 24, 2011 at 12:32 AM, DavidG goldstone.da...@googlemail.comwrote: how do i add a file? On Jan 21, 8:57 pm, DavidG goldstone.da...@googlemail.com wrote: Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any ideas or help will be greatly appreciated. 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Unique records
Hi Ashish Thank you ... You made it very simple. I was finding it difficult to loop. Thanks Omar for the input. Thanks and Regards Umesh Dev On Sat, Jan 15, 2011 at 9:53 PM, ashish koul koul.ash...@gmail.com wrote: check the attachement see if it helps On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi All, Can anyone help me with the code in *VBA *to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- 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/discussexcel -- *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/discussexcel -- -- 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/discussexcel
$$Excel-Macros$$ Unique records
Hi All, Can anyone help me with the code in *VBA *to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- 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/discussexcel
Re: $$Excel-Macros$$ How To Find Duplicate Records in Ms Excel
Hi Pankaj, Go to advanced filters and select Unique records Regards Umesh On Fri, Aug 27, 2010 at 11:21 AM, rajput rajputpanka...@gmail.com wrote: I have a lot of Data including number Alphabet , I am confussed that duplicate will be entered,,,which command i find duplicate records -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as sheet name
Hi Ramesh, Try using the code below:- This code would rename the sheets with the name in range(A1) Sub newsheetname() Dim i As Integer, Newname As String For i = 1 To ThisWorkbook.Worksheets.Count Newname = ThisWorkbook.Worksheets(i).Range(A1).Value ThisWorkbook.Worksheets(i).Name = Newname _ ThisWorkbook.Worksheets(i).Index Next i End Sub Umesh Dev On Tue, Nov 3, 2009 at 6:56 PM, Chanti ramesh1...@gmail.com wrote: Hi Team, Is there a way we can segregate the data depending upon the name (column A) to different tabs. Example If it is a macro, and if I run it, the result would be: Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab would contain the data as per the sheet name. I hope this is a confusing request, please let me know if you have any questions. Thanks in advance Ramesh -- Thanks!!! --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Name Matching In Excel
Hi Dilip, Can you explain the logic pls. Regards Umesh On Tue, Oct 13, 2009 at 8:39 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Michael, The enhancement is done in the attached file as per your requirements. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Oct 13, 2009 at 7:00 PM, Drayton, Michael E michael.e.dray...@citi.com wrote: Dilip, You are king! Is there a way we can make Column F reflect the value from Sheet 1 if E4 = mapped instead of reflecting what's on Sheet 2? Here is my logic. When using this formula in action, I won't be able to check what the formula matches on Sheet 1 because Sheet 1 may have 5,000 names. By adding this extra step, I can validate that the match reflects what I believe is a correct match. I hope I didn't confuse you more. Highest Regards, Michael Drayton -- *From:* Dilip Pandey [mailto:dilipan...@gmail.com] *Sent:* 13 October 2009 06:12 *To:* Drayton, Michael E [ICG-GTS] *Cc:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Name Matching In Excel Hi Michael, Actually, if the name of sheet 2 is matching in the list in Sheet 1, then I am saying as Found. Further to this, I have fetched those names which are matched considering full name and only the first name. Please look at the attached file for further understanding. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/9/09, MD18358 michael.e.dray...@citi.com wrote: Hi Dilip, Is there a way to make the formula kick back the actual matched name? Even better, I liked the found/not found column so on the next column over can I get the actual matched name? Thanks for your contribution. You are great!!! regards, Michael On Sep 22, 6:18 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Sonal, The query attached by you has been solved per your expectations and attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/21/09, Sonal Gadgil gadgil.so...@gmail.com wrote: Hi... I am new in this group. I am facing one proble while working in the excel. I am having two excel files where i have to map the customer based on customer name by matching customer name manually. Now, in case there is any macro available which help me to search map names this will be great help to me other users Example: Name Maching - By DILipandey.xls 19KViewDownload- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Pdf Password
Hi All, Can some body help me in cracking a PDF password. I have down loaded a PDF file which is zipped and has a password. I have also downloaded a password cracker also, but I am unable to unzip the file. The password cracker can crack the password only in the PDF file. Please Help Me Regards Umesh Dev --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Difference of Modules
Thank You Paul Regards Umesh Dev On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote: A Class is a way of defining a new object and attributes. let's say you wanted to create an object called People. Now, for each person in People you wanted to save the Name Address City Postal_Code Phone_Home Phone_Work Phone_Cell Birthday Start_Date You would define this Class in a Class Module. Then, in a Regular module, you could create a new variable like: Dim Employee as People then, the Employee variable automatically has the properties: Employee.Name Employee.Address Employee.City Employee.Postal_Code Employee.Phone_Home Employee.Phone_Work Employee.Phone_Cell Employee.Birthday Employee.Start_Date Of course, it's EMPTY until your macro fills it. to find examples (and a better explanation!) Just Google VBA Class Module. You'll find HUNDREDS of good articles! Paul -- *From:* Umesh Dev umesh.d...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, October 1, 2009 6:56:08 AM *Subject:* $$Excel-Macros$$ Difference of Modules Hi All, Can anyone tell the difference between a Module and a Class Module. What are the advantages in writing a code in either Module/Class Module. Regards Umesh Dev --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---