$$Excel-Macros$$ query about translate
hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com samle.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
fyi regards jitendra singh 9015340017 On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1 (1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ query about translate
Dear Anil, Attached file format is same as you posted previous. All Fonts are in Hindi. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 1:40 PM, anil kumar kmr7a...@gmail.com wrote: hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table (URGENT)
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file and see the yellow highlighted row ,i have did the same w/o pivot On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi mahreen.acc...@gmail.com wrote: Guys I have a range of data of which I want to plot a pivot table. My problem is that I have different expiry days but I want to club or group into certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL APPROVING AUTHORITY TOTAL FUNDED NON-FUNDED LIMIT (IN MILLION) DATE OF INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH I KHI CORPORATEABC 07-Oct-2010 CC 50.000 31-Mar-2012 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 30-Apr-2012 30-Apr-2012(120) 9 SOUTH I KHI CORPORATE DSF 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012 (120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 30-Apr-2012(120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 1,300.000 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 300.000 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012 (365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012(120) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or
RE: $$Excel-Macros$$ regarding rounding off
Its logical. =IF(VALUE(RIGHT(INT(A2),1))0,INT(A2)+(10-VALUE(RIGHT(INT(A2),1))),INT(A2)) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Jan/Wed/2012 04:58 To: Paul Schreiner; excel-macros@googlegroups.com Subject: $$Excel-Macros$$ regarding rounding off Subject: reply regardingrounding off Kind Attention: Paul Schreiner thank you for your reply and sorry for my late response as I am out of town. What I required is: if a result comes to 20.60 or 20.10 (here whatever be the fraction) it should be rounded off to 20 only if a result comes to 21 or 21.10 or 21.60 it should be rounded off to 30 regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table (URGENT)
You are welcome On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote: Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file and see the yellow highlighted row ,i have did the same w/o pivot On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi mahreen.acc...@gmail.com wrote: Guys I have a range of data of which I want to plot a pivot table. My problem is that I have different expiry days but I want to club or group into certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL APPROVING AUTHORITY TOTAL FUNDED NON-FUNDED LIMIT (IN MILLION) DATE OF INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH I KHI CORPORATEABC 07-Oct-2010 CC 50.000 31-Mar-2012 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 30-Apr-2012 30-Apr-2012(120) 9 SOUTH I KHI CORPORATE DSF 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012(120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 30-Apr-2012(120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 1,300.000 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 300.000 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012(365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012(120) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Dear Sunita Kindly find the attached file Hope this is as per your req 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1 (2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Thank you very much for the prompt action. It works as per my requirement. Have a wonderful day! On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly find the attached file Hope this is as per your req 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
RE: $$Excel-Macros$$ Macro for inserting columns and fill with strings
Try this One: Sub MyTest() Dim wksSheet As Worksheet Set wksSheet = ThisWorkbook.Worksheets(Sheet1) Application.screenUpdating=False With wksSheet .Range(D2).Formula = =LEFT(A2,FIND(U,A2,1)) .Range(E2).Formula = =RIGHT(A2,LEN(A2)-LEN(D2)) .Range(F2).Formula = =b2 .Range(G2).Formula = =LEFT(C2,3) .Range(h2).Formula = =MID(C2,5,4) .Range(i2).Formula = =MID(C2,10,2) .Range(i2).Formula = =MID(C2,13,2) .Range(D2:I .UsedRange.Rows.Count).FillDown .Range(D2:I .UsedRange.Rows.Count).Value = .Range(D2:I .UsedRange.Rows.Count).Value End With Application.screenUpdating=True End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Jan/Thu/2012 06:24 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for inserting columns and fill with strings Using TTC See attached Sub ParseColumnsSAS() Application.ScreenUpdating = False Columns(d:j).Delete Application.DisplayAlerts = False Columns(A).TextToColumns Destination:=Range(D1), DataType:=xlFixedWidth, _ OtherChar:=, FieldInfo:=Array(Array(0, 1), Array(4, 1)), TrailingMinusNumbers:=True Columns(B).Copy Columns(F) Columns(c).TextToColumns Destination:=Range(G1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:=- Application.DisplayAlerts = True With Columns(d:j) .AutoFit .Interior.ColorIndex = 35 End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan mailto:darwin.chankaw...@gmail.com Sent: Tuesday, January 17, 2012 11:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro for inserting columns and fill with strings Dear group, I want to insert several columns and then split the information. The no. of entries is different everyday. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Vlookup Help
I just use indirect function to get reference from another sheets, well we can use this long formula also J Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Jan/Thu/2012 09:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Help Dear Rajan, Try this... =IF(C2=EQUITY SHARE,VLOOKUP(A2,'EQUITY SHARE'!$A$2:$B$17,2,FALSE),IF(C2=DEBENTURE,VLOOKUP(A2,DEBENTURE!$A$2:$B$4, 2,FALSE),IF(C2=MUTUAL FUND,VLOOKUP(A2,'MUTUAL FUND'!$A$2:$B$4,2,FALSE),0))) Regards Ashish Bhalara On Wed, Jan 18, 2012 at 7:58 PM, Rajan_Verma rajanverma1...@gmail.com wrote: See the attached sheet.. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas Sent: Jan/Mon/2012 09:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Help Dear Team, I am creating macro for Recon of prices where facing problem in multiple vlookup. Find attached Recon file. Please any one help me the multiple vlookup function/coding multiple vlookup. Thanking in Advance. Regards, Shrinivas -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Required Unique Words.
Dear Experts, I want to take unique words from A1 cell. please suggest -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Find.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Required Unique Words.
Dear Raghu, I hope your requirement is this one..* =(LEN(A1)-LEN(SUBSTITUTE(A1,gole,)))/LEN(B2)* See attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 3:23 PM, Raghav raghav.bhupen...@gmail.com wrote: Dear Experts, I want to take unique words from A1 cell. please suggest -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Copy of Find(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel - Array Help
Dear Sourabh, Please use this one to find unique value of more than one column without using helping column *=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) * See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
Re: $$Excel-Macros$$ query about translate
Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Required Unique Words.
Hi Noorain.. Its not static .. text can be change.. need a dynamic solution Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 03:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Unique Words. Dear Raghu, I hope your requirement is this one.. =(LEN(A1)-LEN(SUBSTITUTE(A1,gole,)))/LEN(B2) See attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 3:23 PM, Raghav raghav.bhupen...@gmail.com wrote: Dear Experts, I want to take unique words from A1 cell. please suggest -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ code
Try this : =REPLACE(REPLACE(A1,3,2,.),6,5,.) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Jan/Thu/2012 09:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ code I want to change this column A to column G (means I want to remove the additional zero figures from column A), I have to pass through the cols - B, C, D, E and F. steps involved here are very lengthy! How can I avoid this lengthy process and do it in short!! Finally I have to do again some manual work in the 'col G'. Plz, help me to come out from this problem. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ query about translate
Do you want to translate data or just want to change format ?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 04:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Required Unique Words.
Try this VBA Function : Paste it in a VBA module and use Function ExtractUnique(rng As Range) As String Set rng = Range(a1) Dim objDic As Object Set objDic = CreateObject(Scripting.Dictionary) For i = 1 To Len(rng.Value) If Not objDic.Exists(Mid(rng.Value, i, 1)) Then objDic.Add Mid(rng.Value, i, 1), Mid(rng.Value, i, 1) ExtractUnique = ExtractUnique Mid(rng.Value, i, 1) End If Next Set objDic = Nothing End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 03:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Unique Words. Dear Raghu, I hope your requirement is this one.. =(LEN(A1)-LEN(SUBSTITUTE(A1,gole,)))/LEN(B2) See attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 3:23 PM, Raghav raghav.bhupen...@gmail.com wrote: Dear Experts, I want to take unique words from A1 cell. please suggest -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Copy data from excelsheet to html file
HI Do you want to convert you data in xml? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sushil Kumar Sent: Jan/Thu/2012 02:00 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy data from excelsheet to html file Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ FW: Hidden file
Dear Neeraj, Once again try through.. Control Panel-Folder Options then view. It may be help to you. On Fri, Jan 20, 2012 at 1:27 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear All, ** ** Kindly see the snap carefulle hiddin opetion is hidden. Why it not showing and I can’t click on it ** ** ** ** [image: Sign] ** ** *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] *Sent:* Friday, January 20, 2012 12:51 PM *To:* 'excel-macros@googlegroups.com' *Subject:* FW: Hidden file ** ** Dear all File is also attached kindly see. ** ** ** ** [image: Sign] ** ** *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] *Sent:* Friday, January 20, 2012 12:29 PM *To:* 'excel-macros@googlegroups.com' *Subject:* Hidden file ** ** Dear sir, ** ** Kindly see the attached screen shot. The file is hidden. I want to unhide the file. ** ** ** ** [image: Sign] ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.jpg
RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding
Try this one: Sub isExist() On Error Resume Next If WorksheetFunction.Match(Range(rngValues).Value, Range(List), 0) Then If Err.Number = 1004 Then Err.clear On error goto 0:on Error Goto -1 MsgBox Values not found Else MsgBox Range(rngValues).Value End If End If End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Jan/Thu/2012 12:30 To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. If match(Worksheets(Account Statement).Range(E6).Value, Worksheets(Account Status).Range(K:K), 0) 0 Then MsgBox Bill is made of this Chassis End If Kindly solve my query that I use macro in .xlsx format, so what is the difference to use macro in macro-enable workbook format and simple .xlsx format? Thanks Regards Ashish Bhalara 9624111822 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ EXCEL - TIPS
thanx noor From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 11:20 AM Subject: Re: $$Excel-Macros$$ EXCEL - TIPS Dear Kishore, You can study attached Ebook step by step.. It will help you to learn excel. - Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 8:24 PM, Sweet Kishore kishore...@gmail.com wrote: Dear Friends, i got reply from your end thank your very much. Please explain how do .because i dont know knowledge in Excel. Kindly explain from basic onwards. Regards, kishore On Thu, Jan 19, 2012 at 11:00 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kishor, Please find attachment as per your requirement.. and follow Excel-Macro group on regular basis. - On Wed, Jan 18, 2012 at 7:09 PM, kishore kishore...@gmail.com wrote: Dear Sir/Madam, Kindly i am very much interest to learn excel. Kindly provide the basic and also some important functionslike HLOOKUP,VLOOKUP, MACROS. Thanking you, Regards, kishore -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ query about translate
I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Need looping in VB script
Try this: Sub LoopingAllFileInAFolder() Dim strPath As String Dim fso As Scripting.FileSystemObject Dim fldFolder As Folder Dim flFile As File Set fso = New Scripting.FileSystemObject With Application .FileDialog(msoFileDialogFolderPicker).Show strPath = .FileDialog(msoFileDialogFolderPicker).SelectedItems(1) End With Set fldFolder = fso.GetFolder(strPath) For Each flFile In fldFolder.Files 'you can get file path by flFile.path and can code with file here Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of yogananda muthaiah Sent: Jan/Fri/2012 10:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need looping in VB script Hi, i have 2 excels in desktop which needs to be looped. As explained below , not working properly. Regards Yogananda Muthaiah On Thu, Jan 19, 2012 at 9:32 PM, dguillett1 dguille...@gmail.com wrote: Put inside a loop? for I = 1 to 10 'howmany_? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA I .xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA I .xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit next i Don Guillett SalesAid Software dguille...@gmail.com From: yogananda muthaiah mailto:yogananda.mutha...@gmail.com Sent: Thursday, January 19, 2012 9:51 AM To: excel-macros@googlegroups.com ; samde...@gmail.com Subject: Re: $$Excel-Macros$$ Need looping in VB script Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah On Sat, Jan 14, 2012 at 11:07 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: $uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or
Re: $$Excel-Macros$$ query about translate
Dear Noorain Anil want to do like under written Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 2:13 PM Subject: Re: $$Excel-Macros$$ query about translate Dear Anil, Attached file format is same as you posted previous. All Fonts are in Hindi. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 1:40 PM, anil kumar kmr7a...@gmail.com wrote: hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Save As today date
Dear Darwin, It is working fine on my system, we can use below code in this format for dynamic path.. Sub savemethod() Dim todaydate As String Dim fileSaveName As String Path = VBA.InputBox(Enter Path) todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=Path todaydate .xls End Sub Please suggest On Fri, Jan 20, 2012 at 9:57 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=C:\Documents and Settings\noorain.ansari\Desktop\ todaydate .xls End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto saving as today date beside this one? **Code** ** Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = DateSerial(Year(Date), Month(Date), Day(Date)) fileSaveName = Application.GetSaveAsFilename(initialfilename:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=todaydate End Sub ** -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ query about translate
I think no way in excel without use of any other software Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 06:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
use http://translate.google.co.in/ On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think no way in excel without use of any other software ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *anil kumar *Sent:* Jan/Fri/2012 06:12 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ query about translate ** ** I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ FW: Hidden file
go to run type cmd @command prompt type attrib -r -s -h -a filename -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ RE: Array Help
many -2 thanks to all of u -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Copy data from excelsheet to html file
Hi Rajan, I Don't want to convert the file; however i just want to input the data from the sheet into the specific web site. here at my office some of my team members work is to enter some data which is in excelsheet on the web site. Thank you in advance. Sushil. On Fri, Jan 20, 2012 at 5:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Do you want to convert you data in xml? ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sushil Kumar *Sent:* Jan/Thu/2012 02:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Copy data from excelsheet to html file ** ** Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Copy data from excelsheet to html file
Hi It can be through excel.. which is that web site and how much data you have to enter In online Form..?? Regards Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sushil Kumar Sent: Jan/Fri/2012 07:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy data from excelsheet to html file Hi Rajan, I Don't want to convert the file; however i just want to input the data from the sheet into the specific web site. here at my office some of my team members work is to enter some data which is in excelsheet on the web site. Thank you in advance. Sushil. On Fri, Jan 20, 2012 at 5:35 PM, Rajan_Verma rajanverma1...@gmail.com wrote: HI Do you want to convert you data in xml? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sushil Kumar Sent: Jan/Thu/2012 02:00 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy data from excelsheet to html file Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any
$$Excel-Macros$$ Need to Change Date Format
Dear All, I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM format (1/20/2012 7:00:00 AM) Please give me formula. regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need to Change Date Format
Dear Imran, Please use =TEXT(A1,mm/dd/yy hh:mm:ss AM/PM) On Fri, Jan 20, 2012 at 10:10 PM, Imran khan ikha...@gmail.com wrote: Dear All, I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM format (1/20/2012 7:00:00 AM) Please give me formula. regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Copy data from excelsheet to html file
Hi Rajan, We have one 5 to 6 fields like name, number, address and zip code etc... and we have to add that data on client web site. can you please suggest the VBA codes so that i can apply this on our excel sheet and modify as per the requirement. due to client web site (process application) i cannt give you the web address for that site. Thank you for your help! Sushil On Fri, Jan 20, 2012 at 10:03 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi* *It can be through excel.. which is that web site and how much data you have to enter In online Form..??* *Regards* *Rajan.* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sushil Kumar *Sent:* Jan/Fri/2012 07:50 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Copy data from excelsheet to html file ** ** Hi Rajan, I Don't want to convert the file; however i just want to input the data from the sheet into the specific web site. here at my office some of my team members work is to enter some data which is in excelsheet on the web site. Thank you in advance. Sushil. On Fri, Jan 20, 2012 at 5:35 PM, Rajan_Verma rajanverma1...@gmail.com wrote: HI Do you want to convert you data in xml? Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sushil Kumar *Sent:* Jan/Thu/2012 02:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Copy data from excelsheet to html file Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post
Re: $$Excel-Macros$$ Hidden file
this are the temp files..not possible to UNHIDE but try to use *attrib -s -h -r* in cmd use:- press window+r button for run then type cmd and then type atrib -s -h -r then enter On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear sir, ** ** Kindly see the attached screen shot. The file is hidden. I want to unhide the file. ** ** ** ** [image: Sign] ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.jpg
$$Excel-Macros$$ CHANGE DATE FORMAT
Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ CHANGE DATE FORMAT
Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ CHANGE DATE FORMAT
or try this one.. for any format =TEXT(B2,-00-00)+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote: Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ CHANGE DATE FORMAT
try this =TEXT(TEXT(B3,-00-00),DD-MM-) chandru On Sat, Jan 21, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote: or try this one.. for any format =TEXT(B2,-00-00)+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote: Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Proportionate calculation
Dear Experts I am attaching an excel form, in which according to the promotion date text box the proportionate pay text box has to show in the command button event the pay of that particular month according to the days calculation. eg. if the pay is 1000/- pm (consider every calendar month should have 30 days only) suppose if the date of promotion is on 01-09-2011, the proportionate pay will remain 1000/- else if the date of promotion is on 02-09-2011 or 03-09-2011 so on... the remaining days of that particular month should be calculated and shown in that text box. Here if the Date of promotion is on 02-09-2011 remaining days will be 30-1 = 29 (1000/30) * 29 = 966.7 regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com pay.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Excel - Array Help
Dear All, Can someone please explain how the below formula will work I mean what logic it will follow. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 20 January 2012 16:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.commailto:rhtdmja...@gmail.com wrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.commailto:rhtdmja...@gmail.com wrote: dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name =SUM(1/COUNTIF(B2:B6,B2:B6)) press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. =IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.commailto:kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202tel:%2B91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook.
Re: $$Excel-Macros$$ CHANGE DATE FORMAT
Thanks a lot for formula, could you please explain the means of +0 in the end of formula? Thanks from Ashish. On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran duraichan...@gmail.comwrote: try this =TEXT(TEXT(B3,-00-00),DD-MM-) chandru On Sat, Jan 21, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote: or try this one.. for any format =TEXT(B2,-00-00)+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote: Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Fwd: $$Excel-Macros$$ CHANGE DATE FORMAT
for convert to number format ... u also use ''--'' befor formula like =--TEXT(B2,-00-00) On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Thanks a lot for formula, could you please explain the means of +0 in the end of formula? Thanks from Ashish. On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran duraichan...@gmail.comwrote: try this =TEXT(TEXT(B3,-00-00),DD-MM-) chandru On Sat, Jan 21, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote: or try this one.. for any format =TEXT(B2,-00-00)+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote: Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace - or / character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date generate from DOS base software and its open in proper format in Excel-2010, I use Excel-2007 in which this type of date is not display in date format. Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use
