$$Excel-Macros$$ EXCEL ADDIN MACRO
I am fresher to computer. I just have added a macro in Excel Addin in a separate module. I am getting error No. 13, while running this. I want to use this in all file. Kindly help me Sub TEXTFILE() Application.DisplayAlerts = False Application.ScreenUpdating = False On Error GoTo ErrHandler: 'Now i will activate notepad and open/create one file 'Windows Scripting Runtime(SCRRUN.DLL)--reference to be activated Dim txtfile As Characters ' TextStream 'Dim fso As New Scripting.FileSystemObject Dim sFile As Variant 'String sFile = Application.GetSaveAsFilename(InitialFileName:=txtfilename(), FileFilter:=Text Files (*.txt), *.txt) If sFile = False Then Exit Sub If sFile Then 'If fso.FileExists(sFile) Then Kill sFile Set txtfile = fso.CreateTextFile(sFile, True) Else Set txtfile = fso.CreateTextFile(sFile, True) End If 'now i will write details of records. ActiveWorkbook.Sheets(ECR).Select 'Sheets(Sheet1).Select For Decount = 1 To ActiveSheet.UsedRange.Rows.Count - 1 d = #~# DD1 = Left(Cells(Decount + 1, 1), 7) DD2 = UCase(Cells(Decount + 1, 2)) DD3 = Left(Cells(Decount + 1, 3), 10) DD4 = Left(Cells(Decount + 1, 4), 10) DD5 = Left(Cells(Decount + 1, 5), 10) DD6 = Left(Cells(Decount + 1, 6), 10) DD7 = Left(Cells(Decount + 1, 7), 10) DD8 = Left(Cells(Decount + 1, 8), 10) DD9 = Left(Cells(Decount + 1, 9), 10) DD10 = Left(Cells(Decount + 1, 10), 10) If Cells(Decount + 1, 11) 0 Then DD11 = Left(Cells(Decount + 1, 11), 2) Else DD11 = 0 End If If Cells(Decount + 1, 12) 0 Then DD12 = Left(Cells(Decount + 1, 12), 10) Else DD12 = 0 End If If Cells(Decount + 1, 13) 0 Then DD13 = Left(Cells(Decount + 1, 13), 10) Else DD13 = 0 End If If Cells(Decount + 1, 14) 0 Then DD14 = Left(Cells(Decount + 1, 14), 10) Else DD14 = 0 End If If Cells(Decount + 1, 15) 0 Then DD15 = Left(Cells(Decount + 1, 15), 10) Else DD15 = 0 End If If Cells(Decount + 1, 16) 0 Then DD16 = Left(Cells(Decount + 1, 16), 10) Else DD16 = 0 End If DD17 = UCase(Cells(Decount + 1, 17)) DD18 = UCase(Left(Cells(Decount + 1, 18), 1)) If Cells(Decount + 1, 19) 0 Then DD19 = Right(00 Day(Cells(Decount + 1, 19)), 2) / _ Right(00 Month(Cells(Decount + 1, 19)), 2) / _ Year(Cells(Decount + 1, 19)) Else DD19 = End If DD20 = UCase(Left(Cells(Decount + 1, 20), 1)) If Cells(Decount + 1, 21) 0 Then DD21 = Right(00 Day(Cells(Decount + 1, 21)), 2) / _ Right(00 Month(Cells(Decount + 1, 21)), 2) / _ Year(Cells(Decount + 1, 21)) Else DD21 = End If If Cells(Decount + 1, 22) 0 Then DD22 = Right(00 Day(Cells(Decount + 1, 22)), 2) / _ Right(00 Month(Cells(Decount + 1, 22)), 2) / _ Year(Cells(Decount + 1, 22)) Else DD22 = End If If Cells(Decount + 1, 23) 0 Then DD23 = Right(00 Day(Cells(Decount + 1, 23)), 2) / _ Right(00 Month(Cells(Decount + 1, 23)), 2) / _ Year(Cells(Decount + 1, 23)) Else DD23 = End If If Cells(Decount + 1, 24) 0 Then DD24 = Right(00 Day(Cells(Decount + 1, 24)), 2) / _ Right(00 Month(Cells(Decount + 1, 24)), 2) / _ Year(Cells(Decount + 1, 24)) Else DD24 = End If DD25 = Left(Cells(Decount + 1, 25), 1) '- txtfile.WriteLine (DD1 d DD2 d DD3 d DD4 d DD5 d DD6 d DD7 _ d DD8 d DD9 d DD10 d DD11 d DD12 d DD13 d DD14 d _ DD15 d DD16 d DD17 d DD18 d DD19 d DD20 d DD21 d _ DD22 d DD23 d DD24 d DD25) '- Next Decount MsgBox The text file is saved as sFile Sheets(Textmain).Select Exit Sub ErrHandler: If Err.Number = 13 Then MsgBox Vba Error Code 13 - Data Type Mismatch. The date in Row Number _ Decount + 1 is not in the date format Else MsgBox Vba Error Code Err.Number - Err.Description _ . Textfile is not created successfully. GoTo ExitFunction: End If ExitFunction: On Error GoTo 0 Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Function txtfilename() As String 'Dim c As String 'Dim y As String 'Dim m As String 'Dim t As String ' 'Sheets(Textmain).Select 'c = Left(Cells(2, 8), 2) Left(Cells(2, 9), 3) _ 'Right(0 Cells(2, 10), 5) 0 'y = Left(Year(Cells(4, 10)), 4) 'm = Right(00 Month(Cells(4, 10)), 2) 't = .txt 'txtfilename = c + y + m + t Dim m As String Dim t As String m = Format(Now(), mmm- ) t = .txt txtfilename = m + t End Function -- 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
$$Excel-Macros$$ Average from different sheets except blank data
*Can anybody solve this problem.* On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal isk1...@gmail.com wrote: *Hello,* *Can anybody help me to get the solution. Thanks.* * * *Regards / Pravin * -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Sat, Dec 1, 2012 at 11:23 AM Subject: $$Excel-Macros$$ Average from different sheets except blank data To: excel-macros@googlegroups.com *Hello Friends,* * * *I have an excel file of same cell range on multiple 13 worksheets (12 sheets for month wise data 1 for it’s summary).* *The full name of months are given to the sheets and the last sheet named as Summary.* * * *1.* *I would like to use an AVERAGE formula in H26 in summary sheet, but it’s not working fine. Following is the formula which I have used in the file.* *=AVERAGE(April:March!H26)* * * *It’s coming wrong, as because the file is updated up to November month and from December to March months data are blank. That would be updated as and when the particular month is closed. So the blank sheets are to be ignored without changing the range of formula.* * * *2.* *Moreover, there is a column called “outstanding” in a summary sheet and it should be picked up only the last outstanding value in cell J26 from the last updated sheet (instead of total of all the sheets).* * * *For example : December to March data is blank so the formula should pick the outstanding value of November month, when we keep going update the value of December onward it should change accordingly.* * * *The sample file is attached for your reference. * *Thank you in advance.* * * *With regards,** **Pravin Gunjal* -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ Latest file copy using excelvba
PFA workbook for sample design to copy files from one directory to another. Please help me to get the same. -- Thanks Regards, Ganesh -- 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. Backup.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Multiple Values by Vlookup
Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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. Multiple values by vlookup.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Multiple Values by Vlookup
Noorain, In what way do you wish to make it more dynamic? How do you use this? 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: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, December 4, 2012 7:34:36 AM Subject: $$Excel-Macros$$ Multiple Values by Vlookup Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http://noorainansari.com http://excelvbaclinic.com -- 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 Values by Vlookup
below is the solution if i understood your requirement correctly =IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),),ROW()-4)-4),) with CSE pfa On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner schreiner_p...@att.netwrote: Noorain, In what way do you wish to make it more dynamic? How do you use this? *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:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, December 4, 2012 7:34:36 AM *Subject:* $$Excel-Macros$$ Multiple Values by Vlookup Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- 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. -- *Great day,* *viper* -- 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. Multiple values by vlookup.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel Macro
I'm sorry to say that I've never heard of an application that can do as you ask. I would think it would be very difficult to interpret the macros. yes, the macro can record that you selected a cell. But it unless you've named the range that you're selecting, the macro doesn't know what the cell REPRESENTS. like: Range(A15).Select could not be interpreted to be: Select the Beginning date for your record. However, There ARE applications that might allow you to take a different approach... SnagIT allows you to record a VIDEO of the selections that you've made. I believe you can annotate the video so that it becomes an instructional tool. It's been a while since I've used it, so I'm not sure how extensive it is... 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: AR arya...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, December 3, 2012 6:41:28 PM Subject: $$Excel-Macros$$ Excel Macro Hi Frnds, Can anybody tell me , whether is it possible to document a process by recording the process using macro. For example .. i am having 2 excel files .. i am copying data from one to another and using the necessary formulas i am preparing the report say PL.. i need to document these steps as written instructions.. Can macro record these copying and other things and give output in written text.. is it possible.. -- 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 Values by Vlookup
Thanks Viper for your nice solution, Generally we do it through Index, but we want to do it through Vlookup and it should work like Index, Pls suggest. *Aside to Paul Sir* : we want to make red colored part as dynamic in below mentioned formula =IFERROR(VLOOKUP($I$5,INDIRECT(ADDRESS(SMALL(IF($I$5=$F$5:$F$11,ROW($F$5:$F$11)-ROW($F$5)+1),ROW(1:1))+4,6):ADDRESS( *ROW($G$11)*,7)),2,0),) On Tue, Dec 4, 2012 at 6:21 PM, The Viper viper@gmail.com wrote: below is the solution if i understood your requirement correctly =IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),),ROW()-4)-4),) with CSE pfa On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner schreiner_p...@att.netwrote: Noorain, In what way do you wish to make it more dynamic? How do you use this? *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:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, December 4, 2012 7:34:36 AM *Subject:* $$Excel-Macros$$ Multiple Values by Vlookup Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- 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. -- *Great day,* *viper* -- 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. -- With Regards, Noorain Ansari http://
Re: Fwd: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12
Even though this forum provides a TREMEDOUS service and makes getting assistance convenient. I've many times expressed that the use of the written word actually makes providing this type of help more DIFFICULT! When asking for help, we tend to forget that what WE see on the screen isn't seen by others, so we forget to mention it. We also assume that terms that we use every day are known by everyone. The people I truly admire are the ones that participate in which English is not their first language. (which means anyone that understands my humor is TRULY AMAZING! :-D ) So, not only do we struggle with the technical aspects of our tasks, and the various levels of understanding, but we have language differences to overcome. AND WE DO IT ALL SO WELL !!! I feel truly honored to be counted as a member of this wonderful group of people! Thank you all for your kind words! 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 - -- Original message -- From: Ayush Jain jainayus...@gmail.com Date: Mon, Dec 3, 2012 at 11:58 PM Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 To: excel-macros excel-macros@googlegroups.com Dear members, Paul Schreiner has been selected as 'Most Helpful Member' for the month of Nov'12. He has posted 52 posts last month and helped forum members through his excel expertise. I truly appreciate his technical knowledge, consistency and commitment to the group. Paul has been associated with the forum from last 4 years and is providing free consulting and outstanding solutions to the forum members. I personally like the way he guide people on their problems. He just not provide the solution but educate the person on how to improvise and make the solution better for long term. He has his own style of writing and great sense of humor. I love to read his replies when I get the time. His reply itself provide the different aspects of same problem. Paul, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. We are honored to have you in this forum. Thanks to Ashish, Prince, Noorain, Pravin, Anil and all other members for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey form. -- 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$$ Re: VBA Macros quiz #1
can i please get access to the quiz questions again? thanks! On Saturday, November 10, 2012 1:13:08 PM UTC+1, Ayush Jain wrote: Hello everyone, Here is another quiz for you to test VBA basics. There are 10 multiple choice questions in the quiz and should not take more than 5 minutes to complete the quiz. VBA quiz http://goo.gl/PnSfr So what you are waiting for , go ahead and take the quiz. Click here to participate in quiz. http://goo.gl/PnSfr I will share the winners of excel quiz and VBA quiz on 13th November in this forum only. Stay tuned. Regards Ayush Jain Group Manager -- 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$$ Paul Schreiner - Most Helpful Member November'12 *
Hearty Congratulation Paul.. With the help of expertise. I started teaching Basic Excel to my friends Thanks Manjunath 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 * [Boxbe]https://www.boxbe.com/overview[http://www.boxbe.com/stfopen?tc=13036043567_713202469]This message is eligible for Automatic Cleanup! (jainayus...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DUZAoCxeohBFcb%252FrM8x3rkNKuNIZuTCZhaalJJwHxJ2%252B60f64UF3kzBXvkA4gdJ0yL%252FEDSBRXWqKhWGxdQGK2oqJRmsgWWepg8dwkGJ3%252FPKAO%252FNiOe%252FGRHAbaSzVf7tU9aR6dWvmMPUqBG4%252Fd%252FQvVYA%253D%253D%26key%3DfQZQR0JjX8j%252FHjRK79IMZaUczuM8GivPkGd7t2COSzM%253Dtc=13036043567_713202469 | More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13036043567_713202469 -- 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. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- 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$$ Paul Schreiner - Most Helpful Member November'12 *
Hey dats good news Manjunath.. Keep sharing Sent on my BlackBerry® from Vodafone -Original Message- From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk Sender: excel-macros@googlegroups.com Date: Tue, 4 Dec 2012 15:07:17 To: 'excel-macros@googlegroups.com'excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 * Hearty Congratulation Paul.. With the help of expertise. I started teaching Basic Excel to my friends Thanks Manjunath 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 * [Boxbe]https://www.boxbe.com/overview[http://www.boxbe.com/stfopen?tc=13036043567_713202469]This message is eligible for Automatic Cleanup! (jainayus...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DUZAoCxeohBFcb%252FrM8x3rkNKuNIZuTCZhaalJJwHxJ2%252B60f64UF3kzBXvkA4gdJ0yL%252FEDSBRXWqKhWGxdQGK2oqJRmsgWWepg8dwkGJ3%252FPKAO%252FNiOe%252FGRHAbaSzVf7tU9aR6dWvmMPUqBG4%252Fd%252FQvVYA%253D%253D%26key%3DfQZQR0JjX8j%252FHjRK79IMZaUczuM8GivPkGd7t2COSzM%253Dtc=13036043567_713202469 | More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13036043567_713202469 -- 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. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- 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
$$Excel-Macros$$ a date query
Hi, Pls help me solve my query. Pls find the file attached. Thanks, Kenil -- 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. date query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Multiple Values by Vlookup
Hi Noorain Sir, Below mentioned your requirement and find the attachment. =IFERROR(VLOOKUP($I$5,INDIRECT(FSMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1)):$G$11),2,0),) *Regards,* * * *Excel Beginner* * * On Tue, Dec 4, 2012 at 6:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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. Multiple values by vlookup (Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Conditional Formatting
Hi - I have a spreadsheet in which I have the following formula for statistical testing, =IF(L7=$S$2,CHAR(233),IF(L7=-$S$2,CHAR(234),)). It displays an up arrow if the first IF statement is true and an down arrow if the second IF statement is true. I would like the arrow displayed to be bolded and if it is an up arrow then it should be in green font and if the arrow is downward then it should be in red font. How would I add the color code to the existing formula so the arrows are displayed in color? Thanks, JP -- 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$$ Scraping data from image
Hi Paul, thanks a lot for your detailed explanation From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Friday, 30 November 2012 7:48 PM Subject: Re: $$Excel-Macros$$ Scraping data from image Here's the long version of explanation: An image file (.jpg, .gif, etc) is nothing but a bunch of colored dots. Think of trying to draw a picture using a pencil and making just dots. (this art form is called Pointillism http://en.wikipedia.org/wiki/Pointillism) If you pack the dots closely together, it becomes a darker shade. Further apart, it is lighter. .. .. .. .. . .. .. .. .. .. .. .. When you pack the dots close enough, and make some dots different colors, your EYE perceives it as an image. If you were to scan a Word document and save it as an image, then zoom up on the image many, many times, on any given letter, you'd see a bunch of dots, closely packed together. So... basically this means that images are a bunch of dots, that OPTICALLY (visually) represent characters (or images). In order to read these dots, you have to have software that recognizes the patterns of closely packed dots and converts them to characters. Traditional forms of this software is called OCR. for Optical Character Recognition. You CAN purchase this software, or in some cases, send the file to a web site that will use their software to process your image. In my case, my scanner (Lexmark 5100x) has the ability to apply OCR to the scanned image. What I have done in the past is: Print the image Scan the printed copy and select OCR. hope this helps you to understand the process. 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: Arsfan2005 arsfan2...@yahoo.co.in To: excel-macros@googlegroups.com Sent: Fri, November 30, 2012 2:29:06 AM Subject: Re: $$Excel-Macros$$ Scraping data from image thanx fr ur reply i will google it. but is it posible fr u too xplain it in more this will help me. Sent from Samsung Mobile xlstime xlst...@gmail.com wrote: Yes, it is possible.. pls try Recognize txet from OCR On Fri, Nov 30, 2012 at 2:16 AM, hanumant shinde arsfan2...@yahoo.co.in wrote: Hi, Is it possible to capture (scrape) data from .doc file but the data on this .doc file is pasted as image. -- 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. -- 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
Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12
hearty congratulations Paul. i would like to know your blog link if you post the blogs. your knowledge is tremendous. From: Ayush Jain jainayus...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Monday, 3 December 2012 11:58 PM Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 Dear members, Paul Schreiner has been selected as 'Most Helpful Member' for the month of Nov'12. He has posted 52 posts last month and helped forum members through his excel expertise. I truly appreciate his technical knowledge, consistency and commitment to the group. Paul has been associated with the forum from last 4 years and is providing free consulting and outstanding solutions to the forum members. I personally like the way he guide people on their problems. He just not provide the solution but educate the person on how to improvise and make the solution better for long term. He has his own style of writing and great sense of humor. I love to read his replies when I get the time. His reply itself provide the different aspects of same problem. Paul, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. We are honored to have you in this forum. Thanks to Ashish, Prince, Noorain, Pravin, Anil and all other members for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey form. -- 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$$ Re: Conditional Formatting
You need to create two conditional formats, one for the up arrow and one for the down arrow. In Excel 2010: For the up arrow: Select the range starting on cell L7 Go to Home - Conditional Formatting - New Rule - Use a formula to determine which cells to format Write =L7=$S$2 on the 'Format values where this formula is true' text box Click on Format On Font Style select Bold On the color dropdown select Green. Click Ok, click Ok again With the same range selected repeat the previous steps but changing the formula and the color. On Tuesday, December 4, 2012 3:24:15 PM UTC-4, JP wrote: Hi - I have a spreadsheet in which I have the following formula for statistical testing, =IF(L7=$S$2,CHAR(233),IF(L7=-$S$2,CHAR(234),)). It displays an up arrow if the first IF statement is true and an down arrow if the second IF statement is true. I would like the arrow displayed to be bolded and if it is an up arrow then it should be in green font and if the arrow is downward then it should be in red font. How would I add the color code to the existing formula so the arrows are displayed in color? Thanks, JP -- 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$$ MACRO FOR LIST CHECK AND ADD ROWS
Thanks Mr. Paul No need to say Sorry. You helped me a lot. This macro is running perfectly now. Thanks a lot once again. Regards Amit On Tue, Dec 4, 2012 at 6:04 PM, Paul Schreiner schreiner_p...@att.netwrote: Amit, Sorry, Since I didn't know how large your data set would end up being, I used a Dictionary Object to read the existing records. then, I would check this list to determine if the record existed. Since I made the object public, it didn't clear out when the macro finished. So in the next execution, it retained the previous values. (thought you ought to know MY mistake) I fixed the macro and tuned it up a little. hope it serves you well! *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:* Amit Gandhi silkyro...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Mon, December 3, 2012 11:55:15 PM *Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS Thanks Mr. Paul This is what I require. May be I was unable to explain my requirement, but you rightly understood and give me solution. Thanks a lot. But this macro has some problems. 1. If I run this macro 1st time, it add the rows correctly. But when I run this macro again, it again add those rows and create duplicity of records. COLUMN A should have unique values always. 2. In my example I had copied 1st two values of TTlist in cell A6 A7, and this macro has copied down rest of the values from cell A8 onwards rightly. BUT when I have copied any random values from TTlist in cell A6 A7, then macro hasn't checked the values and left 1st two values of TTlist and copied down rest of the values. I have attached file for your ready reference. Pls provide solution to this problem as well. Thanks in advance. Regards Amit On Mon, Dec 3, 2012 at 6:16 PM, Paul Schreiner schreiner_p...@att.netwrote: The problem is that you described your problem backwards. You SAID that you wanted to compare the list in sheet TT to the values in the named range TTlist and copy the values from row 1 if it doesn't exist. -- I assumed that you were going to be adding values to sheet TT and wanted to check to see if they existed in TTlist. If they did NOT, then add the value and copy row 1. So, I gave you what you asked for. -- Instead, from your example, you want to compare the values in the named range TTlist to the values in sheet TT and add any that do not already exist FROM TTlist TO the sheet. The attached file, macro Add_Records should perform this task. *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:* Amit Gandhi silkyro...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Sat, December 1, 2012 1:15:34 AM *Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS Hi Paul This is not working. I am trying to elaborate more step by step what I required. Step 1. Macro will check in sheet *TT,* column A (A6 onwards) with * TTlist* for values. e.g. (a) it will check 1st value of TTlist i.e. DPR/FIBC15544/12 in cell A6. (b) if this value already exists in A6, then no action and go to next cell A7. (c) if this value already exists in A7, then no action and go to next cell A8. This step goes on until BLANK cell in column A. Step 2. If a value of TTlist doesn't exist in column A, then it copies Row 1 and paste it at the end (say at row 8 in attached file), then it fill-in the value in cell A8, and search for next value. e.g. (a) 3rd value DPR/FIBC15509/12 of TTlist doesn't exist in column A of sheet TT. (b) Macro will copy Row 1 and paste it at Row 8. (c) Macro will copy above value of (a) to cell A8. Then macro will check for 4th value DPR/FIBC15508/12 of TTlist in column A of sheet TT and so on till complete list has been checked. After running macro final solution will be as shown in sheet Solution_Reqd. Hope I make you understand what I need. Pls help me here. Regards Amit On Fri, Nov 30, 2012 at 7:30 PM, Paul Schreiner schreiner_p...@att.netwrote: Your description and sample is somewhat conflicting. You SAID: 1. Macro will check in sheet TT column A (A6 onwards) with TTlist for values. 2. If a value exists in column A, it ignores and go to next cell. 3. If a value doesn't exist in column A, then it copies Row 1 and paste it at the end (say at row 8 in attached file),
Fwd: $$Excel-Macros$$ Scraping data from image
*Really a very good information. * *Thanks,* * * *Regards / Pravin.* -- Forwarded message -- From: Paul Schreiner schreiner_p...@att.net Date: Fri, Nov 30, 2012 at 7:48 PM Subject: Re: $$Excel-Macros$$ Scraping data from image To: excel-macros@googlegroups.com -- 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$$ Paul Schreiner - Most Helpful Member November'12
Congrats Paul On Wed, Dec 5, 2012 at 2:08 AM, hanumant shinde arsfan2...@yahoo.co.inwrote: hearty congratulations Paul. i would like to know your blog link if you post the blogs. your knowledge is tremendous. -- *From:* Ayush Jain jainayus...@gmail.com *To:* excel-macros excel-macros@googlegroups.com *Sent:* Monday, 3 December 2012 11:58 PM *Subject:* $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 Dear members, Paul Schreiner has been selected as 'Most Helpful Member' for the month of Nov'12. He has posted 52 posts last month and helped forum members through his excel expertise. I truly appreciate his technical knowledge, consistency and commitment to the group. *Paul has been associated with the forum from last 4 years and is providing free consulting and outstanding solutions to the forum members. I personally like the way he guide people on their problems. He just not provide the solution but educate the person on how to improvise and make the solution better for long term. He has his own style of writing and great sense of humor. I love to read his replies when I get the time. His reply itself provide the different aspects of same problem. * *Paul, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution. We are honored to have you in this forum. * Thanks to Ashish, Prince, Noorain, Pravin, Anil and all other members for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey form. -- 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. -- Regards, Anoop Sr. Developer -- 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$$ How to make Outline work in Protection
Hi Anoop, that was easy, however if you click on + of the outline, that does not work when the sheet is protected. This is the problem and i need to make that work with your help. regards, Zeeshan On Wed, Dec 5, 2012 at 10:47 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hi Zeeshan, Please find attached. Regards, Anoop Sr. Developer On Wed, Dec 5, 2012 at 10:33 AM, Zeeshan zeesha...@gmail.com wrote: Dear Mates, I have been following this group for almost 3 years, and had been silent spectator, picking up tips which has really helped me, but today i have to post this query which i have been trying hard but could not find a solution. Pl find attached file, this is grouped from Dates to Week and if i protect the sheet then Outline does not work. Waiting for Suggestions regards, Zeeshan -- 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. -- Regards, Anoop Sr. Developer -- 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.