Re: $$Excel-Macros$$ Re: listbox issue
thanks Mate really nice solution. regards, Pawel From: Bé Trần Văn betnmtdongna...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, August 26, 2013 2:49 PM Subject: Re: $$Excel-Macros$$ Re: listbox issue You reference List Box in User Form follows: - To enter data into the spreadsheet, click on the list box to get the data into the appropriate form, edit the content and press Enter to edit data. - To edit data, click on the list box to be modified to take the form data, edit the content and press the edit button to edit the data. - Do not click in the blank area below the list Box, because there is no data in the Form Load will fail, press the End button to exit the error. 2013/8/26 pawel lupinski lupins...@yahoo.com Hi All, unfortunately workbook is too big to share, but I've done some something (below): ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoFalse ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoTrue this is working, but still not perfect. problem is that something (macros) switching off/hiding listbox. Thanks for support Pawel From: Prince prince141...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Monday, August 26, 2013 8:05 AM Subject: Re: listbox issue Hi Pawel, Pls shere your workbook. Regards Prince On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote: Hi All, I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is placed is fine, but when I run any macro that is going to different sheets suddenly is becoming disable. in order to activate it I need to switch design mode click on list box and switch off design mode again. its extremely irritating do you know what I need to do to be able use it without such combination. Regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to mailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs
$$Excel-Macros$$ Re: listbox issue
Hi All, unfortunately workbook is too big to share, but I've done some something (below): ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoFalse ActiveSheet.Shapes.Range(Array(ListBox2)).Visible = msoTrue this is working, but still not perfect. problem is that something (macros) switching off/hiding listbox. Thanks for support Pawel From: Prince prince141...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Monday, August 26, 2013 8:05 AM Subject: Re: listbox issue Hi Pawel, Pls shere your workbook. Regards Prince On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote: Hi All, I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is placed is fine, but when I run any macro that is going to different sheets suddenly is becoming disable. in order to activate it I need to switch design mode click on list box and switch off design mode again. its extremely irritating do you know what I need to do to be able use it without such combination. Regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ listbox issue
Hi All, I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is placed is fine, but when I run any macro that is going to different sheets suddenly is becoming disable. in order to activate it I need to switch design mode click on list box and switch off design mode again. its extremely irritating do you know what I need to do to be able use it without such combination. Regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ check date on open file
Hi All, is anyone can help me on this: I'd like to run macro base on following criteria: when I open file, macro is checking today's date and if today is greater than e.g. 18/08/2013 macro is execution another code. if anyone give me some few lines of the code I'll be appreciated. Regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ check date on open file
thanks Mate working great. regards, Pawel From: De Premor d...@premor.net To: excel-macros@googlegroups.com Sent: Wednesday, August 14, 2013 11:07 AM Subject: Re: $$Excel-Macros$$ check date on open file Try This Private Sub Workbook_Open() If Now() #8/18/2013# Then AnotherCode Else CurrentCode End If End Sub Sub AnotherCode() MsgBox This Your Another Code End Sub Sub CurrentCode() MsgBox This Your Current Code End Sub On 14-08-2013 16:45, pawel lupinski wrote: Hi All, is anyone can help me on this: I'd like to run macro base on following criteria: when I open file, macro is checking today's date and if today is greater than e.g. 18/08/2013 macro is execution another code. if anyone give me some few lines of the code I'll be appreciated. Regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ weather forecast
Hi All, quick question is anybody know how to download weather forecast (7/10 days) into excel. link / web site? regards, Pawel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ undo macro
Hi All, I've macro like: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range(B23:HH400)) Is Nothing Then ActiveWorkbook.Names(ActiveRow).RefersTo = = ActiveCell.Row End If End Sub unfortunately I can't undo any changes. Is the anyway I can undo changes that I will do in cells? Regards, Pawel -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ need formula please
your file (it's working only on one condition, that you account_no column is SORTED!!!) I didn't want to advice you to do pivot table as per request function. awel From: raghunandan rallapalli raghunandan.rallapa...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, December 11, 2012 12:29 PM Subject: $$Excel-Macros$$ need formula please sir, I need a formula for total sum of each account no wise as given in excel sheet. Thanks in advance please. Raghu Nandan R-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. sum.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ multiple parameters function VBA
Hi All, I'd like to create function that will check for me if the cell in the row has value below 0. The issue of mine is that lookup value is not cosistly in the same column. so could be like this: I'm looking value in column C then F them Z then AC so there is not real sequence for it. Function Check(...Vvalue, Vvalue1,) Dim a As Integer '- amount Vvalue that I'd like to check Dim Vvalue As Double For a = 1 To 100 If Vvalue 0 Then End If a=a+1 End If ActiveCell = a End Function Please see attachement should be more clear. Regards, Pawel -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. findvaluelessthenzero.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ multiple parameters function VBA
ok I've got it Function XOf(ParamArray Nums() As Variant) As Variant '' ' Add up the numbers in Nums '' Dim N As Long Dim D As Double For N = LBound(Nums) To UBound(Nums) If Nums(N) 0 Then Exit For End If Next N XOf = N + 1 End Function From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, December 5, 2012 11:38 AM Subject: $$Excel-Macros$$ multiple parameters function VBA Hi All, I'd like to create function that will check for me if the cell in the row has value below 0. The issue of mine is that lookup value is not cosistly in the same column. so could be like this: I'm looking value in column C then F them Z then AC so there is not real sequence for it. Function Check(...Vvalue, Vvalue1,) Dim a As Integer '- amount Vvalue that I'd like to check Dim Vvalue As Double For a = 1 To 100 If Vvalue 0 Then End If a=a+1 End If ActiveCell = a End Function Please see attachement should be more clear. Regards, Pawel-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ multiple parameters function VBA
Paul, Thanks for reply. Yes I have couple problems :) 1. file is too big to send. 2. I've found solution (secound email) I've tried to resolve problem with the procedure that you've made for me before, but for this instant I've done something different. 3. now I've got different issue I'd like to run this function only for single row (it'll be consuming too much time if I'll be running it for all cells) regards, Pawel PS UK not US :) From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Wednesday, December 5, 2012 12:50 PM Subject: Re: $$Excel-Macros$$ multiple parameters function VBA Pawel, We've got a couple of problems here. (I guess that's why you came to US, right?) The first problem is going to be that will need help understanding your data. If you only want to check specific columns (C, F, Z, AC) then we can do that. But if you want to look in the entire range, say: from column B to AZ and try to locate the first value less than 0, then we can do that. It would actually be EASIER to check the entire range. next.. What you're trying to do with the function: Function Check(...Vvalue, Vvalue1,) is pretty convoluted. TECHNICALLY, you have to have a FIXED number of arguments passed to a function. You can CHOOSE to make some optional. but you still have to define them: Function Check(Vvalue1, Vvalue2, Vvalue3, optional Vvalue4) Now, if you REALLY want to be able to use a variable number of arguments, the it IS possible to define an array argument, but then you have to enter your cell values as an array, which isn't done simply. --- next: I think your sample function was simply an example and not what you were intending... I'm not sure if you need some help with loops, but here's some pointers. your For loop should look like: For a = 1 To 100 ... Next a you should NOT put a line like a=a+1 within the loop, because the For... statement will increment the counter (a) by 1 for each loop. If you put a=a+1 inside the loop, it will be incremented TWICE. Next, to break out of the loop, you would put Exit For not End If. -- Since you said that using your sample data, you expected a return value of (4), then I assume that you want a COUNT of the number of values, not the COLUMN that contains the value. What I would suggest is a function that looks like: == Public Function Check(Rng As Range) Dim tRng, vCnt vCnt = 0 For Each tRng In Rng If tRng.Value Then vCnt = vCnt + 1 If (tRng.Value 0) Then Exit For End If Next tRng Check = vCnt End Function == This would need to go into a standard module rather than a sheet module. In your sample file, you would put in Cell A3: =check(B3:AZ3) let me know if this is what you are looking for. 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: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wed, December 5, 2012 6:38:42 AM Subject: $$Excel-Macros$$ multiple parameters function VBA Hi All, I'd like to create function that will check for me if the cell in the row has value below 0. The issue of mine is that lookup value is not cosistly in the same column. so could be like this: I'm looking value in column C then F them Z then AC so there is not real sequence for it. Function Check(...Vvalue, Vvalue1,) Dim a As Integer '- amount Vvalue that I'd like to check Dim Vvalue As Double For a = 1 To 100 If Vvalue 0 Then End If a=a+1 End If ActiveCell = a End Function Please see attachement should be more clear. Regards, Pawel-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros
Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *
Paul - congratulation !!! Pawel From: resp...@gmail.com resp...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, December 3, 2012 9:55 PM Subject: Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 * I couldn't agree more. Thumbs up Paul. Great to be associated with you. Sent from my BlackBerry® smartphone from Airtel Ghana From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 +0530 To: excel-macrosexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 * This message is eligible for Automatic Cleanup! (jainayus...@gmail.com) Add cleanup rule | More info -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ sum base on condition
Hi All, Can you help me on this example. I’m looking for excel function that will be summarized what I have to buy and I’ve bought already. I have table with requirements. On this base I’m ordering components from different suppliers. For my budget I need to know how much I’ve already paid and how much I’m going to pay. I need to have a function that will tell me if e.g. row order I have order number it should be count as order already placed if not should be count as “not order”. Thanks for help Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Book2.xlsx Description: Binary data
$$Excel-Macros$$ run macro from another file
Hi All, I'd like to ask you for help. I'd like to run macro from different file. So I have master file where I have all data, this data a copied to another file and after that macro need to be run. issue is: each day name of the file is different so I can use stable one like Application.Run 'aaa.xls'!macro each day can be different so I can have: Application.Run 'day1.xls'!macro Application.Run 'day2.xls'!macro Application.Run 'day3.xls'!macro . I need solution to be able to open file and run specific macro in this file. Any solution please Regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ run macro from another file
ok found it http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=210201 From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, November 8, 2012 1:34 PM Subject: $$Excel-Macros$$ run macro from another file Hi All, I'd like to ask you for help. I'd like to run macro from different file. So I have master file where I have all data, this data a copied to another file and after that macro need to be run. issue is: each day name of the file is different so I can use stable one like Application.Run 'aaa.xls'!macro each day can be different so I can have: Application.Run 'day1.xls'!macro Application.Run 'day2.xls'!macro Application.Run 'day3.xls'!macro . I need solution to be able to open file and run specific macro in this file. Any solution please Regards, Pawel-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ execute macro on delate
Hi All, I need your help on this. I'd like to run macro when I delate value from the cell. So I pushing delate and macro run. I couldn't find anything on the web so if you can help me on this. regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ execute macro on delate
Hi All, I should attached file with it. about te file - this simple calculator for stock week cover. So input figure in columns input and calculate you number of weeks cover. With this file I have 2 problems to resolve: I've made simple macro to calculate week covers (when you inset value in column C in column D macro calculate weeks: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The variable KeyCells contains the cells that will ' cause an macro run when they are changed. Set KeyCells = Range(c3:c300) If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then ' designated cells has been changed. Call WeekStock End If End Sub Sub WeekStock() Dim a As Integer, number As Integer a = ActiveCell.Column + 3 Do Until number = 12 If Cells(ActiveCell.Row - 1, a + 5 * number).Value 0 Then Exit Do number = number + 1 Loop Cells(ActiveCell.Row - 1, ActiveCell.Column + 1).Value = number End Sub Problem #1 (delete): when I delete value in cell - macro calculate me number of weeks cover for row above. and I don't know how to right macro that on click will delete value in next column - so remove value in cell (column C) and remove value in cell (column D). Problem #2 (ranges): As you see I've only one range (C3:C300), but I'd like to have multiple e.g. column H, M, R ... etc. Sorry I'm new to VBA and I'll be appreciated for your help Regards, Pawel From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 02 November 2012 5:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ execute macro on delate Hi All, I need your help on this. I'd like to run macro when I delate value from the cell. So I pushing delate and macro run. I couldn't find anything on the web so if you can help me on this. regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
Re: $$Excel-Macros$$ execute macro on delate
Paul, thanks a lot is working as I wanted, it will take me some time to figure it up how is working, but its so gd. Thanks Pawel From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Friday, November 2, 2012 2:12 PM Subject: Re: $$Excel-Macros$$ execute macro on delate I have a couple of solutions for you. (with lessons along the way) First, in the Change Event, Target CAN be more than one cell. For example, if you decide to clear all values in the column, you'd select the range and hit delete. Then, Target becomes an ARRAY of cells. What I like to do is process each cell individually. By using: Dim Targ as Range For Each Targ in Target you can loop through all the cells in the range Target. Whether there's a single cell, or a range of cells. Second, you can test the value of the Target cell. If it's blank, then delete the value in column D of the same row as the Target cell. Otherwise, run your Weekstock macro. Like: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Dim Targ As Range ' The variable KeyCells contains the cells that will ' cause an macro run when they are changed. Set KeyCells = Range(c3:c300) If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then For Each Targ In Target '-- If Targ.Value Then 'Do this if the cell is not blank '-- ' designated cells has been changed. Call WeekStock '-- Else 'Do this if the cell is blank '-- Cells(Targ.Row, D).Value = 'Remove value in Column D End If Next Targ End If End Sub That should address your first issue. To address the second issue: You're using the Intersect method. While this works, there's a simpler method. Simply test the target column to see if it is 3 (for C) However, since you have multiple input columns, I'd suggest testing to see if the column heading says input, then proceed accordingly. Combinine these two techniques, you get: == Private Sub Worksheet_Change(ByVal Target As Range) Dim Targ As Range For Each Targ In Target If (UCase(Cells(2, Targ.Column).Value) = INPUT) Then '-- If Targ.Value Then 'Do this if the cell is not blank '-- Call WeekStock '-- Else 'Do this if the cell is blank '-- Cells(Targ.Row, D).Value = 'Remove value in Column D End If End If Next Targ End Sub 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: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Fri, November 2, 2012 9:20:29 AM Subject: Re: $$Excel-Macros$$ execute macro on delate Hi All, I should attached file with it. about te file - this simple calculator for stock week cover. So input figure in columns input and calculate you number of weeks cover. With this file I have 2 problems to resolve: I've made simple macro to calculate week covers (when you inset value in column C in column D macro calculate weeks: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The variable KeyCells contains the cells that will ' cause an macro run when they are changed. Set KeyCells = Range(c3:c300) If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then ' designated cells has been changed. Call WeekStock End If End Sub Sub WeekStock() Dim a As Integer, number As Integer a = ActiveCell.Column + 3 Do Until number = 12 If Cells(ActiveCell.Row - 1, a + 5 * number).Value 0 Then Exit Do number = number + 1 Loop Cells(ActiveCell.Row - 1, ActiveCell.Column + 1).Value = number End Sub Problem #1 (delete): when I delete value in cell - macro calculate me number of weeks cover for row above. and I don't know how to right macro that on click will delete value in next
$$Excel-Macros$$ stock cover for material requirement
Hi All, I'd like you to help me on stock cover formula that will help me calculate stock coverage. Please look inside the file. regards Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. stock cover.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ macro: delete base on table
Hi Guys, thanks a lot for your help. regards, Pawel From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, October 4, 2012 6:32 PM Subject: FW: $$Excel-Macros$$ macro: delete base on table Here is thread on this Solution , Please visit http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-589/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From:Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 04 October 2012 9:58 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ macro: delete base on table Hi, Use this Code, Just Create Two Name Ranges, Sheet1!B2=”rngRange” Sheet2!B2 =” MapDelete” Sub ExcludeFromList() Dim objDicMap As Object Dim VarArrData Dim VarArrResult Dim rngCell As Range Dim lngCOunt As Long VarArrData = Intersect(Range(rngRange).CurrentRegion, Range(rngRange).CurrentRegion.Offset(1)) Set objDicMap = CreateObject(Scripting.Dictionary) ' Dictionary Object get Mapping 'Filling Dictionary For Each rngCell In Intersect(Range(MapDelete).CurrentRegion, Range(MapDelete).CurrentRegion.Offset(1)) If Not objDicMap.exists(rngCell.Value) Then objDicMap.Add rngCell.Value, rngCell.Value Next rngCell 'Filling Result Array From Data List which would not Include Mapping Data For lngCOunt = LBound(VarArrData) To UBound(VarArrData) If Not objDicMap.exists(VarArrData(lngCOunt, 1)) Then If Not IsArray(VarArrResult) Then ReDim VarArrResult(0 To 0) VarArrResult(0) = VarArrData(lngCOunt, 1) Else ReDim Preserve VarArrResult(UBound(VarArrResult) + 1) VarArrResult(UBound(VarArrResult)) = VarArrData(lngCOunt, 1) End If End If Next lngCOunt 'Clear Old List Range(rngRange).CurrentRegion.Offset(1).Clear 'Replace with new list Range(rngRange).Offset(1).Resize(UBound(VarArrResult)).Value = Application.Transpose(VarArrResult) Set objDicMap = Nothing Set rngCell = Nothing End Sub Keep Excelling J Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 04 October 2012 9:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ macro: delete base on table Hi All, I'd like to ask you for favour, can you help me with these. I have a table code with codes. From this table I'd like to excclude all codes for table to delete (tab table). Right now I'm using or function in vba, but when I want to add something, each time I need to open VB and change it. Is there any way that I can manage it from to delete table? Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post
$$Excel-Macros$$ macro: delete base on table
Hi All, I'd like to ask you for favour, can you help me with these. I have a table code with codes. From this table I'd like to excclude all codes for table to delete (tab table). Right now I'm using or function in vba, but when I want to add something, each time I need to open VB and change it. Is there any way that I can manage it from to delete table? Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. todelete.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ color coding of REPT function
Hi All I wonder if its possible to have color coding on REPT function. e.g. I'd like to have 30 gs in red, 45 gs in green and 25 gs in orange. If you have any ideas I'll be appreciated. Pawel PS. I don't want to use a graph for it. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. REPT function.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: color coding of REPT function
Thanks a lot for that, I didn't thnik is possible but I needed to try. Thanks Pawel From: Vabz v...@vabs.in To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Friday, September 21, 2012 2:01 PM Subject: $$Excel-Macros$$ Re: color coding of REPT function Hi Its not possible i guess.. But you can do with UDF.. for multiple fonts/colours etc in a single cell you use the cells(x,y).characters(start,length).font function The following code makes the first 10 characters BOLD and colour 56 and the rest not bold and colour 12 With Cells(row,col).Characters(start:=1, Length:=10).Font .FontStyle = Bold .ColorIndex = 56 End With With Cells(col,row).Characters(start:=11, Length:=180).Font .FontStyle = Normal .ColorIndex = 12 End With Cheers.. Rgds//Vabs On Friday, September 21, 2012 2:22:21 PM UTC+5:30, lupinskip wrote: Hi All I wonder if its possible to have color coding on REPT function. e.g. I'd like to have 30 gs in red, 45 gs in green and 25 gs in orange. If you have any ideas I'll be appreciated. Pawel PS. I don't want to use a graph for it.-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ hello
this is interesting http://www.newsisto.net/jobs/?article=18116 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ hello
Sorry guys but someone used my nick and send it throught Can admin look at it, please. Real :) Pawel From: pawel lupinski lupins...@yahoo.com To: clai...@rhl.co.uk Sent: Tuesday, September 18, 2012 9:21 AM Subject: $$Excel-Macros$$ hello this is interesting http://www.newsisto.net/jobs/?article=18116 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Sum base on condition in another column
Hi All, I need your help regarding to this: what I want is to sum up column D base on condition in column N. Regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Book2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sum base on condition in another column
thanks a lot, it was briliant. pawel From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, September 18, 2012 5:16 PM Subject: Re: $$Excel-Macros$$ Sum base on condition in another column SUM(SUMIF(C:C,F3:F5,D:D)) press ctrl_+shft +enter On Tue, Sep 18, 2012 at 9:42 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help regarding to this: what I want is to sum up column D base on condition in column N. Regards, Pawel-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ PBefore printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ hide column VBA
Hi All, I wonder if you can help me, I'd like to hide all columns if the value in row 1 is equal 1, I've written code but something is not working. I'm new to VBA so if you can help me. Code is below: Sub HideColumn() Dim a As Integer Range(a1).Select For a = a + 1 To 10 If ActiveCell.Cells(1, a).Value = 1 Then ActiveCell.Columns(1, a).Hidden = True End If Next a End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ hide column VBA
thanks a lot Pawel From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, September 16, 2012 11:48 AM Subject: Re: $$Excel-Macros$$ hide column VBA Sub sample() For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then Cells(1, i).EntireColumn.Hidden = True End If Next End Sub On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I wonder if you can help me, I'd like to hide all columns if the value in row 1 is equal 1, I've written code but something is not working. I'm new to VBA so if you can help me. Code is below: Sub HideColumn() Dim a As Integer Range(a1).Select For a = a + 1 To 10 If ActiveCell.Cells(1, a).Value = 1 Then ActiveCell.Columns(1, a).Hidden = True End If Next a End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ PBefore printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ hide column VBA
thanks Don Pawel As you see I'm not loosing time everyday something new thanks to you mate From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, September 16, 2012 2:24 PM Subject: Re: $$Excel-Macros$$ hide column VBA or one line For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then columns(i).Hidden = True next i Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: ashish koul Sent: Sunday, September 16, 2012 5:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ hide column VBA Sub sample() For i = 1 To ActiveSheet.UsedRange.Columns.Count If Cells(1, i).Value = 1 Then Cells(1, i).EntireColumn.Hidden = True End If Next End Sub On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I wonder if you can help me, I'd like to hide all columns if the value in row 1 is equal 1, I've written code but something is not working. I'm new to VBA so if you can help me. Code is below: Sub HideColumn() Dim a As Integer Range(a1).Select For a = a + 1 To 10 If ActiveCell.Cells(1, a).Value = 1 Then ActiveCell.Columns(1, a).Hidden = True End If Next a End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ PBefore printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ macro for detecting date in row
Paul, It's great this what I wanted Thank you so so so so much Pawel From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Tuesday, August 14, 2012 12:22 PM Subject: Re: $$Excel-Macros$$ macro for detecting date in row Ahh... I see what you're trying to do. Your worksheet has formulas. on any given day, you want to freeze the previous values so that they will no longer update. You PROBABLY only need to freeze the current date, because yesterday's data would have been frozen yesteday, and the day before that was frozen then, and so on. however, this macro should do what you asked: Sub Freeze_Values() Dim C, nCols nCols = ActiveCell.SpecialCells(xlLastCell).Column For C = 1 To nCols If (IsDate(Cells(6, C).Value)) Then If (DateDiff(D, Cells(6, C).Value, Now()) = 0) Then Range(Cells(1, 1), Cells(1, C)).EntireColumn.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Cells(6, C).Select Exit For End If End If Next C End Sub 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: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Mon, August 13, 2012 7:36:01 PM Subject: $$Excel-Macros$$ macro for detecting date in row Hi All, I'd like to have a macro that will detect curent date (eg in column H) then copy all all columns from A to column H (column H excuded so range A:G) and paste all these column as value Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7
$$Excel-Macros$$ macro for detecting date in row
Hi All, I'd like to have a macro that will detect curent date (eg in column H) then copy all all columns from A to column H (column H excuded so range A:G) and paste all these column as value Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. datemacro.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ formula base on condition
Don/Prince, Thanks a lot pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 8, 2012 8:15 PM Subject: Re: $$Excel-Macros$$ formula base on condition =IF(AND(LEN(D3)LEN(M3),RIGHT(D3,8)=RIGHT(M3,8)),L3,) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, August 08, 2012 12:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula base on condition Hi All, I'm looking for formula that will be checking cell base on the condition that last 8 digits will be match, with 8 digits from different cell. Pls see attachement. Regards, Pawel-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ formula base on condition
Hi All, I'm looking for formula that will be checking cell base on the condition that last 8 digits will be match, with 8 digits from different cell. Pls see attachement. Regards, Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. additiona zero added.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help
I've just send you. Thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, August 7, 2012 7:49 PM Subject: Re: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help Or, if you do not know the name ON the shape and you don’t have the row in column C This gets the name and finds it in col c and uses the col d value in that row. Sub fillcolorSAS() Dim shp As Shape Dim mn As String Dim mr As Long With ThisWorkbook.Worksheets(sheet1) On Error Resume Next For Each shp In .Shapes mn = shp.TextFrame.Characters.Text mr = .Columns(C).Find(What:=mn, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False, _ SearchFormat:=False).Row shp.Fill.ForeColor.RGB = .Cells(mr, d).Interior.Color Next shp End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Prince Dubey Sent: Tuesday, August 07, 2012 12:46 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help Hi JP Please see the attachment. regards prince On Tuesday, August 7, 2012 2:30:26 PM UTC+5:30, Jayaprakash S wrote: Dear Experts, Good Noon. Need help in auto filling of Colours to the shapes as well attached excel sheet for more information. Kindly Help advise. Thank you. JP. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ copy color from cell base on condition formating
Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com colour_for_condition_formating.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ copy color from cell base on condition formating
Joseph, paste special is not workig as its refering to different sheet Regards, Pawel From: joseph.cam...@gmail.com joseph.cam...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, July 16, 2012 3:41 PM Subject: Re: $$Excel-Macros$$ copy color from cell base on condition formating Please try paste special format Sent on my BlackBerry® from Vodafone From: pawel lupinski lupins...@yahoo.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 07:38:57 -0700 (PDT) To: excel-macros@googlegroups.comexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy color from cell base on condition formating Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: copy color from cell base on condition formating
Hi Prince, Unfortunatelly I think as well that the macro is the only one solution for this, but is outside of my confort zone. Thanks anyway Pawel From: Prince Dubey prince141...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Monday, July 16, 2012 5:21 PM Subject: $$Excel-Macros$$ Re: copy color from cell base on condition formating Hi Pawel, In case of conditional formatting we can not refer other sheet. So for this problem you can use macro. regards prince dubey. On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote: Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ macro with multiple rows
Hi DON, so what I need is check if in eg cell M10 is function (not empty cell) copy this function to column O:DO ( the same row ) and after calculation copy range O:DO and paste as a text. and make a loop ... cell M11 ... M12 ... and so on, if you can help me I will be appreciated. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, July 14, 2012 5:24 PM Subject: Re: $$Excel-Macros$$ macro with multiple rows I do NOT understand your need. Give examples if M___? is __then copy the VALUES to col O:DO etc Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Saturday, July 14, 2012 9:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ macro with multiple rows Sorry All correct file Hi All, I'd like to ask you help me with writting macro, problem is I've no idea how to do it? In column M there are functions (colour in white) that need to be copied accross rows (started from column O), but only these functions. When in column M there is nothing macro should be checking next cell in column M. Macro should be copied function (from column M) accross columns O to column DO, and after that save results as text. So for the future use I'd like to add additional product and macro will doing the same for this additional items. Please if you can check and help me in this. Regards, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ macro with multiple rows
Don, ok I've removed all unneccessery values. So when the macro will find NOT blank cell should be executed. as you see this is a forecast file so people will fill it in advance. refering to hirring, so maybe in the future (as a immigrent in different country I'm not getting as much) right now as you can see whole Saturday I'm sitting at home on the computer and try to do something to imprese employer and in the near future be promoted. 2 months ago you've told me to get the book and learn. I've done it. Bought a book for excel, and learning from this forum. Next step will be a book for VBA, but still not there. If can help me will be great. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, July 14, 2012 7:42 PM Subject: Re: $$Excel-Macros$$ macro with multiple rows There are some cells in column M that are NOT blank (contain values) but are NOT formulas. So, please clarify It seems that it is not necessary to fill in all of the cells in a column until data from that column is needed. So, a “worksheet_change” event macro that fires upon some cell changing may be more appropriate. Is this a project you want me to do for free or for hire? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Saturday, July 14, 2012 11:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro with multiple rows Hi DON, so what I need is check if in eg cell M10 is function (not empty cell) copy this function to column O:DO ( the same row ) and after calculation copy range O:DO and paste as a text. and make a loop ... cell M11 ... M12 ... and so on, if you can help me I will be appreciated. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, July 14, 2012 5:24 PM Subject: Re: $$Excel-Macros$$ macro with multiple rows I do NOT understand your need. Give examples if M___? is __then copy the VALUES to col O:DO etc Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Saturday, July 14, 2012 9:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ macro with multiple rows Sorry All correct file Hi All, I'd like to ask you help me with writting macro, problem is I've no idea how to do it? In column M there are functions (colour in white) that need to be copied accross rows (started from column O), but only these functions. When in column M there is nothing macro should be checking next cell in column M. Macro should be copied function (from column M) accross columns O to column DO, and after that save results as text. So for the future use I'd like to add additional product and macro will doing the same for this additional items. Please if you can check and help me in this. Regards, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1
$$Excel-Macros$$ long opening file on the external server
Hi All, I need your help on this issue. I have quite big file (21MB) that is doing a lot of calculation between tabs, in order to run this file more efficient I've switch off calculation, and I'm switch it on when needed. When I've done this file on my computer its opening slowly but not so bad 10 sec. The problem is: when I've put this file on company server for other users its a nightmare. Yesterday I've been waiting to open about 6-10 min!!! I've checked this on different workstation and the same opening time unbelievable. Do you have any thoughts? How Can I change this? What can improve it? Need your help Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ long opening file on the external server
I'd like to do this but my knowladge is still not there, sad but true. Maybe some other solution, please. Regards, Pawel From: Divaker Pandey divake...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, July 13, 2012 9:40 AM Subject: Re: $$Excel-Macros$$ long opening file on the external server try to calculate required calculation with the help of macros. Divaker On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help on this issue. I have quite big file (21MB) that is doing a lot of calculation between tabs, in order to run this file more efficient I've switch off calculation, and I'm switch it on when needed. When I've done this file on my computer its opening slowly but not so bad 10 sec. The problem is: when I've put this file on company server for other users its a nightmare. Yesterday I've been waiting to open about 6-10 min!!! I've checked this on different workstation and the same opening time unbelievable. Do you have any thoughts? How Can I change this? What can improve it? Need your help Pawel -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ switch on anf off calculation
Hi Don, Thanks a lot for this, Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 1:13 PM Subject: Re: $$Excel-Macros$$ switch on anf off calculation sub yourmacro() Application.Calculation=xlCalculationManual your macro Application.Calculation=xlCalculationautomatic end sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, July 11, 2012 1:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ switch on anf off calculation Thanks for that but how to do this ? how to set it up, sorry but not very good at it, I've just started to learn VB. Can you help me? Thanks Pawel From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 3:05 AM Subject: Re: $$Excel-Macros$$ switch on anf off calculation Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ switch on anf off calculation
Thanks for that but how to do this ? how to set it up, sorry but not very good at it, I've just started to learn VB. Can you help me? Thanks Pawel From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 3:05 AM Subject: Re: $$Excel-Macros$$ switch on anf off calculation Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ switch on anf off calculation
Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12)
Congrats Rajan Pawel From: Aamir Shahzad aamirshahza...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, July 4, 2012 7:18 PM Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12) Congrats Rajan Aamir Shahzad On Wed, Jul 4, 2012 at 10:55 PM, Maries talk2mar...@gmail.com wrote: Congrats Rajan... On Wed, Jul 4, 2012 at 9:53 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Congrats Rajan... On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 dguille...@gmail.com wrote: Congratulations from Austin Texas Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Wednesday, July 04, 2012 11:16 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12) Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of June'2012. This is third time in row. :) He has posted 149 posts in June 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job. Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager , Microsoft MVP-- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari http://www.noorainansari.com/ www.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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- MARIES Excel Inspiration -- 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
Re: $$Excel-Macros$$ sum base on 8 digits code
Hi Noorain, Full respect, great solution, many thanks Pawel From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, July 5, 2012 4:10 AM Subject: Re: $$Excel-Macros$$ sum base on 8 digits code Hi Lupinski, Please use it.. =SUMIF($E$5:$E$23,B4*,$F$5:$F$23) see attached sheet. -- Thanks regards, Noorain Ansari http://www.noorainansari.com/ www.excelmacroworld.blogspot.com On Thu, Jul 5, 2012 at 1:55 AM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help on this particular task. Does anyone know how to add up this value? I have bigger table that I need to add all codes started with first the same 8 digits rest of the digits are not important as this is only combination of the main first 8. I hope that I didn't over complicated this example. Main thing is that the function need to find code started with (codes) in column B and add them up. I'll be grateful if you can help me. Pawel -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Graph with radio button
Hi Rajan, is there any chance, that you can explain me how you've done it? Regards, Pawel From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, June 4, 2012 2:11 PM Subject: RE: $$Excel-Macros$$ Graph with radio button HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Gawli Sent: 04 June 2012 2:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Graph with radio button See the attached data Regards, Gawli Anil On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Maries, Thankyou for your early response. I want to show only the list of people who are available. I mean when I will select team 1 then the graph should show only the data for the three people and no zero's . Hope I am clear with query. Regards Santosh santoshkumar.subu...@gmail.com From: talk2mar...@gmail.com Date: Mon, 4 Jun 2012 02:01:14 -0700 Subject: Re: $$Excel-Macros$$ Graph with radio button To: excel-macros@googlegroups.com Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, I want to create a graph which will show the work performance of different teams as and when they are selected. Attached is the sample sheet for your easy reference. -- Regards Santosh santoshkumar.subu...@gmail.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- MARIES Excel Inspiration -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards Santosh santoshkumar.subu...@gmail.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulation Rajan Verma, thanks for support. Regards, Pawel From: Prajakt Pande prajakt.pa...@gmail.com To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI noorain.ans...@gmail.com; jainayus...@gmail.com; Don Guillett dguille...@gmail.com; Marieswaran Smw talk2mar...@gmail.com; a...@lovetour.info Sent: Sunday, June 3, 2012 6:58 PM Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) Dear all, Dear Rajan Verma congratulation being a 'Most Helpful Member' for the month of May'2012 and also thanks to all members like Noorain sir, Don sir, Asa sir, Maries sir, etc... Also special thanks to Ayushji for being a most helping to new learners. Thanks Regards, Prajakt Pande +971551388482 On Sun, Jun 3, 2012 at 9:42 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ counting E in the column
I also like your solution :) Thanks a lot working great. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, June 3, 2012 7:56 PM Subject: Re: $$Excel-Macros$$ counting E in the column This yields 27 =SUMPRODUCT((RIGHT(B3:B17,1)=e)*(C3:H170)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Sunday, June 03, 2012 1:41 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ counting E in the column Dear All, I need your help with following. I'd like to count apperiance of numbers bigger then 0 and having in product code E at the end. See attachment. Regarrds, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ adjusting graph
Hi Don, Thanks a lot its working great. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 30, 2012 2:02 PM Subject: Re: $$Excel-Macros$$ adjusting graph Define a name such as mydata =OFFSET(Arkusz2!$B$9,0,0,1,COUNTA(Arkusz2!$8:$8)) and use that in the source Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Tuesday, May 29, 2012 7:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ adjusting graph Dear All, I have a problem with adjusting graph, if you can look inside the file and advice I'll be appreciated. Regards, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ adjusting graph
Sorry I've check this again, I have a problem: whenever I'm adding new week graph is not expanding. Can you help me please. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 30, 2012 2:02 PM Subject: Re: $$Excel-Macros$$ adjusting graph Define a name such as mydata =OFFSET(Arkusz2!$B$9,0,0,1,COUNTA(Arkusz2!$8:$8)) and use that in the source Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Tuesday, May 29, 2012 7:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ adjusting graph Dear All, I have a problem with adjusting graph, if you can look inside the file and advice I'll be appreciated. Regards, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ adjusting graph
Guys, I know where I've made mistake, thanks a lot again Pawel From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 30, 2012 3:11 PM Subject: Re: $$Excel-Macros$$ adjusting graph check the attachment see if it helps . i have used the same formula provided by Don On Wed, May 30, 2012 at 7:28 PM, dguillett1 dguille...@gmail.com wrote: glad to help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, May 30, 2012 8:43 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ adjusting graph Hi Don, Thanks a lot its working great. Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 30, 2012 2:02 PM Subject: Re: $$Excel-Macros$$ adjusting graph Define a name such as mydata =OFFSET(Arkusz2!$B$9,0,0,1,COUNTA(Arkusz2!$8:$8)) and use that in the source Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Tuesday, May 29, 2012 7:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ adjusting graph Dear All, I have a problem with adjusting graph, if you can look inside the file and advice I'll be appreciated. Regards, Pawel-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ MACRO
Hi Noorain Please send the files thanks Pawel From: Aruna jayaram aruna2...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, May 29, 2012 8:29 PM Subject: Re: $$Excel-Macros$$ MACRO Hi Noorain Please send the files for excel 2007. thanks On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular basis. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear All, I want to learn MACRO's from basic so kindly give me some material for the same. Thanks Regards, K SAGAR -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ problem with indirect function
thanks a lot Noorain this is what I was looking for Pawel From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, May 28, 2012 9:19 AM Subject: Re: $$Excel-Macros$$ problem with indirect function On Mon, May 28, 2012 at 1:48 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Pawel, Please try this one. =INDIRECT(ADDRESS(MATCH($B6,INDIRECT(G$4!$B:$B),0),12,1,0,G$4),FALSE) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 28, 2012 at 3:42 AM, pawel lupinski lupins...@yahoo.com wrote: Dear All, I have problem with indirect function in this case is working fine (see attachment), but if you can show me some extra features I'll be appreciated. Regards, Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ help needed - VBA
Hi All, I'm new to macros so I'd like to ask you for advice. Can you look at code below and help me to improve. What I'd like to do is make changes to BOLDED line (Windows(LowRisk EPlan SAUCE week 19.xls).Activate) in order to activeted open file (in this case file is called LowRisk EPlan SAUCE week 19.xls). Sub sauce_data_FRI_AMPM() Workbooks.Open Filename:=R:\Planning\Sauce Plan - New.xls, ReadOnly:=True Sheets(SaucePlan).Select Range(E6:H101).Select Selection.Copy Windows(LowRisk EPlan SAUCE week 19.xls).Activate Range(W6).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Windows(Sauce Plan - New.xls).Activate ActiveWindow.Close savechanges:=False Range(C3).Select End Sub Regards, Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ change color depending from cell value
Thanks a lot for this but what if there will be more then 1 empty cells e.g. gap will be 4 cells. See attachment. regards, Pawel From: Shaik Waheed waheedb...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, April 30, 2012 9:31 AM Subject: Re: $$Excel-Macros$$ change color depending from cell value Hi, PFA On Mon, Apr 30, 2012 at 5:11 AM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I'm asking you for help, I have a problem with compering two cells base on conditions. There is no problem if everything is running in order, but if there is a gap ... there is wrong answer given, pls see attachment and if you can advice I'll be appreciated. Regards, Pawel-- 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 red_to_green.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ change color depending from cell value
Hi All, I'm asking you for help, I have a problem with compering two cells base on conditions. There is no problem if everything is running in order, but if there is a gap ... there is wrong answer given, pls see attachment and if you can advice I'll be appreciated. Regards, Pawel -- 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 red_to_green.xlt Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ sequence help needed
Haseeb / Maries thank you very much I can always count on you both. It realy help me a lot. Thanks a lot. Pawel From: Haseeb A haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, April 23, 2012 4:59 PM Subject: Re: $$Excel-Macros$$ sequence help needed Hello Maries, a good one :) unfortunately, I don't think this works. If you enter 10 11 in V10 V11 respectively, you can see what I mean. (1 cell manually entered consecutively) Hello Pawel, One way is use an Array formula. In B6 enter your starting number, then in B7 with CTRL+SHIFT+ENTER, rather than just ENTER. =MIN(IF(ISNA(MATCH((ROW(B$5:B6)-ROW(B$5))+1,B$6:B6,0)),(ROW(B$5:B6)-ROW(B$5))+1)) Then drag down. See the attached. Regards, Haseeb -- 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$$ format cell
Hi All, Can you help me with cell format I need to format it in the way that should change input 0204177 to R0204177, but the difficult of my is that number of digit can be vary from 6 to 7. Please see inside the file. Regards, Pawel -- 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 format_cell.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ format cell
Hi All, thanks a lot for everyone for such quick reply, working great. Asa, yours is the simplest I go for it, thanks a lot to all. Thanks Pawel From: Asa Rossoff a...@lovetour.info To: excel-macros@googlegroups.com Sent: Wednesday, April 4, 2012 10:20 AM Subject: RE: $$Excel-Macros$$ format cell Hi Pawel, You can use the following number format: \R@ That formats the cells as text and includes the leading R. Type as manby digits as you like, including leading zeroes, and they will be preserved. Asa From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: Wednesday, April 04, 2012 2:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ format cell Hi All, Can you help me with cell format I need to format it in the way that should change input 0204177 to R0204177, but the difficult of my is that number of digit can be vary from 6 to 7. Please see inside the file. Regards, Pawel -- 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$$ To calculate the maximum and minimum appearance in Staff Roster Plan
I realy don't know what are you looking for so check if this is what you are looking for. Regards, Pawel From: Darwin Chan darwin.chankaw...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, April 3, 2012 12:02 PM Subject: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan Dear all, I have a roster with staff allocated on different roster plan, i.e. different working hours. I have a task to analyse the maximum and minimum of staff who would appear at concurrent period. However, volume of data is huge and formula is needed for assistance in analysis. I have attached one file for simplicity. Any help would be appreciated. -- 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 Analysis%20on%20roster%20plan(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: format a cell
HI ALL in first words I'd like to thanks you all ever so much for so many replies. Its great to see how many different (great) solution is for one query. I've learn a lot and I'm so thankful for your help. I'll try all your helpful solution. Again thanks a lot. Pawel From: Haseeb A haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Sunday, April 1, 2012 7:42 PM Subject: $$Excel-Macros$$ Re: format a cell Hello Pawel, Another one. =TEXT(A1*IF(ISNUMBER(FIND(.,A1)),100,1),00\:00) If you want to enter 2 for 2'O clock enter as 200 or cell format as text then enter like 2.00 ___ HTH, Haseeb -- 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: format a cell
Hi Again, Thanks again, it's all working, I have a lot to learn what is great, you've shown me the magic. thanks Pawel From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sunday, April 1, 2012 10:45 PM Subject: Re: $$Excel-Macros$$ Re: format a cell HI ALL in first words I'd like to thanks you all ever so much for so many replies. Its great to see how many different (great) solution is for one query. I've learn a lot and I'm so thankful for your help. I'll try all your helpful solution. Again thanks a lot. Pawel From: Haseeb A haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Sunday, April 1, 2012 7:42 PM Subject: $$Excel-Macros$$ Re: format a cell Hello Pawel, Another one. =TEXT(A1*IF(ISNUMBER(FIND(.,A1)),100,1),00\:00) If you want to enter 2 for 2'O clock enter as 200 or cell format as text then enter like 2.00 ___ HTH, Haseeb -- 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$$ format a cell
Maries, this is great, realy simplistic working fine, but what I find out today is that people have tendency to input 2.3 what means 02:30 but formula exchanging it to 00:23 can you help me on this? I've done something like that: =IF(ISERROR(LEN(A1)-FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0),IF((LEN(A1)-FIND(.,A1,1))=1,TIME(LEFT(TEXT(SUBSTITUTE(A10,.,),),2),RIGHT(TEXT(SUBSTITUTE(A10,.,),),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0))) But if you can have a look and simplified it will be graet Regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 8:36 AM Subject: Re: $$Excel-Macros$$ format a cell Dear All, For these three conditions - 532, 1215 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear All, If my input is 1215 or 12.15 converted to 12:15 of 12:15 From: Aamir Shahzad aamirshahza...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 12:22 AM Subject: Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:55 AM Subject: Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel-- 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 -- Regards, Aamir Shahzad -- FORUM
Re: $$Excel-Macros$$ format a cell
hi Don, Yes, I've used data validation, and forcing people to do tis in right way. But I need to sort past data and I'd like to learn from you all things that I won't find in the books. Regards, Pawel PS macro I'm still not there. From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 1:51 PM Subject: Re: $$Excel-Macros$$ format a cell BTW. You could use data validation to guide them to ONLY input as desired. Or, an input box macro. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Thursday, March 29, 2012 7:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ format a cell Maries, this is great, realy simplistic working fine, but what I find out today is that people have tendency to input 2.3 what means 02:30 but formula exchanging it to 00:23 can you help me on this? I've done something like that: =IF(ISERROR(LEN(A1)-FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0),IF((LEN(A1)-FIND(.,A1,1))=1,TIME(LEFT(TEXT(SUBSTITUTE(A10,.,),),2),RIGHT(TEXT(SUBSTITUTE(A10,.,),),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0))) But if you can have a look and simplified it will be graet Regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 8:36 AM Subject: Re: $$Excel-Macros$$ format a cell Dear All, For these three conditions - 532, 1215 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear All, If my input is 1215 or 12.15 converted to 12:15 of 12:15 From: Aamir Shahzad aamirshahza...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 12:22 AM Subject: Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:55 AM Subject: Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel-- 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
Re: $$Excel-Macros$$ format a cell
Hi All, thanks a lot for everyone, special to Aamir yes this what I was looking for THANKS a lot again. Regards, Pawel From: Aamir Shahzad aamirshahza...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:52 PM Subject: Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:55 AM Subject: Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel-- 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 -- Regards, Aamir Shahzad -- 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
Re: $$Excel-Macros$$ Formula for Unique Values with Condition
Hi Kiran, the easiest way of doing it is pivot table (so you can manage as you want) both request attached. From the macro point of view I can't help you with, but I've got your piont sometimes you want to see it to be able to learn it. Regards, Pawel ps I couldn't send you attachment - limitation on your phone due to size -- 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$$ format a cell
Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel -- 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$$ bom explosion help needed
Don, From beginning, what I'm up to, I'm woking for production site, and from time to time we launching and delisting product from our current range. On this point I need to know what should I order or what I should stop ordering. Ordering is no issue but delisting is different kind of story. In order to delist product I need to check all ingedients that are going to the product check if they are used in different products and if are not just stop ordering them. So if we are delisting 5 products and they are build from 50 ingredients each it is a pain to go every BOM and check it one by one. So what I realy want to have is list of the BOM to delist, with the list of BOM list of ingredients (both done thanks to you), but as a simple guy, I've become gridy and I'd like to ask you guys to help me to do check if the listed items are used in different BOM and if they are to check if the product is live or not. if it's live to check if is on the list of delisted product if is there. if yes find next appirience for this ingredient in BOM EXPOLSION, when it is found chech if its a live product if yes check if it's on the list for delisting product if not put in outcome tab that this ingredient is LIVE. So in simple words: 1. take first ingedient from tab outcome column D - CBS232 2. go to bom explosion report check in col D if there is an item, if yes take product code from col A - DMRITD06 3. go to delist tab and check if product - DMRITD06 is on the delisted product list, if yes REPEAT step 2, if not 4. go to outcome tab and insert LIVE in column F 5. repeat step 1 to 4 until list of ingerdient in outcome tab col D is finish. Thanks in advice Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, February 15, 2012 4:12 PM Subject: Re: $$Excel-Macros$$ bom explosion help needed You are going to have to tell me which item and give examples. Look for _ in col_ in column_, why__ Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, February 15, 2012 8:43 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ bom explosion help needed Hi Don, thanks again, I knew that my English could cause a problem. Wat I realy looking for is: (see file outcome tab) regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, February 15, 2012 2:09 PM Subject: Re: $$Excel-Macros$$ bom explosion help needed It only requires a minor change from col e to col f With .Range(a1:f lr) See attached. Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, February 15, 2012 7:08 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ bom explosion help needed Hi All, Thanks to Don G. (I have this spreadsheet working on macro just fantastic, thanks a lot Mate), but if you can help me add new extra fixture to it, it could be awesome. What I’d like to do is: In column F called “LIVE” (“outcome” tab) I’d like to have information, if the item (“outcome” tab , column D – “Component Item”) is live or not. So it should be picking item (in “component Item” tab) and looking for it in “Bom Explosion Report”, when will be find it should pick from column “A” (“top level item”) product code and check if it is on the list in “delisted” if it’s not, check if in column “F” in “Bom Explosion Report” this product is live, if it is, go to “outcome” tab and put across reference as “LIVE” in column “F”. I had hope it understandable (English is not my native language pls excuse me) and you will able to help me. Regards, Pawel -- 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
Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
HI MARIES, Can you let me know how you've done this, please Regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, February 12, 2012 5:33 AM Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables. Hi, Find the attached file. I have done without INDEX. Regards, MARIES. On Sun, Feb 12, 2012 at 7:00 AM, Lawali malaw...@gmail.com wrote: Mahesh, I have resolved the problem. I've used INDEX and Macro Recorder. See attached file. But any better solution is welcome.. Thanks. -- Imagine life as a game in which you are juggling some five balls in the air. You name them - Work, Family, Health, Friends and Spirit and you're keeping all of these in the Air. You will soon understand that work is a rubber ball. If you drop it, it will bounce back. But the other four Balls - Family, Health, Friends and Spirit - are made of glass. If you drop one of these; they will be irrevocably scuffed, marked, nicked, damaged or even shattered. They will never be the same. You must understand that and strive for it. 30 second Speech by Bryan Dyson (CEO of Coca Cola) -- 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$$ Synchronizing two Pivot tables.
Maries, Thanks regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, February 12, 2012 12:58 PM Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables. Hi Pawal, Instead of using Combo box Index formula, I have used Daa validation in B4. Also I have used the following code to update the data input to pivot filter when worksheet change condition. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address(False, False) = B4 Then ActiveSheet.PivotTables(PivotTable1).PivotFields(Date).CurrentPage = Range(B4).Value ActiveSheet.PivotTables(PivotTable3).PivotFields(Date).CurrentPage = Range(B4).Value End If End Sub Thats it. Regards, MARIES. On Sun, Feb 12, 2012 at 3:50 PM, pawel lupinski lupins...@yahoo.com wrote: HI MARIES, Can you let me know how you've done this, please Regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, February 12, 2012 5:33 AM Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables. Hi, Find the attached file. I have done without INDEX. Regards, MARIES. On Sun, Feb 12, 2012 at 7:00 AM, Lawali malaw...@gmail.com wrote: Mahesh, I have resolved the problem. I've used INDEX and Macro Recorder. See attached file. But any better solution is welcome.. Thanks. -- Imagine life as a game in which you are juggling some five balls in the air. You name them - Work, Family, Health, Friends and Spirit and you're keeping all of these in the Air. You will soon understand that work is a rubber ball. If you drop it, it will bounce back. But the other four Balls - Family, Health, Friends and Spirit - are made of glass. If you drop one of these; they will be irrevocably scuffed, marked, nicked, damaged or even shattered. They will never be the same. You must understand that and strive for it. 30 second Speech by Bryan Dyson (CEO of Coca Cola) -- 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
Re: $$Excel-Macros$$ explosion maco needed pls
Hi Don, Yes, my english is not up to speed so I'll clarify. In delisted tab I'd like to input manualy code b5:b16 - correct then I'd like to hits for each of them - correct C5:C16 and D5:D16 not inportant - correct Thank you the greatest Don :) Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 6:53 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Let’s get a bit of clarification.. You want to list in delisted!b516 the codes. 3 shown now. Then you want all hits for each of the 3 codes. Do you want to further restrict by reference in c5:c16 or is that meaningless like the dates in d516 Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- 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 wlEmoticon-nyahnyahwlEmoticon-openmouthedsmile
Re: $$Excel-Macros$$ explosion maco needed pls
yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- 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$$ explosion maco needed pls
you are the greatest from the greatest :) thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- 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
Re: $$Excel-Macros$$ explosion maco needed pls
thanks Mate From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 8:07 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Aw shucks. Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls you are the greatest from the greatest :) thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- 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
$$Excel-Macros$$ scheduler123
Hi All, I have the question if any of you were using scheduler123 for production planing is based on excel and macros so if yes can you let me know is useful? or maybe anyone of you have such demo, I'll be appreciated of any your thoughts . Regards, Pawel -- 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$$ Offset Formula
Hi All, Its nice staff do you have this in English it looks great but I don't get a word from it :) Regards, Pawel From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, February 9, 2012 5:36 PM Subject: Re: $$Excel-Macros$$ Offset Formula Hi Maansi, you are welcome in Excel-Macro Group. See attached example of 1. Offset 2. Indirect 4. Index On Thu, Feb 9, 2012 at 10:26 AM, Manasa Yes yesmaa...@gmail.com wrote: Dear Team, Good Morning... I would like to thank one and all for excellent tips, advise timely help on excell really proud to be part of this learning team!! I had joined for MIS Team recently and would like to learn much on excel so joined this group recently - special thanks to Mr. Noorain on helping me out to join the group... I had learnt about Sumproduct - which is provided by the team and would like to know some more on advanced excell formulas which will smoothen work : some of our company's summary reports contains the below formula's but i do not have any idea on how to use and when to use... please help : a) Off set b) Index (I had got one or two example from the recent mails) c) Indirect thank you all. have a great day!! Maansi. -- 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://noorainansari.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 -- 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$$ MASTER macro.
Hi All, I know you can help me as many times before,so this time I'd like to ask you for help with simple macro. I'd like to do macro that will copy MASTER tab to the end of the tabs, but this macro (will be perfect) if can ask user for week number, and change name MASTER to week and the number that user wrote, e.g. user wrote 10 so the new tab will be week 10 Can you help me on this point. Thanks, Pawel -- 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$$ MASTER macro.
Don, love it thanks a lot Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, February 8, 2012 11:33 PM Subject: Re: $$Excel-Macros$$ MASTER macro. Sub copysheetnameSAS() Sheets(Master).Copy after:=Sheets(Sheets.Count) ActiveSheet.Name = Week _ InputBox(Enter week NUMBER ie: 10) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, February 08, 2012 5:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MASTER macro. Hi All, I know you can help me as many times before,so this time I'd like to ask you for help with simple macro. I'd like to do macro that will copy MASTER tab to the end of the tabs, but this macro (will be perfect) if can ask user for week number, and change name MASTER to week and the number that user wrote, e.g. user wrote 10 so the new tab will be week 10 Can you help me on this point. Thanks, Pawel -- 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$$ Help in IF Function
result by IF function regards, Pawel From: anu gomathi anugomathi.d...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, September 6, 2011 9:00 PM Subject: $$Excel-Macros$$ Help in IF Function Hi All, Please help me to put the IF function for the below table. If the table value is 0 the product should not be there Attached the file for u r reference Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1 Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems 1 0 0 0 Tech 0 1 0 0 OFM 0 0 1 0 Apps 0 0 0 1 Systems Regards Anu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel IF.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ multi find function
both file from Haseeb and Ashish working GRAET!!! thanks a lot to you both Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help with formating
thanks Chilexcel From: ChilExcel chilexcel...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, March 4, 2011 11:53:45 PM Subject: Re: $$Excel-Macros$$ help with formating with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski lupins...@yahoo.com Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help needed - Extract data by customer name
Hi Mate, See attachement I've done it in two ways. First by PIVOT TABLE, second by function. Try if it helps. Regards, Pawel From: San Pat myitems2...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Sat, March 5, 2011 2:28:42 AM Subject: $$Excel-Macros$$ Help needed - Extract data by customer name Hi Friends, I have row data in the sheet1, which contains multiple data entries for the same customer. I am trying to extract each customer data in separate sheet (Extract_Data) and at the same time calculating the average price sum of the total quantity shipped to the particular customer. When I enter any new data in the sheet1, Extract_Data sheet should update automatically. If there is a new customer entry than also the extract data sheet should get update automatically with the new customer data. I have attached the reference sheet. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extract_Data_By_Customer_Name.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ help with formating
Thanks Mate, its great From: STDEV(i) setiyowati.d...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Fri, March 4, 2011 6:31:35 PM Subject: Re: $$Excel-Macros$$ help with formating see inside if it help On Fri, Mar 4, 2011 at 8:33 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Nedd help with product distribution in production plan
Hi All, I need to ask you for help, cos I'vestacked. I nedd help with distribution products from schedule to different shift. See attachement, it will put some light on it. Thanks in advance Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel scheduling.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Nedd help with product distribution in production plan
Hi Nath, I hope, that I've understood you correctly (english is not my first language ). the weightages are: group - as its indicate different department/machinery name - as its indicate product many many many thanks Pawel From: Sanjoy Nath sanjoy.nath...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, February 18, 2011 11:20:14 AM Subject: Re: $$Excel-Macros$$ Nedd help with product distribution in production plan use the solver optimeser. Parameterise the weightages.If you provide me the weightages , then I can write the macro for you that will autocalculate and distribute the optimum load to each shift. On Fri, Feb 18, 2011 at 2:21 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I need to ask you for help, cos I've stacked. I nedd help with distribution products from schedule to different shift. See attachement, it will put some light on it. Thanks in advance Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help pls : find first non empty row in range
thanks a lot!!! superb From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 5:33:44 AM Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range check the attachment On Wed, Feb 9, 2011 at 8:32 AM, danial mansoor danial_...@hotmail.com wrote: use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E260,E17:E26)) Date: Tue, 8 Feb 2011 17:05:33 -0800 Subject: $$Excel-Macros$$ help pls : find first non empty row in range From: lupins...@yahoo.com To: excel-macros@googlegroups.com Hi All, I hope you will help me in maybe something that is so simple, but I've sent last 2 hours to sort it out without any conclusion. :( The problem is: I need to find first cell that is bigger then 0 in the specific range. HELP!!! PS I'd like to add an attachement but I don't know how, so e.g.: column X 0 0 0 0 7 6 7 0 0 0 -- -- - Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help pls : find first non empty row in range
thanks!!! From: danial mansoor danial_...@hotmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 4:02:58 AM Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E260,E17:E26)) Date: Tue, 8 Feb 2011 17:05:33 -0800 Subject: $$Excel-Macros$$ help pls : find first non empty row in range From: lupins...@yahoo.com To: excel-macros@googlegroups.com Hi All, I hope you will help me in maybe something that is so simple, but I've sent last 2 hours to sort it out without any conclusion. :( The problem is: I need to find first cell that is bigger then 0 in the specific range. HELP!!! PS I'd like to add an attachement but I don't know how, so e.g.: column X 0 0 0 0 7 6 7 0 0 0 -- -- - Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
