$$Excel-Macros$$ Rounding method
Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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$$ Rounding method
Hi, Assume that your input data is A2 cell and apply the below formula in B2 cell. =A2-MOD(A2,5) Refer the attachment for details. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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 (925+ 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 Rounding to related Value Solution.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Consolidate data in different work sheets
Hi, I want to know how we can consolidate data in different worksheets into one worksheet. Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com -- FORUM RULES (925+ 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$$ Rounding Method
Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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$$ To reduce Excel file size drastically save as [.xlsb] format
Hi Team, I'm not sure whether this tip has been shared already. To reduce Excel file size drastically, save as in .xlsb format which uses binary features and you can do all the operations as we do in normal excel file. Please let me know what is the difference between these two formats. Your comments are highly appreciated. Regards, Mathan -- Regards, Mathan -- FORUM RULES (925+ 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$$ Plus Sign in a Column
Dear all I have a small problem in MS Excel in a particular column I want to enter only + sign if I press = sign also it should come to + sign only anybody can assist me please Regards V.Kiran Kumar -- FORUM RULES (925+ 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$$ Consolidate data in different work sheets
Sub method2() Dim i, j, k, s As Long s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) For i = 1 To s Sheets(i).Select j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Next i End Sub On Wed, Nov 9, 2011 at 10:08 AM, smitha.kumari smitha.kum...@speridian.comwrote: Hi, ** ** I want to know how we can consolidate data in different worksheets into one worksheet. ** ** Regards Smitha/ Senior Finance Executive [image: Speridian%20Logo] World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com ** ** -- FORUM RULES (925+ 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (925+ 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$$ Rounding Method
Hi Sajid, Refer the reply given to another post for the same subject. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote: Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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 (925+ 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$$ Consolidate data in different work sheets
Thanks for your reply. Any way to consolidate data other than using macros. I don't know how to apply the code which you mentioned in your mail Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, November 09, 2011 2:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Consolidate data in different work sheets Sub method2() Dim i, j, k, s As Long s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) For i = 1 To s Sheets(i).Select j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Next i End Sub On Wed, Nov 9, 2011 at 10:08 AM, smitha.kumari smitha.kum...@speridian.com wrote: Hi, I want to know how we can consolidate data in different worksheets into one worksheet. Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com -- FORUM RULES (925+ 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 -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (925+ 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 (925+ 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$$ Rounding Method
use this command =floor(a1,5) Mothilal.J[image: image.png] On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote: Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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 -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- FORUM RULES (925+ 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 image.png
Re: $$Excel-Macros$$ help: excel changes macro assignment
You need to post your file or a least your code How does a jew workbook differ from a gentile workbook? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Clinton James Sent: Tuesday, November 08, 2011 7:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ help: excel changes macro assignment Hi alli am looking for help with an issue that is bugging me no end. I have assigned a macro to a button which works well until i double click on a cell which launches a macro to mine data and then use this to get information out of a pivot ...this data is then dumped onto a Jew workbook. This is fine except for the macro assigned to the button then changes...the name is the same but somehow it references this new workbook Aaron the location for the macro. Why would excel change the expected location of an assigned macro at all and how would i stop excel misbehavior? Thanks in advance. -- FORUM RULES (925+ 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 (925+ 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$$ Plus Sign in a Column
if, as you say, you ONLY want + in the column then right click sheet tabview codeinsert this. change column to suit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Or Target.Column 4 Then Exit Sub If Target + Then Target = + End Sub Don Guillett SalesAid Software dguille...@gmail.com From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ Sent: Wednesday, November 09, 2011 2:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plus Sign in a Column Dear all I have a small problem in MS Excel in a particular column I want to enter only + sign if I press = sign also it should come to + sign only anybody can assist me please Regards V.Kiran Kumar -- FORUM RULES (925+ 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 (925+ 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$$ Consolidate data in different work sheets
Do you want to copy a range from each sheet to a master or do a summary from different sheets? Don Guillett SalesAid Software dguille...@gmail.com From: smitha.kumari Sent: Tuesday, November 08, 2011 10:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Consolidate data in different work sheets Hi, I want to know how we can consolidate data in different worksheets into one worksheet. Regards Smitha/ Senior Finance Executive World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com -- FORUM RULES (925+ 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 (925+ 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$$ sumary of worksheet's names
Thank you all! You help me a lot! and sorry if I have not be clear, I need to practice my english... bye 2011/11/8 Sam Mathai Chacko samde...@gmail.com In Noorain's solution, the name of the defined name formula would be * SheetNames* Also, you can find here a UDF through VBA as well http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/ Regards, Sam Mathai Chacko On Tue, Nov 8, 2011 at 11:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: In Excel Version Write formula in refers To Under Formula -Define Name =REPLACE(GET.WORKBOOK(1),1,FIND(],GET.WORKBOOK(1)),) Paste it in Cell A1 =IF(ROWS($A$2:A2)=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ See attached sheet for Reference.. On Tue, Nov 8, 2011 at 8:26 PM, Chamili Coelho da Costa chami...@gmail.com wrote: Hi! How can I create a sumary with all the worksheet's name of the workbook? Thanks -- FORUM RULES (925+ 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 (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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 (925+ 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$$ Not getting the VB Editor in Excel
Are you sure you are not using the Excel Viewer? Regards, Sam On Wed, Nov 9, 2011 at 5:45 PM, Rohit Tikhe rmti...@gmail.com wrote: Can you please help me, as I not getting the VB Editor in Excel 2007 ** ** ** ** ** ** Rohit ** ** -- FORUM RULES (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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 image002.jpgimage001.png
Re: $$Excel-Macros$$ help: excel changes macro assignment
Hehe, Don, I'm sure he meant 'new' Clinton, Is there any sheet movements in your macro? Maybe worth posting your VBA code. Regards, Sam Mathai Chacko On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 dguille...@gmail.com wrote: You need to post your file or a least your code How does a jew workbook differ from a gentile workbook? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Clinton James Sent: Tuesday, November 08, 2011 7:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ help: excel changes macro assignment Hi alli am looking for help with an issue that is bugging me no end. I have assigned a macro to a button which works well until i double click on a cell which launches a macro to mine data and then use this to get information out of a pivot ...this data is then dumped onto a Jew workbook. This is fine except for the macro assigned to the button then changes...the name is the same but somehow it references this new workbook Aaron the location for the macro. Why would excel change the expected location of an assigned macro at all and how would i stop excel misbehavior? Thanks in advance. -- FORUM RULES (925+ 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 (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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$$ Macro To Add a Cell From A List And Create A New Tab
Thank you very much Paul. Worked very well. I appreciate your time. John On Tue, Nov 8, 2011 at 2:33 PM, Paul Schreiner schreiner_p...@att.netwrote: Try this: Sub Make_Sheets() Dim vCnt, vNum ThisWorkbook.Activate Sheets(Form).Select Application.ScreenUpdating = False vCnt = Application.WorksheetFunction.CountA(Sheets(Vehicle List).Range(A1:A65000)) For vNum = 2 To vCnt Sheets(Form).Copy After:=Sheets(3) Range(D56).Value = Sheets(Vehicle List).Cells(vNum, A).Value Next vNum Application.ScreenUpdating = True End Sub You'll have to save your file as .xlsb or .xlsm, but I prefer .xlsb *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* John A. Smith johnasmit...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, November 8, 2011 2:16:05 PM *Subject:* $$Excel-Macros$$ Macro To Add a Cell From A List And Create A New Tab I have a spreadsheet with a tab called Form. There is a second tab called Vehicle List. I need a macro to take the first vehicle on the list and put that number in cell D56 of the form tab and then copy the tab and repeat this process until all the vehicle numbers are on the form in their own tab. The tab names are not important as the spreadsheet will be saved in the pdf format and the tabs will become pages. Thank you for your help. John -- FORUM RULES (925+ 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 (925+ 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 (925+ 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$$ Macro To Add a Cell From A List And Create A New Tab
Thank you Don, your help is very much appreciated. John On Tue, Nov 8, 2011 at 2:57 PM, dguillett1 dguille...@gmail.com wrote: Use this macro and be sure to save your file as an .xls or .xlsm Sub MakeSheetsFromVehicleList() Sheets(Vehicle List).Select Dim c As Range Dim lr As Long lr = Cells(Rows.Count, 1).End(xlUp).Row For Each c In Range(a2:a lr) With Sheets(form) Range(d56).Value = c .Copy after:=ActiveSheet End With Next c End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Tuesday, November 08, 2011 1:16 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Macro To Add a Cell From A List And Create A New Tab I have a spreadsheet with a tab called Form. There is a second tab called Vehicle List. I need a macro to take the first vehicle on the list and put that number in cell D56 of the form tab and then copy the tab and repeat this process until all the vehicle numbers are on the form in their own tab. The tab names are not important as the spreadsheet will be saved in the pdf format and the tabs will become pages. Thank you for your help. John -- FORUM RULES (925+ 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 (925+ 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 (925+ 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$$ help: excel changes macro assignment
Hehe! I knew that Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Wednesday, November 09, 2011 9:53 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help: excel changes macro assignment Hehe, Don, I'm sure he meant 'new' Clinton, Is there any sheet movements in your macro? Maybe worth posting your VBA code. Regards, Sam Mathai Chacko On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 dguille...@gmail.com wrote: You need to post your file or a least your code How does a jew workbook differ from a gentile workbook? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Clinton James Sent: Tuesday, November 08, 2011 7:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ help: excel changes macro assignment Hi alli am looking for help with an issue that is bugging me no end. I have assigned a macro to a button which works well until i double click on a cell which launches a macro to mine data and then use this to get information out of a pivot ...this data is then dumped onto a Jew workbook. This is fine except for the macro assigned to the button then changes...the name is the same but somehow it references this new workbook Aaron the location for the macro. Why would excel change the expected location of an assigned macro at all and how would i stop excel misbehavior? Thanks in advance. -- FORUM RULES (925+ 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 (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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 (925+ 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$$ Rounding Method
Hi Mothilal, Yours is the exact and simplified solution. In fact, I forgot that function and I was unable to recollect it while replying to the OP's question. But, your reply helped me to recall it. Thanks Dude... --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 5:36 PM, jmothilal gjmothi...@gmail.com wrote: use this command =floor(a1,5) Mothilal.J[image: image.png] On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote: Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 when i typed 125.10 the rounding should come 125 when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ 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 -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- FORUM RULES (925+ 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 (925+ 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 image.png
$$Excel-Macros$$ Remove Zero using vba function
Dear all Can you help me out how to remove zero from a sheet: Example: A=0 B=0 C=0 D=2 E=3 F=56 G=0 H=67 I=9 J=0 K=0 I just want to remove zero from start and end (A,B,C,J,K) but should not remove the zero from between number, Please if any one have any idea how to make vba function for this please help me... please Thanks Regards Abhijit Mitra. -- FORUM RULES (925+ 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$$ Consolidate data in different work sheets
if you just want to do a sum of all the same cells across multiple sheets, you could use something like this =SUM(Sheet2:Sheet5!A2) Regards, Sam Mathai Chacko On Wed, Nov 9, 2011 at 6:59 PM, dguillett1 dguille...@gmail.com wrote: Do you want to copy a range from each sheet to a master or do a summary from different sheets? Don Guillett SalesAid Software dguille...@gmail.com *From:* smitha.kumari smitha.kum...@speridian.com *Sent:* Tuesday, November 08, 2011 10:38 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Consolidate data in different work sheets Hi, I want to know how we can consolidate data in different worksheets into one worksheet. Regards Smitha/ Senior Finance Executive [image: Speridian%20Logo] World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com -- FORUM RULES (925+ 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 (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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$$ Job- Required Excel Expert
Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company Role: Data Analyst Salary: Negotiable Functional Area: IT-Other Job Description . Good Analytical skills . Proficient in Advance Excel , Good hands on Excel Formulas and Dynamic Dashboard . Proficient in Excel Formulas(Logical(IF, AND, OR, NOT), Text(LEN, MID, LEFT, RIGHT), Lookup Refrence (Vlookup, Hlookup, Index, Match), Math Trig (Sumif, Sumifs..) . Should have Database Knowledge . Good written and oral communication Skill Company Profile Opera Solutions is one of the world's most rapidly growing consulting firms with offices in Boston, New York, San Diego, New Delhi, London and Shanghai. We specialize in tangible profit enhancement and deliver it through a series of focused practice areas, services and products. Our clients span across industries including Financial Services, Private Equity, FMCG, Publishing, Retail Distribution. We excel at working in 'data rich' environments and achieve outstanding results for our clients using proprietary analytics, and strategic execution talent, turning Big Data into profit growth. Thanks Mukesh -- FORUM RULES (925+ 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$$ remove a certain text from every sentence
Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose I need only the name, Technology Company: has to be removed from every cells. Please reply. Regards Smitha -- FORUM RULES (925+ 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$$ remove a certain text from every sentence
Select the column...go to find and replace...(CTRL+F) type the technology company in space for find and keep blank in the space provided for replace...then replace all. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: smitha.kumari smitha.kum...@speridian.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 10:39:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ remove a certain text from every sentence Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose I need only the name, Technology Company: has to be removed from every cells. Please reply. Regards Smitha -- FORUM RULES (925+ 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 (925+ 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$$ Not getting the VB Editor in Excel
Yes, I am sure about that. I am using MS Excel 2007 Rohit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 09 November 2011 20:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Not getting the VB Editor in Excel Are you sure you are not using the Excel Viewer? Regards, Sam On Wed, Nov 9, 2011 at 5:45 PM, Rohit Tikhe rmti...@gmail.com wrote: Can you please help me, as I not getting the VB Editor in Excel 2007 Rohit -- FORUM RULES (925+ 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 -- Sam Mathai Chacko -- FORUM RULES (925+ 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 (925+ 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.pngimage002.jpg
Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book
Dear Sir, Sorry for the late reply. Its still not working. On 3 November 2011 13:16, ashish koul koul.ash...@gmail.com wrote: Sub copy_first_sheet_from_different_workbooks_to_single() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim fld As Object, fil As Object Dim ask As Workbook, ask2 As Workbook With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .InitialFileName = c:\ .Show End With fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) Set ask = Workbooks.Add For Each fil In fld.Files If UCase(Right(fil.Path, 4)) = UCase(.xls) Or UCase(Right(fil.Path, 5)) = UCase(.xlsx) Then Set ask2 = Workbooks.Open(fil.Path) ask2.Sheets(1).UsedRange.Copy ask.Activate ask.Sheets.Add after:=Sheets(Sheets.Count) ActiveSheet.Range(a1).Select Selection.PasteSpecial xlValues ask2.Close End If Next fil Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Thu, Nov 3, 2011 at 1:06 PM, chhajersand...@gmail.com wrote: ** My files are saved in .xls format. But I am working in .xlxs. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- *From: *ashish koul koul.ash...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Thu, 3 Nov 2011 13:04:02 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book in which format ur files are saved .xls or xlsx On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer chhajersand...@gmail.com wrote: Dear Ashish, I have copied it but when i am running the code it showing error msg pls help. On 3 November 2011 10:53, ashish koul koul.ash...@gmail.com wrote: Sub copy_first_sheet_from_different_workbooks_to_single() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim fld As Object, fil As Object Dim ask As Workbook, ask2 As Workbook With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .InitialFileName = c:\ .Show End With fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) Set ask = Workbooks.Add For Each fil In fld.Files If UCase(Right(fil.Path, 4)) = UCase(.xls) Or UCase(Right(fil.Path, 5)) = UCase(.xlsx) Then Set ask2 = Workbooks.Open(fil.Path) ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count) ask2.Close End If Next fil Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha mris...@gmail.com wrote: Hi Sandeep, Save this attachment in the folder where you have all the workbooks and try to run the macro (Button) on page 1 of this file. Hope this helps, Mrinal On Wed, Nov 2, 2011 at 2:08 PM, chhajersand...@gmail.com wrote: Dear all, I have many work book in a single folder. I need a macro which if I run will copy the 1st sheet of every workbook in a single workbook (though as separate sheet). Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet of WB1 as 1st worksheet in a new workbook (say WB3) and again 1st worksheet of WB2 as 2nd worksheet of WB3. Thanks in advance. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (925+ 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 (925+ 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
Re: $$Excel-Macros$$ remove a certain text from every sentence
Use This command [image: image.png] Thanks with Mothilal.J -- FORUM RULES (925+ 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 image.png
RE: $$Excel-Macros$$ remove a certain text from every sentence
The result should be david and not Technology company Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Thursday, November 10, 2011 11:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ remove a certain text from every sentence Use This command image.png Thanks with Mothilal.J -- FORUM RULES (925+ 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 (925+ 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.jpgimage002.png
$$Excel-Macros$$ formula
If name in a cell is Simon in a work sheet 2 then the designation already allotted for Simon in worksheet 1 should appear there in worksheet 1 or wherever in the same work book. Please show me the formula for that Regards Smitha -- FORUM RULES (925+ 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$$ remove a certain text from every sentence
you can use find replace. On 10 November 2011 10:39, smitha.kumari smitha.kum...@speridian.comwrote: Hi, ** ** I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose ** ** I need only the name, “Technology Company:” has to be removed from every cells. Please reply. ** ** Regards Smitha ** ** -- FORUM RULES (925+ 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 (925+ 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$$ remove a certain text from every sentence
Hello Smitha; If you need a formula use, =REPLACE(A1,1,FIND(:,A1),) Or Select your data, press CTRL+H; Find What: **:* Click Replace All Hope this helps Haseeb -- FORUM RULES (925+ 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$$ Consolidate data in different work sheets
Hi Haseeb, This will not consolidate the name , only the hours. Isn't it? Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Haseeb Avarakkan Sent: Thursday, November 10, 2011 12:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Consolidate data in different work sheets Hello Smitha; Use this in Sheet1 B6 copy down across, =SUMIF(INDIRECT('B$5'!A:A),$A6,INDIRECT('B$5'!I:I)) All the sheet names in 5th row must be same as worksheet names.Letters doesn't has to be case sensitive. See the attached. HTH Haseeb -- FORUM RULES (925+ 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 (925+ 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$$ Re: formula
PFA the sheet with name and designations. Required is, if I type the name in another worksheet, the designation column for the name should show as in the attachement Regards Smitha/ Senior Finance Executive World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, November 10, 2011 12:31 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: formula Please upload your sample workbook. Without that, it will be difficult to understand exactly what you require. Sam On Nov 10, 11:11 am, smitha.kumari smitha.kum...@speridian.com wrote: If name in a cell is Simon in a work sheet 2 then the designation already allotted for Simon in worksheet 1 should appear there in worksheet 1 or wherever in the same work book. Please show me the formula for that Regards Smitha -- FORUM RULES (934+ 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 (934+ 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 designations.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Re: formula
Thanks Ashish. Please specify why 2 ,0 is used =VLOOKUP(A1,Sheet3!A:B,2,0) Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, November 10, 2011 1:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: formula use vlookup On Thu, Nov 10, 2011 at 12:41 PM, smitha.kumari smitha.kum...@speridian.com wrote: PFA the sheet with name and designations. Required is, if I type the name in another worksheet, the designation column for the name should show as in the attachement Regards Smitha/ Senior Finance Executive World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, November 10, 2011 12:31 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: formula Please upload your sample workbook. Without that, it will be difficult to understand exactly what you require. Sam On Nov 10, 11:11 am, smitha.kumari smitha.kum...@speridian.com wrote: If name in a cell is Simon in a work sheet 2 then the designation already allotted for Simon in worksheet 1 should appear there in worksheet 1 or wherever in the same work book. Please show me the formula for that Regards Smitha -- FORUM RULES (934+ 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 (934+ 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 -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ 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 (934+ 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$$ Re: Unable to open the password Protected PPT Help me on this -------------------------------------------
There are clear instructions not to post queries related to password hacks. Please ensure forum decorum. Sam On Nov 10, 12:15 pm, jocky Beta jocky6...@gmail.com wrote: Hi Team, I had made one PPT file few days ago and now i had forgot the password of that PPT. Hence request you anybody help me on this Regards, Jocky -- FORUM RULES (934+ 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