Re: $$Excel-Macros$$ Re: Email Trigger ?
Hi Bill, For your question about Enable Reference. In VBA window, where your VBA code is, under Tools menu you will find this option. Basole, I am still struggling to make this code work (without using Outlook). I still get the error transport failed to connect to the server. Regards, Aashish On Tue, Oct 8, 2013 at 9:43 AM, Bill Q ronsmith...@gmail.com wrote: HI Besole, I am impressed with your code. I will be really impressed once it works ! I read up a bit on the Enable Reference Object Microsoft CDO for Windows 2000 Library. Sorry, but I am lost on this one and need guidence. I have put my email address and password where indicated and I left the quotes ( ) there. Is that correct, or should the quotes be removed ? I see two other parts, but it appears to be just notes with no action required on my part. Am I correct ? ' send one copy with Google SMTP server (with autentication) schema = http://schemas.microsoft.com/**cdo/configuration/http://schemas.microsoft.com/cdo/configuration/ *** Flds.Item(schema sendusing) = 2 Flds.Item(schema smtpserver) = smtp.gmail.com *** Thanks ! On Monday, 7 October 2013 11:05:24 UTC-4, Basole wrote: 'hi, below option of sending email ( gmail ) without Outlook with SMTP server Sub SendEmail() ' Enable Reference Object Microsoft CDO for Windows 2000 Library Dim iMsg, iConf, Flds, nTo, nFr, rng, psw nTo = your email address here nFr = nTo rng = Range(a1).Value psw = your email password here Set iMsg = CreateObject(CDO.Message) Set iConf = CreateObject(CDO.**Configuration) Set Flds = iConf.Fields ' send one copy with Google SMTP server (with autentication) schema = http://schemas.microsoft.com/**cdo/configuration/http://schemas.microsoft.com/cdo/configuration/ Flds.Item(schema sendusing) = 2 Flds.Item(schema smtpserver) = smtp.gmail.com Flds.Item(schema smtpserverport) = 465 Flds.Item(schema smtpauthenticate) = 1 Flds.Item(schema sendusername) = nTo Flds.Item(schema sendpassword) = psw Flds.Item(schema smtpusessl) = 1 Flds.Update With iMsg .To = nTo .From = nFr .Subject = Important message .ReplyTo = nFr Set .Configuration = iConf .TextBody = the cell A1 changed to: rng SendEmailGmail = .Send End With MsgBox Email sent to nTo successfully ! Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing End Sub Private Sub Worksheet_Change(ByVal Target As Range) If ThisWorkbook.ActiveSheet.**Range(A1) 10 Then Call SendEmail Else End If End Sub 'Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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
$$Excel-Macros$$ Writing a string to a particular cell
Hi, This should have a quick fix hopefully. Please tell me what's is wrong with the following lines in the code: sStr1 = Personnel iNumPer + 1 ThisWorkbook.Worksheets(Job Details).Range(Cells(4, iPasteCol)).Value = sStr1 When i run the code, I receive *Run-time error '1004':* *Application-defined or object-defined error* sStr1 is declared as a string. iNumper is declared as an Integer. iPasteCol is declared as an Integer. I've used MsgBox to confirm the values stored in them are correct. Currently, iNumper = 1, sSTR1 = Personnel 2, iPasteCol = 19. All I want to do is to write [Personnel 2] in cell S4 of the worksheet Job Details; but I need to use the column index number instead of the letter. I've tried Range.Text, as well as Range.FormulaR1C1; but I receive the same error. Thanks in advance. Jewel -- 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$$ Writing a string to a particular cell
Use Cells(4, iPasteCol).address) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jewel Sharma Sent: Tuesday, October 08, 2013 1:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Writing a string to a particular cell Hi, This should have a quick fix hopefully. Please tell me what's is wrong with the following lines in the code: sStr1 = Personnel iNumPer + 1 ThisWorkbook.Worksheets(Job Details).Range(Cells(4, iPasteCol)).Value = sStr1 When i run the code, I receive Run-time error '1004': Application-defined or object-defined error sStr1 is declared as a string. iNumper is declared as an Integer. iPasteCol is declared as an Integer. I've used MsgBox to confirm the values stored in them are correct. Currently, iNumper = 1, sSTR1 = Personnel 2, iPasteCol = 19. All I want to do is to write [Personnel 2] in cell S4 of the worksheet Job Details; but I need to use the column index number instead of the letter. I've tried Range.Text, as well as Range.FormulaR1C1; but I receive the same error. Thanks in advance. Jewel -- 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$$ Identifying Excel number format
Dear Xltime, The macro is working fine but the loop it is not going down to the last used cell it is working only up to 1st blank cell can you please change the code so as to make it run up to last used cell. Thanks in advance. Thank you Regards Sandeep Kumar Chhajer. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 05 October 2013 16:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format c an you please example your requirement please find attachment hope it fulfill your requirement . Enjoy Team XLS On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer chhajersand...@gmail.com mailto:chhajersand...@gmail.com wrote: PFA the original file. Hope it will work. On 5 October 2013 13:00, ashish koul koul.ash...@gmail.com mailto:koul.ash...@gmail.com wrote: i can't see custom format On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer chhajersand...@gmail.com mailto:chhajersand...@gmail.com wrote: Dear Ashish, This is only original file, I have just cut down the number of entries to certain extent as I am checking my code with lesser data. Sent on my BlackBerryR from Vodafone _ From: ashish koul koul.ash...@gmail.com mailto:koul.ash...@gmail.com Sender: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com Date: Sat, 5 Oct 2013 12:55:31 +0530 To: excel-macrosexcel-macros@googlegroups.com mailto:excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer chhajersand...@gmail.com mailto:chhajersand...@gmail.com wrote: Dear Excel Gurus, I have facing a peculiar problem related to number format. When I export any ledger from tally I got result as bellow Aditya Birla Memorial Hospital 3049.00 3049.00 Aditya Enterprises 99521.00 101086.00 1565.00 Cr Airways Corporation 39363.80 Dr 39363.80 Dr Airways Surgical Pvt Ltd 361446.45 Dr 959168.00 1133676.00 186938.45 Dr AL-SAMIYAH GROUP FOR MARKETING INT. TRADE 791326.00 883606.25 92280.25 Cr Al-Wafigroup for Marketing Int'l Trade Co. 743036.00 754572.48 11536.48 Cr Now, the custom number format for negative number is 0.00 Cr and for positive number is 0.00 Dr. (I have also attached herewith the file for your reference.) Again, I have tried to build a macro with my limited VBA knowledge but it is not working as variable b is not changing according to the current cursor location. I am pasting what i have tried. Sub format() a = Range(e15).NumberFormat ' i want this b shall change value according to the new destination i.e. ' _want to make it as variable according to the new cell format. b = ActiveCell.NumberFormat Do ActiveCell.Offset(1, 0).Select If a = b Then ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1 ActiveCell.Offset(0, -1).Select Else ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1 ActiveCell.Offset(0, -1).Select End If Loop Until ActiveCell.Offset(0, -4).Value = End Sub Please Help me out. Thanks in advance. -- Regards, Sandeep Kumar Chhajer. -- 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. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ My Excel Blog Like Us on Facebook
$$Excel-Macros$$ Recognizing Number format
Dear Excel Gurus, I have a peculiar problem. When I import data in excel from Tally it shows me number as shown below Balance Debit Credit Balance Aditya Birla Memorial Hospital 3049.00 3049.00 Aditya Enterprises 99521.00 101086.00 1565.00 Cr Airways Corporation 39363.80 Dr 39363.80 Dr Airways Surgical Pvt Ltd 361446.45 Dr 959168.00 1133676.00 186938.45 Dr AL-SAMIYAH GROUP FOR MARKETING INT. TRADE 791326.00 883606.25 92280.25 Cr Al-Wafigroup for Marketing Int'l Trade Co. 743036.00 754572.48 11536.48 Cr When I check in format menu it shows me 0.00 Cr for NEGETAIVE value and 0.00 Dr for POSITIVE value. All I want to do is recognise the format with the help of macro and change the value accordingly. I have tried to develop a macro with my very lesser knowledge but it is not working as value of variable b is not changing according to its present (changing) location. Please help. My VBA Working Sub format() a = Range(e15).NumberFormat ' i want this b shall change value according to the new destination i.e. ' _want to make it as variable according to the new cell format. b = ActiveCell.NumberFormat Do ActiveCell.Offset(1, 0).Select If a = b Then ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1 ActiveCell.Offset(0, -1).Select Else ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1 ActiveCell.Offset(0, -1).Select End If Loop Until ActiveCell.Offset(0, -4).Value = End Sub Thanks in advance. Thank you Regards Sandeep Kumar Chhajer. -- 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. dr cr.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Re: Recognizing Number format
Sorry for all mails sent to you today...actually my outlook is not working for 3 days and all mails were there in outbox. Sorry for the inconvenience :( All the issues regarding this thread are resolved. Thanks once again. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sandeep Chhajer chhajersand...@gmail.com Date: Tue, 8 Oct 2013 13:19:55 To: excel-macros@googlegroups.com Subject: Recognizing Number format Dear Excel Gurus, I have a peculiar problem. When I import data in excel from Tally it shows me number as shown below Balance Debit Credit Balance Aditya Birla Memorial Hospital 3049.00 3049.00 Aditya Enterprises 99521.00 101086.00 1565.00 Cr Airways Corporation 39363.80 Dr 39363.80 Dr Airways Surgical Pvt Ltd 361446.45 Dr 959168.00 1133676.00 186938.45 Dr AL-SAMIYAH GROUP FOR MARKETING INT. TRADE 791326.00 883606.25 92280.25 Cr Al-Wafigroup for Marketing Int'l Trade Co. 743036.00 754572.48 11536.48 Cr When I check in format menu it shows me 0.00 Cr for NEGETAIVE value and 0.00 Dr for POSITIVE value. All I want to do is recognise the format with the help of macro and change the value accordingly. I have tried to develop a macro with my very lesser knowledge but it is not working as value of variable b is not changing according to its present (changing) location. Please help. My VBA Working Sub format() a = Range(e15).NumberFormat ' i want this b shall change value according to the new destination i.e. ' _want to make it as variable according to the new cell format. b = ActiveCell.NumberFormat Do ActiveCell.Offset(1, 0).Select If a = b Then ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1 ActiveCell.Offset(0, -1).Select Else ActiveCell.Offset(0, 1).Select ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1 ActiveCell.Offset(0, -1).Select End If Loop Until ActiveCell.Offset(0, -4).Value = End Sub Thanks in advance. Thank you Regards Sandeep Kumar Chhajer. -- 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$$ INDEX MATCH DOUBT
*HI,* * * *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..* * * * * *REGARDS* *KANNAN V* -- 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. DOUBT.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ INDEX MATCH DOUBT
I think u did not mentioned BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Excel-Macros$$ INDEX MATCH DOUBT HI, PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE.. REGARDS KANNAN V -- 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$$ INDEX MATCH DOUBT
That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.comwrote: I think u did not mentioned “BITUMEN’ in second sheet ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 1:41 PM *To:* Google *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT ** ** *HI,* ** ** *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..* ** ** ** ** *REGARDS* *KANNAN V* -- 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$$ INDEX MATCH DOUBT
I think this one help u From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 2:38 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Excel-Macros$$ INDEX MATCH DOUBT HI, PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE.. REGARDS KANNAN V -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding
Re: $$Excel-Macros$$ INDEX MATCH DOUBT
*HEY,* * * *ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER DATA.* *WHAT I HAVE TO DO:??* =INDEX('MASTER DATA'!$A$2:$AQ$1048576,MATCH($F$4,'MASTER DATA'!$D$2:$D$1048576,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: I think this one help u ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 2:38 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT ** ** That also i tried... :-( but no use. it too urgent, anybody help me ** ** On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned “BITUMEN’ in second sheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 1:41 PM *To:* Google *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT *HI,* *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..* *REGARDS* *KANNAN V* -- 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
RE: $$Excel-Macros$$ INDEX MATCH DOUBT
There may be different total number of rows in ur file Try this =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ctrl+shift+enter From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 3:15 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT HEY, ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER DATA. WHAT I HAVE TO DO:?? =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think this one help u From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 2:38 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Excel-Macros$$ INDEX MATCH DOUBT HI, PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE.. REGARDS KANNAN V -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS
Re: $$Excel-Macros$$ INDEX MATCH DOUBT
*HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-)* *THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-) * On Tue, Oct 8, 2013 at 3:21 PM, Ravinder ravinderexcelgr...@gmail.comwrote: There may be different total number of rows in ur file Try this ** ** =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ctrl+shift+enter ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 3:15 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT ** ** *HEY,* ** ** *ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER DATA.* *WHAT I HAVE TO DO:??* =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ** ** ** ** ** ** On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think this one help u *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 2:38 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned “BITUMEN’ in second sheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 1:41 PM *To:* Google *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT *HI,* *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..* *REGARDS* *KANNAN V* -- 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
RE: $$Excel-Macros$$ INDEX MATCH DOUBT
Thanks dear... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 3:32 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-) THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-) On Tue, Oct 8, 2013 at 3:21 PM, Ravinder ravinderexcelgr...@gmail.com wrote: There may be different total number of rows in ur file Try this =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ctrl+shift+enter From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 3:15 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT HEY, ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER DATA. WHAT I HAVE TO DO:?? =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think this one help u From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 2:38 PM To: Google Cc: Soum Subject: Re: $$Excel-Macros$$ INDEX MATCH DOUBT That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned BITUMEN' in second sheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kannan Excel Sent: Tuesday, October 08, 2013 1:41 PM To: Google Subject: $$Excel-Macros$$ INDEX MATCH DOUBT HI, PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE.. REGARDS KANNAN V -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't
Re: $$Excel-Macros$$ INDEX MATCH DOUBT
Hi friend, if you feel free, pls teach me how u did this formula. my major doubt is why you using +COLUMN()-3) and why you using ctrl+shift+enter. when you feel free pls tell me... On Tue, Oct 8, 2013 at 3:35 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Thanks dear….. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 3:32 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT ** ** *HEY AWESOME, FANTASTIC, EXCELENT GREAT :-) AM REALLY HAPPY :-)* *THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)* ** ** ** ** ** ** On Tue, Oct 8, 2013 at 3:21 PM, Ravinder ravinderexcelgr...@gmail.com wrote: There may be different total number of rows in ur file Try this =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ctrl+shift+enter *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 3:15 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT *HEY,* *ITS REALLY GREAY BOSS BUT ITS UNABLE TO COPY PASTE IN MY ORIGINAL MASTER DATA.* *WHAT I HAVE TO DO:??* =INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think this one help u *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 2:38 PM *To:* Google *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT That also i tried... :-( but no use. it too urgent, anybody help me On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u did not mentioned “BITUMEN’ in second sheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel *Sent:* Tuesday, October 08, 2013 1:41 PM *To:* Google *Subject:* $$Excel-Macros$$ INDEX MATCH DOUBT *HI,* *PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..* *REGARDS* *KANNAN V* -- 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
Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)
Dear any solution pls On Mon, Oct 7, 2013 at 6:13 PM, amar takale amartak...@gmail.com wrote: Dear sir Thanks for reply first.I attached example file with detailed.pls see it. Regards Amar On Mon, Oct 7, 2013 at 5:05 PM, Rs. apkra...@gmail.com wrote: Amar, You want to add the Balance Qty with your Received Qty (ie in Cell F7) But where you key-in (on which cell) your second receipt for A?? Regards Rs. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Email Trigger ?
Hi Basole, This coding is working fine Great Work... But, Can you please do some changes in it, whenever anyone was do changes in sheet in a Specific Cell, then the mail is automatically send an email with the specific cell details. Great Work..!!! :) Thanks, Ashish On Monday, October 7, 2013 8:35:24 PM UTC+5:30, Basole wrote: 'hi, below option of sending email ( gmail ) without Outlook with SMTP server Sub SendEmail() ' Enable Reference Object Microsoft CDO for Windows 2000 Library Dim iMsg, iConf, Flds, nTo, nFr, rng, psw nTo = your email address here nFr = nTo rng = Range(a1).Value psw = your email password here Set iMsg = CreateObject(CDO.Message) Set iConf = CreateObject(CDO.Configuration) Set Flds = iConf.Fields ' send one copy with Google SMTP server (with autentication) schema = http://schemas.microsoft.com/cdo/configuration/; Flds.Item(schema sendusing) = 2 Flds.Item(schema smtpserver) = smtp.gmail.com Flds.Item(schema smtpserverport) = 465 Flds.Item(schema smtpauthenticate) = 1 Flds.Item(schema sendusername) = nTo Flds.Item(schema sendpassword) = psw Flds.Item(schema smtpusessl) = 1 Flds.Update With iMsg .To = nTo .From = nFr .Subject = Important message .ReplyTo = nFr Set .Configuration = iConf .TextBody = the cell A1 changed to: rng SendEmailGmail = .Send End With MsgBox Email sent to nTo successfully ! Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing End Sub Private Sub Worksheet_Change(ByVal Target As Range) If ThisWorkbook.ActiveSheet.Range(A1) 10 Then Call SendEmail Else End If End Sub 'Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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$$ Re: Email Trigger ?
Hi Bill try this link http://www.rondebruin.nl/win/s1/cdo.htm Regards Ashish On Tue, Oct 8, 2013 at 6:11 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Hi Basole, This coding is working fine Great Work... But, Can you please do some changes in it, whenever anyone was do changes in sheet in a Specific Cell, then the mail is automatically send an email with the specific cell details. Great Work..!!! :) Thanks, Ashish On Monday, October 7, 2013 8:35:24 PM UTC+5:30, Basole wrote: 'hi, below option of sending email ( gmail ) without Outlook with SMTP server Sub SendEmail() ' Enable Reference Object Microsoft CDO for Windows 2000 Library Dim iMsg, iConf, Flds, nTo, nFr, rng, psw nTo = your email address here nFr = nTo rng = Range(a1).Value psw = your email password here Set iMsg = CreateObject(CDO.Message) Set iConf = CreateObject(CDO.**Configuration) Set Flds = iConf.Fields ' send one copy with Google SMTP server (with autentication) schema = http://schemas.microsoft.com/**cdo/configuration/http://schemas.microsoft.com/cdo/configuration/ Flds.Item(schema sendusing) = 2 Flds.Item(schema smtpserver) = smtp.gmail.com Flds.Item(schema smtpserverport) = 465 Flds.Item(schema smtpauthenticate) = 1 Flds.Item(schema sendusername) = nTo Flds.Item(schema sendpassword) = psw Flds.Item(schema smtpusessl) = 1 Flds.Update With iMsg .To = nTo .From = nFr .Subject = Important message .ReplyTo = nFr Set .Configuration = iConf .TextBody = the cell A1 changed to: rng SendEmailGmail = .Send End With MsgBox Email sent to nTo successfully ! Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing End Sub Private Sub Worksheet_Change(ByVal Target As Range) If ThisWorkbook.ActiveSheet.**Range(A1) 10 Then Call SendEmail Else End If End Sub 'Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ Getting Application-defined or object-defined error, when pasting the data from webpage to excel
Getting the application - defined or object - defined error while execution. Sub GetTable() dataarr = Range(A1:A3) 'Change according to your criteria For i = 1 To UBound(dataarr, 1) If counter = 0 Then store_value = dataarr(i, 1) counter = 1 MsgBox store_value Else store_value = store_value Chr(13) dataarr(i, 1) End If Next MsgBox store_value Dim ieApp As InternetExplorer 'Dim ieDoc As Object Dim ie As Object Dim ieDoc As Object Dim strReturnBody As String Dim MyObject As Object' Create object variable. Set MyObject = Sheets(1) Set ie = CreateObject(InternetExplorer.application) ie.Visible = True ie.navigate http://sbm/BizSolo/OrderProcessStatusQuery/EnterQuery.jsp?dummy=falsehttp://dm4cqv.on.bell.ca:30011/sbm/BizSolo/OrderProcessStatusQuery/EnterQuery.jsp?dummy=false ' website where I'm pasting the data's to be queried Do Loop Until ie.ReadyState = READYSTATE_COMPLETE Application.Wait DateAdd(s, 3, Now) While ie.Busy DoEvents Wend ie.Document.getElementById(SB_Name).Click ie.Document.getElementById(SB_Name).Click Application.Wait (Now + TimeValue(0:00:10)) ie.Document.getElementById(orderNumber).Value = store_value Application.Wait (Now + TimeValue(0:00:1)) ie.Document.getElementById(SB_Name).Click Application.Wait (Now + TimeValue(0:00:20)) With ActiveSheet.QueryTables.Add(Connection:= _ URL;http:///DisplayQueryResult.jsp?dummy=false; _ , Destination:=Range(B1)) ' webpage where I'm getting the result of the data's queried .Name = DisplayQueryResult.jsp?dummy=false .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = table1,2,4 .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With 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.
$$Excel-Macros$$ Re: Multi sheets Grouping Problem
Hi De Premor, Thanks alot for your help. thank you so much. *(¨`•.•´¨) 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.* On 6 October 2013 18:11, Renukachari Kasee jva.ch...@gmail.com wrote: Dear Group Please help me this problem for multi sheets select with in the single click As per the requirement Thank *(¨`•.•´¨) 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.
$$Excel-Macros$$ Re: Need macro export data into workbooks with grand Totals and specified format
Hi ravinder negi, Thanks for given this macro but it was not working in my end i was entered multiple times range criteria but i was not work it shows error debug message please help me out. thanking you. *(¨`•.•´¨) 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.* On 7 October 2013 19:46, Renukachari Kasee jva.ch...@gmail.com wrote: Hi ravinder negi, Thanks for giving this macro i am expecting exactly Like this only, but if change the range it would not work please check this once actually i was given only sample copy only but data range would be nearly 20k to 30k. what i want is exactly you are prepared format only but range would be different. this range would not same in every day. Please help me out in this regard... 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.* On 6 October 2013 18:50, Renukachari Kasee jva.ch...@gmail.com wrote: Dear Group, Please Give me the required format macro for data exporter. please find the attachments required format is Export data with Specified range and grand totals as well 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.
RE: $$Excel-Macros$$ Re: Pie chart
Any luck with this one On Oct 6, 2013 3:16 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Ravi, Pie chart calculates the percentage by its inbuilt feature and is the whole pie is equal to 100%. I just want the first slice to be exactly in the centre to the right as I had ahown in my original example. Let me know if you need any further clarification. Thanks, Joseph On Oct 5, 2013 5:11 PM, Ravinder ravinderexcelgr...@gmail.com wrote: I think u r saying about % value but how can that be same of value if value is more than 125 then percentage will be 125% ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *joseph camill *Sent:* Saturday, October 05, 2013 4:48 PM *To:* excel-macros@googlegroups.com *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ Re: Pie chart ** ** Hi Ravi, ** ** thanks for the code, but if I change the values they do not appear right. ** ** Thanks, Joseph ** ** On Sat, Oct 5, 2013 at 4:20 PM, Ravinder ravinderexcelgr...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *joseph camill *Sent:* Saturday, October 05, 2013 12:13 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: Pie chart Hi, Attached is the file with two examples. I am looking for a similar output to be done using vba. Let me know if you need any further clarification on this. Thanks, Joseph On Wed, Oct 2, 2013 at 12:42 PM, ashish koul koul.ash...@gmail.com wrote: please share the chart On Wed, Oct 2, 2013 at 12:39 PM, joseph camill joseph.cam...@gmail.com wrote: Can anyone help me with a code On Sep 24, 2013 9:11 PM, joseph camill joseph.cam...@gmail.com wrote: Thanks for your response. I know to do it manually but my charts gets updated very often. So I am looking for an automation. On Sep 24, 2013 6:54 PM, Johnnyboy5 intermediatec...@gmail.com wrote: Goto the pie chart - double click on the pie - should be able to bring up a four tab choice box - select option the just adjust the angle in degrees of the first slice regards John On Thursday, 19 September 2013 18:46:52 UTC+1, Joseph wrote: Hi, I have a two slice pie chart and the first slice should face to the right centre horizontally. Can you provide a macro for this. Thanks for your help in advance. Regards, Joseph -- 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$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)
On Thursday, May 10, 2012 4:19:25 AM UTC-7, NOORAIN ANSARI wrote: Dear Group, Please find attached Interview questions and answers for MS Excel+VBA+MS Access+SQL Server. If any one have this type of question and answers, Kindly share with group. Thanks ! it really Help to me. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- 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$$ Re: Email Trigger ?
Aashish, try changing the port number in this line:Flds.Item(schema smtpserverport) = 465 see this site indicated by Ashish: http://www.rondebruin.nl/win/s1/cdo.htm Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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$$ Re: Email Trigger ?
'Ashish Kumar, thank you very much. Pls. add this code: Private Sub Worksheet_Calculate() If ThisWorkbook.ActiveSheet.Range(A1) 10 Then Call SendEmail Else End If End Sub 'and in cell A1, enter the formula: =RANDBETWEEN(1,15) 'and press F9 to test. 'I share an example to analyze. 'Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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$$ Re: Email Trigger ?
Bill, enable reference, as indicated Ashish Watve and keep the quotes () in their name and email in the email password. Basole. Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of minutes. I would like to have a small macro created so that when a certain cell is either = to a certain price, will automatically send me an email to my Gmail account with the message to be defined later. Anyone ? 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/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$$ Re: Read a Text file with delimiter as comma and import the infor into excel sheet
hi On Monday, November 5, 2007 11:52:56 PM UTC+5:30, SK wrote: Hello Everybody, I am new to Excel VBA. I am trying to read a text file in which columns are separated by commas, for eg: 1,2,3 2,3,4 3,4,5 4,5,6 I canwrite this to an Excel worksheet. So, final Excel sheet has 3 columns and 4 rows(number of rows depends on on how many entries we have in a text file). So the worksheet will look like: 1 | 2 | 3 2 | 3 | 4 3 | 4 | 5 4 | 5 | 6 If I specify the range of the cells for example B9, my first column starts from B9, second from C9 and thrid from D9. I want to do something different. I want to have different range set for diffferent column. Can I specify that the first column should populate in range B9:Bx((where x is the number of rows in the text file) and second coulmn populate in range G9:Gx(where x is the number of rows in the text file) and third column populates in range I9:Ix((where x is the number of rows in the text file). Thanks for your help in advance. ~SK -- 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.