Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.
Hi, Thanks for your reply I don not know the source of Scan copy, but if I want to convert any scan copy what would be the code. Thanks and regards On Sun, Dec 23, 2012 at 12:19 PM, Prince prince141...@gmail.com wrote: Hi Ganesh, Plz tell us the source of Fax Data. Regards Prince On Sunday, December 23, 2012 11:16:42 AM UTC+5:30, GANESH wrote: Hi, Can some please send me the Code for convert the Fax copy to Excel sheet. Thanks and Regards Ganesh Acha -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://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 get quick attention or may not be answered. 2) Don't post a question in the thread of 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$$ VBA MACRO HELP NEEDED
hi sir, can u please mail me the book for vba macro in my mail id i.e rathisumitra...@gmail.com thank you regards sumit rathi -- 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$$ Re: Reason for delay in Filter
Hi guys, sorry but i cant share the workbook as its company workbook so i dont have it. are there general reasons which may cause the delay? like if there are lots of Vlookup and countif formulas on the sheet. From: Prince prince141...@gmail.com To: excel-macros@googlegroups.com Cc: hanumant shinde arsfan2...@yahoo.co.in Sent: Sunday, 23 December 2012 11:42 AM Subject: $$Excel-Macros$$ Re: Reason for delay in Filter Hi Prashant, Please share your workbook so that we diagnose the problem and can provide whatever best we can do. Regards Prince On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote: Hi Friends, Can somebody please tel me what are the reasons for delay in Autofilter code. We have a macro file where in one of the function we have used Selection.AutoFilter Field:=1, Criteria1:=a This code is executed thousand times and it takes almost 1.75 seconds to execute above line once. so the whole process takes lots of time. Can somebody please tell me how why is it happening. -- 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$$ Re: Reason for delay in Filter
Yes. ThEre are general reasons. One is using select rather than ranges, another is not setting calculate to manual before running a complex macro, and the third is not switching of screenUpdating while the macro is running. On Sunday, 23 December 2012, hanumant shinde wrote: Hi guys, sorry but i cant share the workbook as its company workbook so i dont have it. are there general reasons which may cause the delay? like if there are lots of Vlookup and countif formulas on the sheet. -- *From:* Prince prince141...@gmail.com javascript:_e({}, 'cvml', 'prince141...@gmail.com'); *To:* excel-macros@googlegroups.com javascript:_e({}, 'cvml', 'excel-macros@googlegroups.com'); *Cc:* hanumant shinde arsfan2...@yahoo.co.in javascript:_e({}, 'cvml', 'arsfan2...@yahoo.co.in'); *Sent:* Sunday, 23 December 2012 11:42 AM *Subject:* $$Excel-Macros$$ Re: Reason for delay in Filter Hi Prashant, Please share your workbook so that we diagnose the problem and can provide whatever best we can do. Regards Prince On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote: Hi Friends, Can somebody please tel me what are the reasons for delay in Autofilter code. We have a macro file where in one of the function we have used Selection.AutoFilter Field:=1, Criteria1:=a This code is executed thousand times and it takes almost 1.75 seconds to execute above line once. so the whole process takes lots of time. Can somebody please tell me how why is it happening. -- 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.comjavascript:_e({}, 'cvml', 'excel-macros@googlegroups.com'); . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com javascript:_e({}, 'cvml', 'excel-macros%2bunsubscr...@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.comjavascript:_e({}, 'cvml', 'excel-macros@googlegroups.com'); . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com javascript:_e({}, 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards David Grugeon -- 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
Re: $$Excel-Macros$$ Re: Reason for delay in Filter
Hi Prashant, I understand the restriction of the work place.So provide me Below mentioned details. 1: How much data you have in sheet. 2:Is there any other formula or macro runs before you filter the data. 3:Can we have some sample data workbook ie any dummy workbook that has same volume of data. Regards Prince On Sunday, December 23, 2012 4:16:59 PM UTC+5:30, prashant shinde wrote: Hi guys, sorry but i cant share the workbook as its company workbook so i dont have it. are there general reasons which may cause the delay? like if there are lots of Vlookup and countif formulas on the sheet. -- *From:* Prince prince...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Cc:* hanumant shinde arsfa...@yahoo.co.in javascript: *Sent:* Sunday, 23 December 2012 11:42 AM *Subject:* $$Excel-Macros$$ Re: Reason for delay in Filter Hi Prashant, Please share your workbook so that we diagnose the problem and can provide whatever best we can do. Regards Prince On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote: Hi Friends, Can somebody please tel me what are the reasons for delay in Autofilter code. We have a macro file where in one of the function we have used Selection.AutoFilter Field:=1, Criteria1:=a This code is executed thousand times and it takes almost 1.75 seconds to execute above line once. so the whole process takes lots of time. Can somebody please tell me how why is it happening. -- 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. 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$$ Re: Need to convert the fax copy in Excel sheet.
Hi Ganesh, What i think is that any scanned copy is always saved as Image file in the system. So do you want save this image file in excel so that data can be presented in excel.? Regards Prince On Sunday, December 23, 2012 2:26:06 PM UTC+5:30, GANESH wrote: Hi, Thanks for your reply I don not know the source of Scan copy, but if I want to convert any scan copy what would be the code. Thanks and regards On Sun, Dec 23, 2012 at 12:19 PM, Prince prince...@gmail.comjavascript: wrote: Hi Ganesh, Plz tell us the source of Fax Data. Regards Prince On Sunday, December 23, 2012 11:16:42 AM UTC+5:30, GANESH wrote: Hi, Can some please send me the Code for convert the Fax copy to Excel sheet. Thanks and Regards Ganesh Acha -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. 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: Macro to create attendance Sheet for each Employee
Hello all experts Any help on my problem please Rashid On Saturday, December 22, 2012 12:15:33 AM UTC+4, prkhan56 wrote: Hello Prince I posted the reply yesterday but I cannot see it posted. So posting again. *Where is the out time of the employees.* Please see this sample data of employee A for 1st Nov only. Data for the same employee is also there in my previous sample sheet in Col B against his name. Name A11/1/2012 8:13 *IN TIME* Name A11/1/2012 8:13 Name A11/1/2012 19:52 Name A11/1/2012 19:52 Name A11/1/2012 19:52 Name A11/1/2012 19:52 *OUT TIME* *and if there are 100 emplyees then do you want 100 sheets in the workbook * Yes. Newly created sheet would be as per the number of employees Thanks for your time. Regards Rashid Khan On Wednesday, December 19, 2012 2:47:43 PM UTC+4, prkhan56 wrote: Hello All I am using excel 2007 I have data in the Master Sheet for various Employees I want to create separate sheet for each employee viz A, B, C and so on (see sample sheet attached) I got the macro from the Group which create separate sheet for each name (it is in the attached shet) I wish to amend the macro so that it gives the output as shown in sample sheets A, B and C My requirements are 1 It should check the date/ time of each Employee and then put the values (shown in Red Color) against each date Time-In / Time-Out on individual sheets 2 The macro should take the first entry and the last entry for each day for each Name 3 It should do this till the last employee is reached 4 There are some unauthorized entry in Col D with no Names in Col A. These entries should be ignored 5 The macro should put formulas in Col G and H (highlighted in Green Color) 6 Everything in Red Color Font would be done the by the macro…viz the Month, Name, Date, Time In and Time Out Thanks in advance Rashid Khan -- 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: Macro to create attendance Sheet for each Employee
Hi Rashid, Could you please explain when you want to run this process to capture InTime and OutTime of an Employee and how we know who are the employees. Is there any list of employee? Regards, Lalit Mohan On Wednesday, 19 December 2012 16:17:43 UTC+5:30, prkhan56 wrote: Hello All I am using excel 2007 I have data in the Master Sheet for various Employees I want to create separate sheet for each employee viz A, B, C and so on (see sample sheet attached) I got the macro from the Group which create separate sheet for each name (it is in the attached shet) I wish to amend the macro so that it gives the output as shown in sample sheets A, B and C My requirements are 1 It should check the date/ time of each Employee and then put the values (shown in Red Color) against each date Time-In / Time-Out on individual sheets 2 The macro should take the first entry and the last entry for each day for each Name 3 It should do this till the last employee is reached 4 There are some unauthorized entry in Col D with no Names in Col A. These entries should be ignored 5 The macro should put formulas in Col G and H (highlighted in Green Color) 6 Everything in Red Color Font would be done the by the macro…viz the Month, Name, Date, Time In and Time Out Thanks in advance Rashid Khan -- 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: Need to convert the fax copy in Excel sheet.
Hi Ganesh, You would need some OCR software to convert image to text. you can read this link i am sure its help you http://www.freewaregenius.com/2011/1...ree-ocr-tools/http://www.freewaregenius.com/2011/11/01/how-to-extract-text-from-images-a-comparison-of-free-ocr-tools/ Regards, Lalit Mohan On Sunday, 23 December 2012 11:16:42 UTC+5:30, GANESH wrote: Hi, Can some please send me the Code for convert the Fax copy to Excel sheet. Thanks and Regards Ganesh Acha -- 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. 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: Reason for delay in Filter
Hi Prashant, Before applying filters please use below code: *Application.Calculation = xlCalculationManual* and when you done with the filter then change it back to its original value *Application.Calculation = xlCalculationAutomatic* Instead of using Selection in your code please use a range like this: *Worksheets(Sheet1).range(A1:D10)..AutoFilter Field:=1, Criteria1:=a* Regards, Lalit Mohan On Saturday, 22 December 2012 21:51:03 UTC+5:30, prashant shinde wrote: Hi Friends, Can somebody please tel me what are the reasons for delay in Autofilter code. We have a macro file where in one of the function we have used Selection.AutoFilter Field:=1, Criteria1:=a This code is executed thousand times and it takes almost 1.75 seconds to execute above line once. so the whole process takes lots of time. Can somebody please tell me how why is it happening. -- 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$$ lookup values with 2 conditions
Thanks dear Its really fast. Regards Amit On Sat, Dec 22, 2012 at 6:45 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Amit, Please find the attachment. -- *Regards,* * * *Excel Beginner* On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I am attaching an excel file, where I have applied LOOKUP/INDIRECT function in sheet backup. But its very slow in working/opening. And when data is large, it takes too much time for processing. Is there any better fast way to get the same output? Please help me here. Regards Amit -- 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. -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- 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$$ lookup values with 2 conditions
Could you please explain the formula used? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel Beginner Sent: 22 December 2012 18:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ lookup values with 2 conditions Hi Amit, Please find the attachment. -- Regards, Excel Beginner On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi silkyro...@gmail.commailto:silkyro...@gmail.com wrote: Hi Experts I am attaching an excel file, where I have applied LOOKUP/INDIRECT function in sheet backup. But its very slow in working/opening. And when data is large, it takes too much time for processing. Is there any better fast way to get the same output? Please help me here. Regards Amit -- 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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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$$ Concept of INDEX, Match, Direct, Indirect
Dear Friends, I would like to learn the concept of INDEX, MATCH, DIRECT,INDIRECT functions. Please provide me some write-ups with examples. Thanks in Advance. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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$$ HIGH LOW QUERY
Suppos i m change the data in Sintex manual then formula works On Mon, Dec 24, 2012 at 10:41 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello Prince , Wish u merry Christmas i m facing some problem to find out High Low value Date in u r Formula pls see the attech file there is two Category not show me HIGH Data is it anything wrong with formula ??? pls chk thanks Dhaval Shah On Thu, Dec 13, 2012 at 10:08 PM, Prince prince141...@gmail.com wrote: Hi Dhaval' PFA Regards Prince On Thursday, December 13, 2012 6:29:32 PM UTC+5:30, Dhaval Shah wrote: Need Data Range upto 99000 in this sheet data Range upto only 2000 me try to change Data Range but its dosent work Pls do need full Thanks Dhaval Shah 98240 35253 On Wed, Dec 12, 2012 at 10:43 PM, Prince prince...@gmail.com wrote: Hi Dhaval , Pls find Attached. Regards Prince On Wednesday, December 12, 2012 6:26:26 PM UTC+5:30, Dhaval Shah wrote: from 158 row formula not working On Wed, Dec 12, 2012 at 6:25 PM, Dhaval Shah todhav...@gmail.comwrote: Already change data range but not working On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar satendr...@gmail.com wrote: Hi, change data range than apply i hope this is working... thankx satendra On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah todhav...@gmail.comwrote: FRIENDS WHENEVER I M PUTTING NEW DATEA ABOVE 808 UPTO 5000 RAW FORMULA NOT WORKING -- Join official Facebook page of this forum @ https://www.facebook.com/**discu**ssexcelhttps://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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.**com. Visit this group at http://groups.google.com/**group** /excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/**discu**ssexcelhttps://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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.**com. Visit this group at http://groups.google.com/**group** /excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @
Re: $$Excel-Macros$$ Re: How to import web page Table in Excel
Hi Lalit, how to get data scrolling from password protected site, like i want my email inbox. thankx satendra On Sat, Dec 22, 2012 at 2:42 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Dhaval, ** ** PFA. Hope it is what you are looking for. ** ** ** ** *Regards,* *Lalit Mohan* *+919711867226 [IM Only]* On Saturday, 22 December 2012 13:01:26 UTC+5:30, Dhaval Shah wrote: Dear can u mail me sample file me try to put code but its can't work acTually I m not much accrate Thanks Dhaval shah Sent on my BlackBerry® from Vodafone -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 01:54:12 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Re: How to import web page Table in Excel Hi Dhaval, Hope it might helps you, Put below code in a module and add refrence of Microsoft Internet Controls Option Explicit Declare Function apiShowWindow Lib user32 Alias ShowWindow _ (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long Sub Test() Call CopyWebPage End Sub Private Sub CopyWebPage(Optional IEVisible As Boolean = False) Dim IE As InternetExplorer Dim wksSheetAs Worksheet Dim dtTime As Date Application.DisplayAlerts = False Application.EnableEvents = False If Application.ScreenUpdating Then Application.ScreenUpdating = False Set wksSheet = ThisWorkbook.Worksheets(**sheet1) wksSheet.DrawingObjects.Delete wksSheet.Cells.Clear Set IE = New InternetExplorer With IE apiShowWindow .hwnd, 3 .Visible = IEVisible .Navigate http://www.nseindia.com/live_** market/dynaContent/live_watch/**equities_stock_watch.htm?cat=Nhttp://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N ** 'Wait for initial page to load Do While .readyState READYSTATE_COMPLETE Or .Busy: DoEvents: Loop 'Copying website dtTime = Now() Begin: If Now() = DateAdd(s, 3, dtTime) Then GoTo Begin End If .ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT .ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT .ExecWB OLECMDID_CLEARSELECTION, OLECMDEXECOPT_DODEFAULT .Quit End With With wksSheet Application.Goto .Range(A1) .Paste Application.CutCopyMode = False .Cells(301, 1).Resize(100).EntireRow.**Delete .Cells(1, 1).Resize(247).EntireRow.**Delete DeleteShapes ($1:$2) DeleteShapes ($54:$54), False .Range(A1).CurrentRegion.**Font.Size = 8 Application.Goto .Range(A1) End With Set IE = Nothing End Sub Private Sub DeleteShapes(ByVal strRange As String, Optional blnDelOtherShp As Boolean = True) Dim Sh As Shape With Worksheets(Sheet1) For Each Sh In .Shapes If Not Application.Intersect(Sh.**TopLeftCell, .Range(strRange)) Is Nothing Then Sh.Delete End If Next Sh For Each Sh In .Shapes If Not Sh.Name Like Picture* Then Sh.Delete End If Next Sh End With End Sub and call Test procedure whereever you need to refresh may be in button click or some where else. change sheet name and range aaccordingly. Regards, Lalit Mohan On Friday, 21 December 2012 13:59:59 UTC+5:30, Dhaval Shah wrote: Hello Friends i want to import below mention link table to excel Sheet with auto refresh http://www.nseindia.com/live_**market/dynaContent/live_watch/** equities_stock_watch.htm?cat=Nhttp://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N actually nseindia update there web site recently . earlier i m easily import ( with auto refresh ) the table also atteach my previous file for u r reference Thanks Dhaval Shah -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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
Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA
Hello Stranger, I can see your query and would like to get it done but before doing this I am curious to know something related to your query. Are you having invoices info and customer info in different workbooks? If yes then In attached Sample list of Invoicing, I can see only few inputs. Are these information available only one sheet or more than one sheet. I put the same question on the other attached workbook (customer Master). or it would be good idea if these information is put on same workbook. Regards, Anoop Sr. Developer On Wed, Dec 19, 2012 at 4:45 PM, .. mail_to_s...@yahoo.com wrote: Dear List members Request : *Mail merge and E mail* using VBA or other tools = - I have to send reminder / dunning letters to my customers. - Unfortunately the faxing option from the company is very time consuming (print, sort, fax, wait for dial tones...failure etc etc) and it takes a long time. - Also there isn't a corporate e mail reminder solution in sight. - To avoid delays and very heavy workload, I plan to e mail the reminder / dunning letters. *I have to take this personally * - I think this should be possible to partially automate this task using XL (data) and combining that with word or VBA and send mail thru MS outlook. - I suspect some one may have tried this before - I seek your help for innovative solutions...either VBA or any other innovative solution as well . - All input data would be available as XL files. Samples shown below and XL files also added to this mail - If this has not been tried earlier or if this is too cumbersome, please drop this, ...my advance apologies . - Any pointers to other websites are also gratefully acknowledged THANKS in advance !!! Subu My customer master looks like this *[xl file enclosed]* Customer#Customer_Name...Address..E_mail... 12345The fancy paint shopPO Box 322, madras...fancy_pa...@hotmail.com 12346Bright Colours.PO Box 123, cochinbright_col...@gmail.com 12347Best Decor Bangalore..PO Box 456, bangalorebest_d...@bestbangl.co.in and ...so on . My list of overdue invoices looks like this *[xl file enclosed] * === Customer #Invoice#...InvoiceDate.DueDateAmount_Due(Rs) 12345.AX4562.01/10/2012.30/11/2012..11289.60 12345.AX4653.02/10/2012.30/11/2012..45678.45 12345.AX4653.02/11/2012.31/12/2012..11235.78 12346.AX8657.04/10/2012.30/11/2012...4567.60 12346.AX7658.07/10/2012.30/11/2012...3456.45 12346.AX9248.08/11/2012.31/12/2012...2589.78 12347.AX4258.06/10/2012.30/11/2012.111269.60 12347.AX4796.12/10/2012.30/11/2012..33789.45 12347.AX6987.10/11/2012.31/12/2012560.78 ...and so on I wish to send a reminder / dunning letters by e mail as follows == === start of 1st reminder email to fancy_pa...@hotmail.com == To M/s Fancy Paint Shop = PO Box 322 = Madras = all above from the master ! Date : 19 Dec 2012 (basically run date) Dear Sir, Madam You account is overdue by Rs. 56,968.05. Please effect payment immediately to avoid delays in supply. A list of invoices due on your account is given below Customer #Invoice#...InvoiceDate.DueDateAmount_Due(Rs) 12345.AX4562.01/10/2012.30/11/2012..11289.60 12345.AX4653.02/10/2012.30/11/2012..45678.45 Should you need anything more please contact Subu at ..@yahoo.com or at +98354xyzab for further information Thanking you Yours Sincerely Subu === end of 1st dunning email === As you would have noticed the next reminder / dunning letter would be of the same format but different in the due amount and list of invoices = Start of 2nd reminder / dunning email to bright_col...@gmail.com=== To M/s Bright Colours = PO Box 123 = Cochin = all above from the master ! Date : 19 Dec 2012 (basically run date) Dear Sir, Madam You account is overdue by Rs. 8024.05. Please effect payment immediately to avoid delays in supply. A list of invoices due on your account is given below Customer
$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee
Hello Lalit Thanks for the reply. Please see the sample sheet which I have attached with my first post. The names of the employees are in excel sheet and the time in / time out details are shown against each employee name I want to run the macro to run on Master sheet and create time sheet each employee showing their Time In/ Time Out Is this clear? Thanks Regards Rashid Khan On Monday, December 24, 2012 8:41:35 AM UTC+4, Lalit Mohan Pandey wrote: Hi Rashid, Could you please explain when you want to run this process to capture InTime and OutTime of an Employee and how we know who are the employees. Is there any list of employee? Regards, Lalit Mohan On Wednesday, 19 December 2012 16:17:43 UTC+5:30, prkhan56 wrote: Hello All I am using excel 2007 I have data in the Master Sheet for various Employees I want to create separate sheet for each employee viz A, B, C and so on (see sample sheet attached) I got the macro from the Group which create separate sheet for each name (it is in the attached shet) I wish to amend the macro so that it gives the output as shown in sample sheets A, B and C My requirements are 1 It should check the date/ time of each Employee and then put the values (shown in Red Color) against each date Time-In / Time-Out on individual sheets 2 The macro should take the first entry and the last entry for each day for each Name 3 It should do this till the last employee is reached 4 There are some unauthorized entry in Col D with no Names in Col A. These entries should be ignored 5 The macro should put formulas in Col G and H (highlighted in Green Color) 6 Everything in Red Color Font would be done the by the macro…viz the Month, Name, Date, Time In and Time Out Thanks in advance Rashid Khan -- 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$$ Unsubscribe my email id
Hi, Please, unsubsribe my email id from the group. Thanks Jaspreet Singh -- 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$$ Unsubscribe my email id
Email to following group excel-macros+unsubscr...@googlegroups.com. On Mon, Dec 24, 2012 at 1:13 PM, jaspreet singh jas_sar...@yahoo.comwrote: excel-macros+unsubscr...@googlegroups.com. -- 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.