$$Excel-Macros$$ Conditional Comments
Dear All Can I give conditional conmments.For Eg if In Cell A1 there is XYZ then the comments show Good Work and If A1 contents PQR then comments should showneed Improvement Is it possible ? if yes please let me know hoe to do it. Waiting for reply -- Shrini -- 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$$ Conditional Comments
Hi, Try it... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address $A$1 Or Target.Cells.Count 1 Then Exit Sub Target.ClearComments If Target.Value = XYZ Then Target.AddComment (Good Work) End If If Target.Value = PQR Then Target.AddComment (Need Improvement) End If End Sub Regards, MARIES. +971502420957 On Wed, Mar 7, 2012 at 2:07 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Can I give conditional conmments.For Eg if In Cell A1 there is XYZ then the comments show Good Work and If A1 contents PQR then comments should showneed Improvement -- 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 COMMENTS.xlsm Description: Binary data
RE: $$Excel-Macros$$ Conditional Comments
Option Compare Text Private Sub Worksheet_Change(ByVal Target As Range) With Target .ClearComments If .Cells.Count = 1 Then If Target.Value = Xyz Then .AddComment (Good Work) ElseIf .Value = PQR Then .AddComment (Need Improvement) End If End If End With End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Mar/Wed/2012 03:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Conditional Comments Dear All Can I give conditional conmments.For Eg if In Cell A1 there is XYZ then the comments show Good Work and If A1 contents PQR then comments should showneed Improvement Is it possible ? if yes please let me know hoe to do it. Waiting for reply -- Shrini -- 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$$ Need VBA Book
Excel 2003/2007 Power Programming with VBA Try to Download From Google.. it's a good and free by J-walk From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Wed/2012 10:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need VBA Book http://search.4shared.com/q/CCAD/1/excel%20vba?suggested On Tue, Mar 6, 2012 at 10:24 AM, akul rastogi akulrast...@gmail.com wrote: Hi All, I need the ebook to learn VBA to use in excel. Did anyone can give me the link or send the book as attachement. Thanks in advance. -- ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* Thanks and regards Akul ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* -- 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$$ Confirmation
Hi, Can you explain how you need to block Formula and headings? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Wed/2012 11:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Confirmation Hi, Try below Code, Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub Regards, MARIES. +971502420957 On Wed, Mar 7, 2012 at 9:15 AM, ashjain2...@yahoo.co.in ashjain2...@yahoo.co.in wrote: I want to block Heading and Formula Bar in Excel file... How can we block it... I want, Without password, It will not reflect... -- 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$$ Opening for MIS Executive.
Hi All, We have good Opening for MIS Executive. Job Description: Location - Gurgaon (Nr Huda City Centre Metro Station) Work Experience : - Total 2+ Year. Required Skills : - Good Command Over MS Excel.(Vlookup,sumif,Filter,Condition Formatting,Pivot Table) CTC : - 1:80 - 2:10 Lac. Joining time : - within 15 days. if you are interested Please Send me your updated resume ASAP on mail : - * amreshkushw...@gmail.com* Regards Amresh -- 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$$ vba code to kill all open workbooks
How about application.quit or Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks w.Close SaveChanges:=false Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Tuesday, March 06, 2012 8:24 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ vba code to kill all open workbooks is there a VBA code that i can run that will kill all open worksheets? i open about 10 open excel files and once i'm done i want close all work sheets WITHOUT SAVING. i dont want any of my changes to affect the sheets can this be done? -- 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$$ modification in paste special macro.
no Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Tuesday, March 06, 2012 10:41 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ modification in paste special macro. i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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$$ Need if formula
You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 Follow Rediff Deal ho jaye! to get exciting offers in your city everyday. -- 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$$ Re: modification in paste special macro.
First of all, you should NOT simply change the topic of somone else's discussion thread and ask your own question. That's called hijacking a thread, and is extremely bad form. Secondly... When you select a range of cells and copy/paste special -Values, Excel does a bunch of stuff behind-the-scenes. One thing it does is that it takes the current values and copies them to the undo stack. This stack list is displayed whenever you use the undo pull-down. You'll also notice that it operates in a last-in-first-out sequence. (the last thing you did is the first thing that can be reversed) (in other programming environments, putting something on the stack is called a push to the stack, and retrieving from the stack is called a pop from the stack) When you created your macro, you effectively bypass making the entry into the undo stack. I haven't done much stack programming in a number of years (and never in Excel) I'm not sure if you can manually push anything to the stack. So.. Don's answer may be much more concise, as well as serving two purposes: No, you cannot push the pastespecial to the undo stack, and No, you should not use someone else's discussion thread for your own unrelated question. Paul On Tuesday, March 6, 2012 11:41:23 PM UTC-5, danial mansoor wrote: i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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$$ loop through cell
Many reasons. What are you trying to do? For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then 'you didn’t select the worksheet and you do NOT need to with ws .Columns(C).AutoFit .Columns(E:H).ColumnWidth = 13.86 .Columns(L).ColumnWidth = 40 .Columns(K:).ColumnWidth = 4 end with End If Next ws Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Tuesday, March 06, 2012 8:46 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ loop through cell help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then Columns(C:C).EntireColumn.AutoFit ws.Columns(E:H).Select ws.Selection.ColumnWidth = 13.86 ws.Columns(L:L).ColumnWidth = 40 ws.Columns(K:K).ColumnWidth = 4 End If Next ws End Sub -- 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$$ Re: modification in paste special macro.
Paul, As you know I adhere closely to the KISS principle. I assumed ?? that OP wanted to “put the formula back” . Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, March 07, 2012 8:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: modification in paste special macro. First of all, you should NOT simply change the topic of somone else's discussion thread and ask your own question. That's called hijacking a thread, and is extremely bad form. Secondly... When you select a range of cells and copy/paste special -Values, Excel does a bunch of stuff behind-the-scenes. One thing it does is that it takes the current values and copies them to the undo stack. This stack list is displayed whenever you use the undo pull-down. You'll also notice that it operates in a last-in-first-out sequence. (the last thing you did is the first thing that can be reversed) (in other programming environments, putting something on the stack is called a push to the stack, and retrieving from the stack is called a pop from the stack) When you created your macro, you effectively bypass making the entry into the undo stack. I haven't done much stack programming in a number of years (and never in Excel) I'm not sure if you can manually push anything to the stack. So.. Don's answer may be much more concise, as well as serving two purposes: No, you cannot push the pastespecial to the undo stack, and No, you should not use someone else's discussion thread for your own unrelated question. Paul On Tuesday, March 6, 2012 11:41:23 PM UTC-5, danial mansoor wrote: i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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$$ loop through cell
Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel sendse...@gmail.com wrote: help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then Columns(C:C).EntireColumn.AutoFit ws.Columns(E:H).Select ws.Selection.ColumnWidth = 13.86 ws.Columns(L:L).ColumnWidth = 40 ws.Columns(K:K).ColumnWidth = 4 End If Next ws End Sub -- 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$$ modification in paste special macro.
i think... its not possible... On Wed, Mar 7, 2012 at 10:11 AM, danial mansoor danial_...@hotmail.comwrote: i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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$$ formula help
hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- 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 formula help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: modification in paste special macro.
Don, Oh, I agree completely! However, depending on the experience level of the person asking the question, it may not be enough to know that you CAN'T do it. Personally, I'd need to know WHY. There's been far too many times that someone has said (to me or others) that something can't be done simply because they haven't been able to do it. In fact, I'm a firm believer that ANYTHING can be done. All it takes is time and money. If I were told that something cannot be done, then I'd simply keep looking for another way to do the same thing. If I were told WHY it cannot be done, then I may decide that the time (and money) required to do it isn't worth the effort. For example: If it were REALLY important that I be able to do what he's asking, then I'd build my own undo stack. Either virtually, or within the application. For instance, in his macro I'd use a hidden sheet to store the Range's current formulas, then do the PasteSpecial. If I needed to undo it, then I'd use a macro to restore the formulas. This would be a single-step undo, I wouldn't be able to go back several steps. To do multi-levels, I'd have to either use multiple sheets, or look into virtual multi-dimensional arrays. But then again, I'd REALLY have to want to do it (or someone pay me enough to REALLY want to do it) 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: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, March 7, 2012 9:48:44 AM Subject: Re: $$Excel-Macros$$ Re: modification in paste special macro. Paul, As you know I adhere closely to the KISS principle. I assumed ?? that OP wanted to “put the formula back” . Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, March 07, 2012 8:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: modification in paste special macro. First of all, you should NOT simply change the topic of somone else's discussion thread and ask your own question. That's called hijacking a thread, and is extremely bad form. Secondly... When you select a range of cells and copy/paste special -Values, Excel does a bunch of stuff behind-the-scenes. One thing it does is that it takes the current values and copies them to the undo stack. This stack list is displayed whenever you use the undo pull-down. You'll also notice that it operates in a last-in-first-out sequence. (the last thing you did is the first thing that can be reversed) (in other programming environments, putting something on the stack is called a push to the stack, and retrieving from the stack is called a pop from the stack) When you created your macro, you effectively bypass making the entry into the undo stack. I haven't done much stack programming in a number of years (and never in Excel) I'm not sure if you can manually push anything to the stack. So.. Don's answer may be much more concise, as well as serving two purposes: No, you cannot push the pastespecial to the undo stack, and No, you should not use someone else's discussion thread for your own unrelated question. Paul On Tuesday, March 6, 2012 11:41:23 PM UTC-5, danial mansoor wrote: i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial( xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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$$ formula help
Dear Avinash, Please use it.. =B2--COUNTIF($A$2:A2,A2) or =$B2--SUMPRODUCT(--($A$2:$A2=$A2)) See attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 9:30 PM, Avinash avinash007pa...@gmail.com wrote: hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- 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 formula help(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: modification in paste special macro.
And I agree with you. I have actually written projects to restore ALL formulas with macros on open because a user was always destroying somehow and insisted on not having them protected.. range(“c2:c22”).formula=”=a2+b2” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, March 07, 2012 10:08 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: modification in paste special macro. Don, Oh, I agree completely! However, depending on the experience level of the person asking the question, it may not be enough to know that you CAN'T do it. Personally, I'd need to know WHY. There's been far too many times that someone has said (to me or others) that something can't be done simply because they haven't been able to do it. In fact, I'm a firm believer that ANYTHING can be done. All it takes is time and money. If I were told that something cannot be done, then I'd simply keep looking for another way to do the same thing. If I were told WHY it cannot be done, then I may decide that the time (and money) required to do it isn't worth the effort. For example: If it were REALLY important that I be able to do what he's asking, then I'd build my own undo stack. Either virtually, or within the application. For instance, in his macro I'd use a hidden sheet to store the Range's current formulas, then do the PasteSpecial. If I needed to undo it, then I'd use a macro to restore the formulas. This would be a single-step undo, I wouldn't be able to go back several steps. To do multi-levels, I'd have to either use multiple sheets, or look into virtual multi-dimensional arrays. But then again, I'd REALLY have to want to do it (or someone pay me enough to REALLY want to do it) 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: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, March 7, 2012 9:48:44 AM Subject: Re: $$Excel-Macros$$ Re: modification in paste special macro. Paul, As you know I adhere closely to the KISS principle. I assumed ?? that OP wanted to “put the formula back” . Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, March 07, 2012 8:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: modification in paste special macro. First of all, you should NOT simply change the topic of somone else's discussion thread and ask your own question. That's called hijacking a thread, and is extremely bad form. Secondly... When you select a range of cells and copy/paste special -Values, Excel does a bunch of stuff behind-the-scenes. One thing it does is that it takes the current values and copies them to the undo stack. This stack list is displayed whenever you use the undo pull-down. You'll also notice that it operates in a last-in-first-out sequence. (the last thing you did is the first thing that can be reversed) (in other programming environments, putting something on the stack is called a push to the stack, and retrieving from the stack is called a pop from the stack) When you created your macro, you effectively bypass making the entry into the undo stack. I haven't done much stack programming in a number of years (and never in Excel) I'm not sure if you can manually push anything to the stack. So.. Don's answer may be much more concise, as well as serving two purposes: No, you cannot push the pastespecial to the undo stack, and No, you should not use someone else's discussion thread for your own unrelated question. Paul On Tuesday, March 6, 2012 11:41:23 PM UTC-5, danial mansoor wrote: i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial( xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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.
$$Excel-Macros$$ Vlookup basics and help
I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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$$ formula help
Macro solution for summary Sub getuniqueandcount() Range(A1:A Cells(Rows.Count, 1).End(xlUp).Row) _ .AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range(G1), Unique:=True Range(h2:H Cells(Rows.Count, g).End(xlUp).Row).Formula = _ =VLOOKUP(G2,A:B,2,0)--COUNTIF(A:A,G2) End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Wednesday, March 07, 2012 10:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ formula help Dear Avinash, Please use it.. =B2--COUNTIF($A$2:A2,A2) or =$B2--SUMPRODUCT(--($A$2:$A2=$A2)) See attached sheet. -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 9:30 PM, Avinash avinash007pa...@gmail.com wrote: hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- 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 basics and help
Dear Skanda, Plase share sample workbook with group -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10:23 PM, Skanda skanda.pokkun...@gmail.com wrote: I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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 basics and help
vlookup?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Skanda Sent: Wednesday, March 07, 2012 10:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup basics and help I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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 basics and help
Yes On Wed, Mar 7, 2012 at 11:04 AM, dguillett1 dguille...@gmail.com wrote: vlookup?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Skanda skanda.pokkun...@gmail.com *Sent:* Wednesday, March 07, 2012 10:53 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Vlookup basics and help I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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 basics and help
On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Skanda, Plase share sample workbook with group -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10:23 PM, Skanda skanda.pokkun...@gmail.comwrote: I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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 vlookup.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Multipal sheet vlookup-Urgent plz
HI Team, I need to put a vlookup for multipal sheet and get result on one sheet. Based on the sheet selection in cell hc6 the formula should get result as shown in the attached sheet. Regards, Vin -- 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 test.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need if formula
thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Follow *Rediff Deal ho jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals * to get exciting offers in your city everyday. -- 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 -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries
Re: $$Excel-Macros$$ Need if formula
i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Follow *Rediff Deal ho jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals * to get exciting offers in your city everyday. -- 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 -- -- Thanks
$$Excel-Macros$$ Exl Adds-in or any software for doing data reconciliations
Hi friends, Please help me if you are using a any excel adds-in or any software for data reconciliation. Warm regards, --- *Pranab A Brahmangaonkar* Pune, India. Mobile + 91 9822445858 -- 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$$ Search an fill combobox
Hi. Someone help with this: I have a book with aprox 20 sheets, many products are included. Well i need a search a defined product from combobox inside a userform, but when i write the first letter the macro run and don't let me write the others. I tried to put a delay but doesn't work. If you can help me?, Please Private Sub ComboBox1_Change() Dim Producto As String Dim SheetCount As Integer Dim counter As Integer Dim currentSheet As Integer Producto = ComboBox1.Value Application.ScreenUpdating = False On Error Resume Next currentSheet = ActiveSheet.Index For counter = 1 To 20 Sheets(counter).Activate Cells.Find(What:=Producto, After:=ActiveCell, LookIn:=xlValues, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ComboBox1.AddItem ActiveCell.Value Cells.FindNext(After:=ActiveCell).Activate ComboBox1.AddItem ActiveCell.Value If ComoboBox1.Value Producto Then ComboBox1.RemoveItem (ComboBox1.Value Producto) End If Next counter If you need more information please contact contact me Thanks -- 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$$ Need Help
Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- 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 HELP1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ formula help
Hey! Look at the file, Good luck! 2012/3/7 Avinash avinash007pa...@gmail.com hi all can anyone help me to get the desired result in this sheet i have attached the sheet please see the attachment for better understanding. Regards Avinash -- 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 formula help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Help
FYI. Regards karthik.N On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kartik, Can you share sample workbook. On Tue, Mar 6, 2012 at 6:35 PM, karthik N n.karthi...@gmail.com wrote: Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards Karthik -- 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://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 -- *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 HELP1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup basics and help
Modify to suit =IF(ISNA(VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)),,VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Skanda Sent: Wednesday, March 07, 2012 11:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup basics and help On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Skanda, Plase share sample workbook with group -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10:23 PM, Skanda skanda.pokkun...@gmail.com wrote: I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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$$ Need if formula
You didn’t show us YOUR formula but try looking in the HELP index for ISERR or ISNA Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajasekhar Praharaju Sent: Wednesday, March 07, 2012 1:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need if formula i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 Follow Rediff Deal ho jaye! to get exciting offers in your city everyday. -- 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
Re: $$Excel-Macros$$ vba code to kill all open workbooks
thanks works great...if you want the current workbook to remain open where you're running the code what needs to be changed? ie: Master file book1 book2 book3 ect close everything expect master file On Mar 7, 8:32 am, dguillett1 dguille...@gmail.com wrote: How about application.quit or Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks w.Close SaveChanges:=false Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Tuesday, March 06, 2012 8:24 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ vba code to kill all open workbooks is there a VBA code that i can run that will kill all open worksheets? i open about 10 open excel files and once i'm done i want close all work sheets WITHOUT SAVING. i dont want any of my changes to affect the sheets can this be done? -- 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$$ loop through cell
Don work Great thanks For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then i use this code to not look at the doc sheet, is there a better way? i have 10 sheets that i want the the code to run on and the ones that i dont i use the top code. and how do you send sheets through groups? i dont know how to include attachment . On Mar 7, 10:15 am, vijayajith VA vijayajith...@gmail.com wrote: Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel sendse...@gmail.com wrote: help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then Columns(C:C).EntireColumn.AutoFit ws.Columns(E:H).Select ws.Selection.ColumnWidth = 13.86 ws.Columns(L:L).ColumnWidth = 40 ws.Columns(K:K).ColumnWidth = 4 End If Next ws End Sub -- 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 range
hey Don sorry to trouble you but for some reason i couldnt get this to work... i dont know how to attatch a file On Mar 6, 8:57 am, dguillett1 dguille...@gmail.com wrote: Try this. BTW you have NO Bob in field 7 Sub filterandcopyusedrange() Dim ds As Worksheet Set ds = Sheets(Sheet10) Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Copy ds.Range(d1) With ActiveSheet.UsedRange .AutoFilter Field:=7, Criteria1:=bob .SpecialCells(xlCellTypeVisible).Copy ds.Range(a2) .AutoFilter End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Monday, March 05, 2012 6:21 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy range Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- 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$$ modification in paste special macro.
? Sure it is, It's just a bit of trouble. Actually, IsItPossible is almost always = True. Even if drastic measuers are required or no one knows exactly how it's possible. But most requests that come up are possible in some relatively understood way. 1. Any macro can be undo-able, but you usually have to do the undoing yourself in your macro. This means your macro needs to do 3 things: (a) keep a careful record of all changes it makes and how to undo them (b) make the changes and (c) restore the changes when requested. Excel has the Application.OnUndo method for your macro to notify Excel that it has this capability and it specifies the macro/procedure name for Excel to call when the user hits Undo. See http://j-walk.com/ss/excel/tips/tip23.htm. 2. If your macro doesn't directly change the worksheet, your macro does not interfere with undo capability (in general). You can take advantage of this by using Application.SendKeys to put keyboard shortcuts in the keyboard buffer that cause Excel to do stuff after your macro ends. Pros usually avoid this method since there is not a 100% guarantee that the user might not press other keys at the same time or that the wrong window might have the focus, or that the user had reassigned the keyboard shortcuts. But it is a simple option. In your case, there are keyboard shortcuts for the stuff your macro does, so this method is viable. .For option #1, see the linked tip for ideas on how to implement it. .For option #2, in my tests the following rewrites of your macro all worked: Sub daniyal() ' This version is preferred - the others need the macro to pause a second With Application ' User has hand on ctrl key from macro shortcut, but does not seem to interfere with this combo ' +{F10}v is Shift-F10 for context menu, then v for paste values (unlisted). ' ^+! is Ctrl-Shift-! for the number format #,##0.00 If .CutCopyMode Then .SendKeys +{F10}v^+! End With End Sub Sub daniyal() With Application .Wait Now + 1 / 86400 ' one second for user to release ctrl key ' %esv~ is Alt-e (edit), s (paste special), v (values), enter (ok). ' ^+! is Ctrl-Shift-! for the number format #,##0.00 If .CutCopyMode Then .SendKeys %esv~^+! End With End Sub Sub daniyal() ' This version for Excel 2007+ only With Application .Wait Now + 1 / 86400 ' one second for user to release ctrl key ' %hvv is Alt-h (home), v (paste), v (values). ' ^+! is Ctrl-Shift-! for the number format #,##0.00 If .CutCopyMode Then .SendKeys %hvv^+! End With End Sub Undo worked after running the macro, but undo had to be pressed twice since two actions are taken (paste special and format). P.S. In your original macro I'm not sure why you are assigned the return value of PasteSpecial to selection.HasFormula... ? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Wednesday, March 07, 2012 5:39 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ modification in paste special macro. no Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: danial mansoor mailto:danial_...@hotmail.com Sent: Tuesday, March 06, 2012 10:41 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ modification in paste special macro. i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- 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
Re: $$Excel-Macros$$ loop through cell
Send direct to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:33 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ loop through cell Don work Great thanks For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ what ?? And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then i use this code to not look at the doc sheet, is there a better way? i have 10 sheets that i want the the code to run on and the ones that i dont i use the top code. and how do you send sheets through groups? i dont know how to include attachment . On Mar 7, 10:15 am, vijayajith VA vijayajith...@gmail.com wrote: Hi learn excel.. Please send it with attachment.. it will be helpful.Thanks/// On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel sendse...@gmail.com wrote: help with code Dim ws As Worksheet can someone tell me why the follwowing code wont work For Each ws In ThisWorkbook.Worksheets If InStr(1, ws.Name, vbTextCompare) = 0 _ And InStr(1, ws.Name, Doc, vbTextCompare) = 0 Then Columns(C:C).EntireColumn.AutoFit ws.Columns(E:H).Select ws.Selection.ColumnWidth = 13.86 ws.Columns(L:L).ColumnWidth = 40 ws.Columns(K:K).ColumnWidth = 4 End If Next ws End Sub -- 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$$ vba code to kill all open workbooks
Sub CLOSE_ALLbut() myname = ActiveWorkbook.Name Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks If w.Name myname Then w.Close SaveChanges:=False End If Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:20 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ vba code to kill all open workbooks thanks works great...if you want the current workbook to remain open where you're running the code what needs to be changed? ie: Master file book1 book2 book3 ect close everything expect master file On Mar 7, 8:32 am, dguillett1 dguille...@gmail.com wrote: How about application.quit or Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Application.Workbooks w.Close SaveChanges:=false Next w 'Application.Quit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Tuesday, March 06, 2012 8:24 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ vba code to kill all open workbooks is there a VBA code that i can run that will kill all open worksheets? i open about 10 open excel files and once i'm done i want close all work sheets WITHOUT SAVING. i dont want any of my changes to affect the sheets can this be done? -- 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 range
send to dguillett1 @gmail.com Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, March 07, 2012 4:37 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ copy range hey Don sorry to trouble you but for some reason i couldnt get this to work... i dont know how to attatch a file On Mar 6, 8:57 am, dguillett1 dguille...@gmail.com wrote: Try this. BTW you have NO Bob in field 7 Sub filterandcopyusedrange() Dim ds As Worksheet Set ds = Sheets(Sheet10) Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Copy ds.Range(d1) With ActiveSheet.UsedRange .AutoFilter Field:=7, Criteria1:=bob .SpecialCells(xlCellTypeVisible).Copy ds.Range(a2) .AutoFilter End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Monday, March 05, 2012 6:21 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy range Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:=bob ActiveSheet.Range(a1:o1, ActiveSheet.Range(a1).End(xlDown)).Select the problem that i have is in cell G after the last cell there is a 3 lines of blank cell and then the report, once the filter is made i want the cell to also include theName report can anyone help? data name nam nam nam nam nam nam nam 3/5/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob dog bob john random random john bob 3/6/2012 john bob dog bob john random john bob 3/6/2012 random john bob dog bob john new name nam 3/6/2012 bob bob dog bob john random john bob 3/6/2012 random john bob bob random random john bob 3/6/2012 random john bob dog bob john new name nam Name report -- 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$$ : How to use IF Function more than 8 times ?
0 100 126 200 131 300 136 400 141 500 146 600 151 700 156 800 161 900 166 1000 171 1100 =VLOOKUP(A3,B8:C18,2) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rushiraj Patel Sent: Wednesday, March 07, 2012 12:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ : How to use IF Function more than 8 times ? Dear Experts, I am using Excel 2003. I have a file in which I need to bifurcate the figures in different slabs. The Count of slabs goes up to 8. As per the Excel 2003 limitations I am only able to get result till 7th slab and not more than that. Please guide if there is any way out. Appended the reference files. Rgds, Rushiraj Patel Save trees. Go Green. -- 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 image006.jpgimage007.jpg
Re: $$Excel-Macros$$ Vlookup basics and help
Don, It did not return any values On Wed, Mar 7, 2012 at 4:56 PM, dguillett1 dguille...@gmail.com wrote: Modify to suit =IF(ISNA(VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)),,VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Skanda skanda.pokkun...@gmail.com *Sent:* Wednesday, March 07, 2012 11:31 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Vlookup basics and help On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Skanda, Plase share sample workbook with group -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10:23 PM, Skanda skanda.pokkun...@gmail.comwrote: I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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
Re: $$Excel-Macros$$ Need Help
Dear Kartik please use below codeand Change red color path Sub Sheet_Creater_Deptwise() Dim rng As Range Dim rng1 As Range Set rng = Sheet1.Range(G1:G Sheet1.Range(G65536).End(xlUp).Row) rng.Copy Sheet1.Range(H1) Set rng1 = Sheet1.Range(H1:H Sheet1.Range(H65536).End(xlUp).Row) rng1.Select Selection.RemoveDuplicates 1 For i = 2 To Sheet1.Cells(Rows.Count, H).End(xlUp).Row Sheets.Add after:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Sheet1.Cells(i, H) Sheet1.Range(A1:G1).Copy Sheets(Sheets.Count).Range(A1) c = 2 For j = 2 To Sheet1.Cells(Rows.Count, G).End(xlUp).Row If Sheet1.Cells(j, G).Value = Sheet1.Cells(i, H).Value Then Sheets(Sheets.Count).Cells(c, 1).Value = Sheets(1).Cells(j, 1).Value Sheets(Sheets.Count).Cells(c, 2).Value = Sheets(1).Cells(j, 2).Value Sheets(Sheets.Count).Cells(c, 3).Value = Sheets(1).Cells(j, 3).Value Sheets(Sheets.Count).Cells(c, 4).Value = Sheets(1).Cells(j, 4).Value Sheets(Sheets.Count).Cells(c, 5).Value = Sheets(1).Cells(j, 5).Value Sheets(Sheets.Count).Cells(c, 6).Value = Sheets(1).Cells(j, 6).Value Sheets(Sheets.Count).Cells(c, 7).Value = Sheets(1).Cells(j, 7).Value c = c + 1 End If Next Sheets(Sheets.Count).Columns.AutoFit Next Sheet1.Range(H:H).ClearContents End Sub and Sub Workbook_Create_Deptwise() Dim rng As Range Dim rng1 As Range Set rng = Sheet1.Range(G1:G Sheet1.Range(G65536).End(xlUp).Row) rng.Copy Sheet1.Range(H1) Set rng1 = Sheet1.Range(H1:H Sheet1.Range(H65536).End(xlUp).Row) rng1.Select Selection.RemoveDuplicates 1 For i = 2 To Sheet1.Cells(Rows.Count, H).End(xlUp).Row Workbooks.Add ActiveWorkbook.SaveAs D:\Noorain\ Sheet1.Cells(i, H) .xls Sheet1.Range(A1:G1).Copy ActiveWorkbook.Sheets(1).Range(A1) c = 2 For j = 2 To Sheet1.Cells(Rows.Count, G).End(xlUp).Row If Sheet1.Cells(j, G).Value = Sheet1.Cells(i, H).Value Then ActiveWorkbook.Sheets(1).Cells(c, 1).Value = Sheet1.Cells(j, 1).Value ActiveWorkbook.Sheets(1).Cells(c, 2).Value = Sheet1.Cells(j, 2).Value ActiveWorkbook.Sheets(1).Cells(c, 3).Value = Sheet1.Cells(j, 3).Value ActiveWorkbook.Sheets(1).Cells(c, 4).Value = Sheet1.Cells(j, 4).Value ActiveWorkbook.Sheets(1).Cells(c, 5).Value = Sheet1.Cells(j, 5).Value ActiveWorkbook.Sheets(1).Cells(c, 6).Value = Sheet1.Cells(j, 6).Value ActiveWorkbook.Sheets(1).Cells(c, 7).Value = Sheet1.Cells(j, 7).Value c = c + 1 End If Next ActiveWorkbook.Sheets(1).Columns.AutoFit ActiveWorkbook.Save ActiveWorkbook.Close Next Sheet1.Range(H:H).ClearContents End Sub Please attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 3:13 PM, karthik N n.karthi...@gmail.com wrote: FYI. Regards karthik.N On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kartik, Can you share sample workbook. On Tue, Mar 6, 2012 at 6:35 PM, karthik N n.karthi...@gmail.com wrote: Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards Karthik -- 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 -- *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
Re: $$Excel-Macros$$ Multipal sheet vlookup-Urgent plz
Dear Vinod, Please use.. =VLOOKUP($F15,INDIRECT($K$15!F:I),3,0) and see attached sheet.. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 11:42 PM, vinod rao vinod.ma...@gmail.com wrote: HI Team, I need to put a vlookup for multipal sheet and get result on one sheet. Based on the sheet selection in cell hc6 the formula should get result as shown in the attached sheet. Regards, Vin -- 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 test(Solved-Noorain).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Vlookup basics and help
Dear Skanda, Please try it.. =IFERROR(VLOOKUP($A3,Maindata!$A$1:$I$25,MATCH(C$1,Maindata!$A$1:$I$1,0),0),--) See attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10:23 PM, Skanda skanda.pokkun...@gmail.com wrote: I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Excess Claimant Claim_Handler How to: We have claim_number in Subset worksheet, use that to pull policy_number and profit_center from Maindata worksheet and also compare compare the insured from both the tabs? -- 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 vlookup(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need if formula
Dear Rajasekhar, You can use the IsError function as follows: =IF(ISERROR(B4/C4),0,B4/C4) On Thu, Mar 8, 2012 at 12:31 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Follow *Rediff Deal ho jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals * to get exciting offers in your city everyday. -- 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.
Re: $$Excel-Macros$$ Need Help
see attached sheet.. On Wed, Mar 7, 2012 at 3:12 PM, karthik N n.karthi...@gmail.com wrote: Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- 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://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 Copy of HELP1(Solved_Noorain).xlsm Description: Binary data
$$Excel-Macros$$ conditinal formatting - based on date col.....(plz help)
Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. 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 conditinal format.xls Description: conditinal format.xls
Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?
Hi Rushiraj, you can also you lookup function please find the attachment.. On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel rushiraj.pa...@in.aegisglobal.com wrote: Dear Experts, ** ** I am using Excel 2003. ** ** I have a file in which I need to bifurcate the figures in different slabs. The Count of slabs goes up to 8. As per the Excel 2003 limitations I am only able to get result till 7th slab and not more than that. ** ** Please guide if there is any way out. Appended the reference files. ** ** ** ** Rgds, ** ** Rushiraj Patel ** ** Save trees. Go Green. -- 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 image007.jpgimage006.jpg Copy of How to Use IF Function more than 8 times.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot Issue
Hello, Please let me know is there any soultion for this kind of issues. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:58 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Rajan, Yes Pivot name is correct. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Is pivot name “BP” correct? ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Mar/Tue/2012 04:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Pivot Issue ** ** Hello, I get errro as *Unable to get the pivottables property of the worksheet class *in the below code. could you assist me on this code. Thanks in advance. Sub RefreshPivotTables() Worksheets(OBC).Activate Application.DisplayAlerts = False *ActiveSheet.PivotTables(BP).PivotCache.Refresh *Application.DisplayAlerts = True End Sub Regards, Chandra Shekar B -- 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$$ conditinal formatting - based on date col.....(plz help)
A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: ** Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. 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 -- Sam Mathai Chacko -- 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$$ conditinal formatting - based on date col.....(plz help)
Dear Sam, Thanx for reply, Conditional formatting to change the color. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date col.(plz help) A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. 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 -- Sam Mathai Chacko -- 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$$ : How to use IF Function more than 8 times ?
I'd go with recommended solution of having helper columns. In case you need a non-helper column solution, use =LOOKUP(C16,{0,126,131,136,141,146,151,161,171,201},{125 and Below,126 to 130,131 to 135,136 to 140,141 to 145,146 to 150,151 to 160,160 to 170,171 to 200,200 and above}) Regards, Sam Mathai Chacko On Thu, Mar 8, 2012 at 11:39 AM, xlstime xlst...@gmail.com wrote: Hi Rushiraj, you can also you lookup function please find the attachment.. On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel rushiraj.pa...@in.aegisglobal.com wrote: Dear Experts, ** ** I am using Excel 2003. ** ** I have a file in which I need to bifurcate the figures in different slabs. The Count of slabs goes up to 8. As per the Excel 2003 limitations I am only able to get result till 7th slab and not more than that. ** ** Please guide if there is any way out. Appended the reference files. ** ** ** ** Rgds, ** ** Rushiraj Patel ** ** Save trees. Go Green. -- 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 -- Sam Mathai Chacko -- 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 image006.jpgimage007.jpg
Re: $$Excel-Macros$$ Search an fill combobox
The ComboBox1_Change event is designed to work that way. Stop using the change event for this. Each time you type a letter, there is an event triggered. If you do not want to search to be triggered, why don't you use a button click for this. Type in the name in the combobox, and then click the button to do the search. Regards, Sam Mathai Chacko On Wed, Mar 7, 2012 at 8:56 PM, Joaowild joaow...@gmail.com wrote: Hi. Someone help with this: I have a book with aprox 20 sheets, many products are included. Well i need a search a defined product from combobox inside a userform, but when i write the first letter the macro run and don't let me write the others. I tried to put a delay but doesn't work. If you can help me?, Please Private Sub ComboBox1_Change() Dim Producto As String Dim SheetCount As Integer Dim counter As Integer Dim currentSheet As Integer Producto = ComboBox1.Value Application.ScreenUpdating = False On Error Resume Next currentSheet = ActiveSheet.Index For counter = 1 To 20 Sheets(counter).Activate Cells.Find(What:=Producto, After:=ActiveCell, LookIn:=xlValues, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ComboBox1.AddItem ActiveCell.Value Cells.FindNext(After:=ActiveCell).Activate ComboBox1.AddItem ActiveCell.Value If ComoboBox1.Value Producto Then ComboBox1.RemoveItem (ComboBox1.Value Producto) End If Next counter If you need more information please contact contact me Thanks -- 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 -- Sam Mathai Chacko -- 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$$ Error in condition of particular data receive from another sheet
=IFERROR(INDEX(Sheet2!$C$2:$C$15,SMALL(IF(IFERROR(SEARCH(Report!$B$32,Sheet2!$A$2:$A$15,1),0)0,ROW(Sheet2!$C$2:$C$15)-1,),ROW()-33)),) Regards, Sam Mathai Chacko On Wed, Mar 7, 2012 at 9:49 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: -- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Mar 6, 2012 at 9:44 AM Subject: $$Excel-Macros$$ Error in condition of particular data receive from another sheet To: excel-macros@googlegroups.com Dear expert, There are problem in my condition in attached file of Condition Problem sheet. I want same type of condition which written in another attached sheet of List Box like Tally. I require the data from another sheet (Sheet2) of only which match with date, mention in cell B32. Please tell me what is wrong in my condition. 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 -- Sam Mathai Chacko -- 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$$ Exl Adds-in or any software for doing data reconciliations
When you say data reconciliation, do you mean data comparison across sheets? Or is that consolidation? For the former, there's a sheet comparer add-in available on the net, if you search for it. Sam On Wed, Mar 7, 2012 at 5:24 PM, Pranab Brahmangaonkar b.pra...@gmail.comwrote: Hi friends, Please help me if you are using a any excel adds-in or any software for data reconciliation. Warm regards, --- *Pranab A Brahmangaonkar* Pune, India. Mobile + 91 9822445858 -- 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 -- Sam Mathai Chacko -- 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$$ conditinal formatting - based on date col.....(plz help)
Dear Sam, I want to know on this particular date how many people took the medicines and what's their badge no's. (only to differentiate them from other dates). Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date col.(plz help) :) I understand that! I am asking for the logic Regards, Sam On Thu, Mar 8, 2012 at 12:26 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Sam, Thanx for reply, Conditional formatting to change the color. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, March 08, 2012 9:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ conditinal formatting - based on date col.(plz help) A few rows on the top has a logic that is different from the logic in a few rows below. Either that, or I am not able to understand your conditional format rule. Please let us know what is the logic used. Regards, Sam On Thu, Mar 8, 2012 at 11:36 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Friends plz, formula through conditional formatting can be applicable. Now I am doing it manually everytime the date change. 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 -- Sam Mathai Chacko -- 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 -- Sam Mathai Chacko -- 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
Re: $$Excel-Macros$$ need help to make compare sheet plz
please send the sheet with example On Tue, Mar 6, 2012 at 6:14 AM, sherif azat sherifazat...@hotmail.comwrote: what i want in the sheet -- 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$$ Excel Macro Code Request for List files and Move specified directory
Dear all, Please find below is my request to create macro code: Step1: Browse Directory. Step2: List files in above selected directory. Step3: Create directory based on the file Please do not use file extension and it contain same file name with different extension Step4: Move files based on its named directory. Please help us to get this process solution. Please let me know if you have any clarifications in this regard. * * -- 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 directorycreation.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Help
Thank You Regards karthik.N On Thu, Mar 8, 2012 at 9:56 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: see attached sheet.. On Wed, Mar 7, 2012 at 3:12 PM, karthik N n.karthi...@gmail.com wrote: Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- 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://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 -- *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
Re: $$Excel-Macros$$ Unlist - Table to be constant for every macro to run
*osh.ListObjects(1).UnList* Regards Sam Mathai Chacko On Wed, Mar 7, 2012 at 12:34 AM, dguillett1 dguille...@gmail.com wrote: try Sub removetableSAS() dim i as integer for i = 1 to 3 activesheet. osh.listobjects(Table i ).unlist next i End sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* yogananda muthaiah yogananda.mutha...@gmail.com *Sent:* Tuesday, March 06, 2012 11:38 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Unlist - Table to be constant for every macro to run * 1. Hi, I am running several times of same macro with listobjects .unlist where Table1 is not constant. it keeps changing when i run the same macro again.. Please anyone help me to make table as constant. (Table1) --- 1st time (Table2) --- 2nd time (Table3) ---3rd time here is the code Sub removetable() Dim osh as worksheet set osh=activesheet osh.listobjects(Table1).unlist End sub * 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 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 -- Sam Mathai Chacko -- 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