Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation
Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor d...@premor.net wrote: PFA and try to run macro named SAVE on module1 On 29-08-2013 18:57, Vishwanath wrote: Dear Experts. Need your help. the solution can be by using the macros. I have a workbook containing sheet called Indent and master sheet. Indent sheet is form. The contents of the indent sheet to be updated to master sheet in a particular fashion by capturing information of the indent sheet in a particular manner given in sample sheet attached to this posting - solution required in master sheet. 1. Indent sheet is the sheet where data are updated on regular basis and needs to be updated in Master sheet 2. There should be button in Indent sheet to click to update. On clicking the button, It should update the rows that are there from row number 18 to the row till The row with Total amount to the master sheet 3. On each change the users update the master by clicking the click to update button. The data should be updated below the present data in master sheet 4. The user can insert rows in between row number 18 and Total amount row while updating the master. It should take the range dynamically. rgds Vishwa -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/uh8nMZ4bAQ4/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to
Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation
U're welcome i' stay in Borneo Island (Indonesia) (^_^) Pada 16/09/2013 13:13, Vishwanath menulis: Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor d...@premor.net mailto:d...@premor.net wrote: PFA and try to run macro named SAVE on module1 On 29-08-2013 18:57, Vishwanath wrote: Dear Experts. Need your help. the solution can be by using the macros. I have a workbook containing sheet called Indent and master sheet. Indent sheet is form. The contents of the indent sheet to be updated to master sheet in a particular fashion by capturing information of the indent sheet in a particular manner given in sample sheet attached to this posting - solution required in master sheet. 1. Indent sheet is the sheet where data are updated on regular basis and needs to be updated in Master sheet 2. There should be button in Indent sheet to click to update. On clicking the button, It should update the rows that are there from row number 18 to the row till The row with Total amount to the master sheet 3. On each change the users update the master by clicking the click to update button. The data should be updated below the present data in master sheet 4. The user can insert rows in between row number 18 and Total amount row while updating the master. It should take the range dynamically. rgds Vishwa -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/uh8nMZ4bAQ4/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding
Re: $$Excel-Macros$$ SumProduct
Hello, Thanks its working fine.. On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar excellearn2...@gmail.comwrote: Hi, ** ** Try this.. ** ** =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) ** ** ** ** * * *Warm Regards,* *Ravi Kumar.* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Friday, September 13, 2013 4:21 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ SumProduct ** ** Hi, I have a problem with Sumproduct function please find attached file for the same where from E1, F1 G1 are condtions based on it I need sum up Column D. Thanks in advance. Regards, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ SumProduct
Ur welcome Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, September 16, 2013 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SumProduct Hello, Thanks its working fine.. On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar excellearn2...@gmail.com mailto:excellearn2...@gmail.com wrote: Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com ] On Behalf Of Chandra Shekar Sent: Friday, September 13, 2013 4:21 PM To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ SumProduct Hi, I have a problem with Sumproduct function please find attached file for the same where from E1, F1 G1 are condtions based on it I need sum up Column D. Thanks in advance. Regards, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros+unsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros+unsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com . Visit this group at
Re: $$Excel-Macros$$ Query on vlookup
Dear Shrinivas, Index - Match function will be the solution for your problem. Pls. see the attachment. thanks JOhnson On Mon, Sep 16, 2013 at 10:21 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Shrinivas, u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0) Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Sat, Sep 14, 2013 at 11:07 AM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Ashish,De Premor,Ravi Kumar Very very thanks for the help All are working fine Thanks once again regards Shrinivas On Sat, Sep 14, 2013 at 10:36 AM, Ravi Kumar excellearn2...@gmail.com wrote: Another way G3 is lookup_value =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH(total,A2:F2,0)-1) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, September 14, 2013 10:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query on vlookup Try this formula =VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0) On 14-09-2013 11:28, Shrinivas Shevde wrote: Dear All Query on vlookup Please look at the attached sheet. Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Copy Past Macro help
Hi, I am really new in macro, can you please help me in attached excel as well LI tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I want to update my tracker sheet based on Sr. no. Currently I check serial number and manually copy past all corresponding fields from daily report. -- Regards, Shraddha Malvankar On Sat, Sep 14, 2013 at 11:21 AM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Genius man……. Thank you very much for help…This is exactly what I wanted….. Really appreciated your help. Regards, Shraddha On Sat, Sep 14, 2013 at 7:26 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required .Range(a4).Value = .Range(g4).Value = .Range(a6).Value = .Range(g6).Value = .Range(a8).Value = .Range(g8).Value = .Range(a10).Value = .Range(g10).Value = .Range(a12).Value = 'add new .Range(a4).Value = Sheets(data).Range(b i).Value .Range(g4).Value = Sheets(data).Range(a i).Value .Range(a6).Value = Sheets(data).Range(c i).Value .Range(g6).Value = Sheets(data).Range(d i).Value .Range(a8).Value = Sheets(data).Range(e i).Value .Range(g8).Value = Sheets(data).Range(f i).Value .Range(a10).Value = Sheets(data).Range(g i).Value .Range(g10).Value = Sheets(data).Range(h i).Value .Range(a12).Value = Sheets(data).Range(i i).Value End With 'send email now Sheets(Verification).Copy flname = VBA.Environ(temp) \ VBA.Format(VBA.Now, dd_mmm__hh_mm_ss) .xlsx Set wkb = ActiveWorkbook wkb.SaveAs flname Set olMail = objOL.CreateItem(olMailItem) With olMail .To = Sheets(Verification).Range(a12) .Subject = Verification .Attachments.Add flname .Body = Please verfiyy-- .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Nothing End Sub On Fri, Sep 13, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Verification sheet. This should happen for each line in data sheet. After which data sheet should get deleted and file should get saved by Vendor Name If possible this file should get sent to each vendor as per their email id Really appreciation your help. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@**googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macroshttp://groups.google.com/group/excel-macros . For more options, visit
Re: $$Excel-Macros$$ how to connect with accdb database from excel
Hi , can you please mail me the excel file .I am also trying to connect excel with password protected accdb database but unable to do it. It will show error message Invalid Password.It will be a great help On Mon, Aug 29, 2011 at 9:40 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Dario, See below link.. http://akoul.blogspot.com/search/label/Update%20Access%20Table%20from%20Excel On Mon, Aug 29, 2011 at 1:45 PM, oryn dari...@gmail.com wrote: Hi, I have a macro that should open Access 2007 database in .accdb format. Code works with .mdb format but with .accdb it doesn't. It returns message that programme is unable to open database (I checked it with several databases in .accdb format). Does anybody have a solution? Sub Pokarz_form_lista_klientow() Dim rsKwerenda As ADODB.Recordset Dim oConn As ADODB.Connection Dim sSciezkaBazy As String, sSql As String Dim rKlienci As Range Range(V_klienci).ClearContents sSciezkaBazy = Sheets(A_Ust).Cells(1, 2) Set oConn = New ADODB.Connection oConn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data Source= sSciezkaBazy ; sSql = SELECT Klient_Id, Status, Umowa, Region FROM Klienci order by Status asc, Klient_Id asc Set rsKwerenda = New ADODB.Recordset rsKwerenda.Open sSql, oConn Set OpenADODBRecordset = rsKwerenda -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Copy Past Macro help
do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in attached excel as well L I tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I want to update my tracker sheet based on Sr. no. Currently I check serial number and manually copy past all corresponding fields from daily report. -- Regards, Shraddha Malvankar On Sat, Sep 14, 2013 at 11:21 AM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Genius man……. Thank you very much for help…This is exactly what I wanted….. Really appreciated your help. Regards, Shraddha On Sat, Sep 14, 2013 at 7:26 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required .Range(a4).Value = .Range(g4).Value = .Range(a6).Value = .Range(g6).Value = .Range(a8).Value = .Range(g8).Value = .Range(a10).Value = .Range(g10).Value = .Range(a12).Value = 'add new .Range(a4).Value = Sheets(data).Range(b i).Value .Range(g4).Value = Sheets(data).Range(a i).Value .Range(a6).Value = Sheets(data).Range(c i).Value .Range(g6).Value = Sheets(data).Range(d i).Value .Range(a8).Value = Sheets(data).Range(e i).Value .Range(g8).Value = Sheets(data).Range(f i).Value .Range(a10).Value = Sheets(data).Range(g i).Value .Range(g10).Value = Sheets(data).Range(h i).Value .Range(a12).Value = Sheets(data).Range(i i).Value End With 'send email now Sheets(Verification).Copy flname = VBA.Environ(temp) \ VBA.Format(VBA.Now, dd_mmm__hh_mm_ss) .xlsx Set wkb = ActiveWorkbook wkb.SaveAs flname Set olMail = objOL.CreateItem(olMailItem) With olMail .To = Sheets(Verification).Range(a12) .Subject = Verification .Attachments.Add flname .Body = Please verfiyy-- .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Nothing End Sub On Fri, Sep 13, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Verification sheet. This should happen for each line in data sheet. After which data sheet should get deleted and file should get saved by Vendor Name If possible this file should get sent to each vendor as per their email id Really appreciation your help. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@**googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit
$$Excel-Macros$$ macro for required data please find the attachment once
Dear experts. please solve my query its very very urgent macro for required data please find the attachment once thanks *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Copy Past Macro help
Yes On 16 Sep 2013 20:12, ashish koul koul.ash...@gmail.com wrote: do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in attached excel as well L I tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I want to update my tracker sheet based on Sr. no. Currently I check serial number and manually copy past all corresponding fields from daily report. -- Regards, Shraddha Malvankar On Sat, Sep 14, 2013 at 11:21 AM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Genius man……. Thank you very much for help…This is exactly what I wanted….. Really appreciated your help. Regards, Shraddha On Sat, Sep 14, 2013 at 7:26 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required .Range(a4).Value = .Range(g4).Value = .Range(a6).Value = .Range(g6).Value = .Range(a8).Value = .Range(g8).Value = .Range(a10).Value = .Range(g10).Value = .Range(a12).Value = 'add new .Range(a4).Value = Sheets(data).Range(b i).Value .Range(g4).Value = Sheets(data).Range(a i).Value .Range(a6).Value = Sheets(data).Range(c i).Value .Range(g6).Value = Sheets(data).Range(d i).Value .Range(a8).Value = Sheets(data).Range(e i).Value .Range(g8).Value = Sheets(data).Range(f i).Value .Range(a10).Value = Sheets(data).Range(g i).Value .Range(g10).Value = Sheets(data).Range(h i).Value .Range(a12).Value = Sheets(data).Range(i i).Value End With 'send email now Sheets(Verification).Copy flname = VBA.Environ(temp) \ VBA.Format(VBA.Now, dd_mmm__hh_mm_ss) .xlsx Set wkb = ActiveWorkbook wkb.SaveAs flname Set olMail = objOL.CreateItem(olMailItem) With olMail .To = Sheets(Verification).Range(a12) .Subject = Verification .Attachments.Add flname .Body = Please verfiyy-- .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Nothing End Sub On Fri, Sep 13, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Verification sheet. This should happen for each line in data sheet. After which data sheet should get deleted and file should get saved by Vendor Name If possible this file should get sent to each vendor as per their email id Really appreciation your help. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@**googlegroups.com. To
$$Excel-Macros$$ How to do polynomial curve fitting with macro in excel?
Hi guys, This is my first post in this group. It is great that there is such a group! What I want to do right now is like this: Say, I have four columns of data, Column A, B, C and D, the latter three depend on Column A, there are 4 rows in each column I want to do interpolation and extrapolation to the four columns, mainly based on Column A, thus the other 3 columns can be interpolated/extrapolated. The way to do that is through curve-fitting, because linear interpolation may not work me, so I want need to get a curvefit for Column B vs. A, Column C vs. A, and Column D vs. A, respectively. There must be a macro that can take and record the individual coefficients in the curve function for each of the fitting curve. After the curve fittings are done, I can use the coefficients of the functional form to interpolate, extrapolate. Finally I will have another table--an extended table to tabulate all of the calculated data. About the curve fitting, I would like to start with polynomial, but not sure whether to start with cubic of fifth order first. One thing that may help me decide is to check some quantity to check the quality of the curve fitting, say, a t-test and/or F-test, if a cubic polynomial does not yield good data, I can switch to fifth order polynomial. As I'm totally new to macros, I'm confused about the way to do the macros. I know that I can make macros through recording, but I'm not sure if I can realize that without doing some macro coding (for instance, getting the individual coefficients of the curve-fitting functions, and checking the curve fitting quality to make decision whether to switch curve function or not, etc.) I guess I may need to write some macro coding to insert in my recorded macro to make it work, but I don't know where to start. If you guys have some examples to show me, I would really appreciate it! Thanks, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ macro for required data please find the attachment once
Here i'am using Multidimension array to get faster result This will little longer in code, but will much faster then Direct Manipulation Data using For Each ... in Range... Next (Loop) And then... Here we go... Sub Convert() Dim Data, Hasil, LCount As Long, LRow As Long, iCol As Integer Dim Timex As Double 'Start Timer Timex = Timer 'Define the result location Set ResLoc = Sheet2.Range(F1) 'Collect Data and store to array Data = Sheet1.UsedRange.Value 'Resize Result Variable to Store Processed Data ReDim Hasil(1 To ((UBound(Data, 1) * UBound(Data, 2)) - 2), 1 To 4) LCount = 1 'Create Header Hasil(LCount, 1) = SONG NAME Hasil(LCount, 2) = ALBUM Hasil(LCount, 3) = Downloads Hasil(LCount, 4) = Date 'Loop Entire Data Column For iCol = 3 To UBound(Data, 2) - 1 'Loop Entire Data Row For LRow = 2 To UBound(Data, 1) LCount = LCount + 1 'Assign the result with respected data Hasil(LCount, 1) = Data(LRow, 1) Hasil(LCount, 2) = Data(LRow, 2) Hasil(LCount, 3) = Data(LRow, iCol) Hasil(LCount, 4) = Data(1, iCol) Next Next 'Paste the data to Sheet, we need to resize it first to get same dimension with Hasil dimension ResLoc.Resize(UBound(Hasil, 1), UBound(Hasil, 2)) = Hasil 'Create Border ResLoc.CurrentRegion.Borders.LineStyle = xlContinuous 'Resize the column width to fit with cell data ResLoc.CurrentRegion.EntireColumn.AutoFit 'Format Column Date as Date Range(ResLoc, ResLoc.End(xlDown)).Offset(, 3).NumberFormat = [$-409]dd/mmm/yy;@ 'Show the Processing Time MsgBox Done in Timer - Timex seconds End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ RecordSet ADO get the 20th record
Make a query as Select Top 20 From your table name in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query Select Top 20 From your table name order by your sort column In case you need the 20th record after sorting data in descending order then use the following one Select Top 20 From your table name order by your sort column DESC In case you want to call any of these queries by ADO then create queryDef object. On Mon, Sep 16, 2013 at 7:33 PM, Michael Pablo skypablo...@gmail.comwrote: Hello Everbody! I would like to ask help with this duty, I don't Know how to get the 20th records from a record set. I tried with the While Clausule but I fail. And I don't Know if you can help me about that too because it is more a doubt SQL, where I divide by 1000 the registers but I aways get a Error, I don't Know Why because in access the Query works perfectly. Best Regards, *Michael* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Macro File Saving Restriction
Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension in those files macros do not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension. Is it possible? Thanks in Advance -- Thanks Pankaj Kumar 9910075248 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Need Formula
Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Need Formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Formula
Dear Prabhu, Pl see the attached sheet. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Need Formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet