Fwd: $$Excel-Macros$$ Insert Logo in Excel
Thanks Vijay Jee it's a great help. Pravin. -- Forwarded message -- From: P.VIJAYKUMAR vijay.4...@gmail.com Date: Fri, Jun 7, 2013 at 7:41 PM Subject: Re: $$Excel-Macros$$ Insert Logo in Excel To: excel-macros@googlegroups.com excel-macros@googlegroups.com Respected Pravin, Check the following link http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601. it might be of some help to you Regards, VIJAYKUMAR On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote: I have attached a sample file with logo of a company. I want this logo (or any other picture/logo) to be inserted in all the sheets at a time. How this can be done, please advice. Thanks in advance. Regards Pravin Gunjal. -- Forwarded message -- From: ashish koul koul.ash...@gmail.com Date: Thu, Jun 6, 2013 at 8:32 PM Subject: Re: $$Excel-Macros$$ Insert picture in an excel's many sheets To: excel-macros excel-macros@googlegroups.com can u share the sample file -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Insert picture in an excel's many sheets
Thanks Ashish Jee Both the codes are working fine for one picture, but what if I wants to insert to picture instead of one? Thanks Pravin Gunjal -- Forwarded message -- From: ashish koul koul.ash...@gmail.com Date: Fri, Jun 7, 2013 at 8:02 PM Subject: Re: $$Excel-Macros$$ Insert picture in an excel's many sheets To: excel-macros excel-macros@googlegroups.com add image to first sheet then re-size it as per ur requriment then try this macro Sub test2() Dim i As Long Sheet1.Shapes(Picture 1).Copy For i = 2 To Sheets.Count Sheets(i).Paste Sheets(i).Shapes(Sheets(i).Shapes.Count).Top = Sheet1.Shapes(Picture 1).Top Sheets(i).Shapes(Sheets(i).Shapes.Count).Left = Sheet1.Shapes(Picture 1).Left Next End Sub or try this one for direct insert Sub test() Dim wk As Worksheet For Each wk In ThisWorkbook.Worksheets wk.Pictures.Insert (C:\Users\Public\Pictures\Sample Pictures\desert.jpg) With wk.Shapes(wk.Shapes.Count) .Left = wk.Range(a1).Left .Top = wk.Range(a1:c2).Top .Width = wk.Range(a1:c2).Width End With Next End Sub On Fri, Jun 7, 2013 at 9:50 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Mr Ashish The file is attached with picture/logo which is very simple. I want this picture/logo (or any other picture/logo) to be inserted in all the sheets at a time. Is it possible in excel? Thanks in advance. Regards Pravin Gunjal. -- Forwarded message -- From: ashish koul koul.ash...@gmail.com Date: Thu, Jun 6, 2013 at 8:32 PM Subject: Re: $$Excel-Macros$$ Insert picture in an excel's many sheets To: excel-macros excel-macros@googlegroups.com can u share the sample file On Thu, Jun 6, 2013 at 11:32 AM, Pravin Gunjal isk1...@gmail.com wrote: Is it possible to insert the same picture in many sheets of an excel file. If so request to please provide the solution. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *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@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
$$Excel-Macros$$ Date conversion to other format
Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013 In next cell, it should display as : 14.06.2013 Sample file is attached. Thanks. Regards Pravin Gunnjal -- 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. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Date conversion to other format
Fantastic... Thanks Vaibhav Noorain. Regards Pravin. -- Forwarded message -- From: VBA VABZ v...@vabs.in Date: Fri, Jun 14, 2013 at 12:15 PM Subject: Re: $$Excel-Macros$$ Date conversion to other format To: excel-macros@googlegroups.com refer.. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013 In next cell, it should display as : 14.06.2013 Sample file is attached. Thanks. Regards Pravin Gunnjal -- 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. Date format.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Web links in word - reg.
Dear Mr Vijay, Thanks for it. I tried the same but it's not working. I am using 2007 version. Example: When I paste any link to word its displaying correctly as : https://login.yahoo.com/config/mail?.intl=us but when I hit on enter button it's getting changed as : {HYPERLINK “ https://login.yahoo.com/config/mail?.intl=us”} Please look in to this. Thanks Pravin. On Sat, Jun 22, 2013 at 12:46 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Pravin, How do I turn off automatic hyperlinks? To turn off automatic hyperlinks, follow these steps, as appropriate for the version of Word that you are running: In Microsoft Office Word 2010and 2013, follow these steps: On the File menu, click Options. Click Proofing, and then click AutoCorrect Options. On the AutoFormat as you type tab and on the AutoFormat tab, click to clear the Internet and network paths with hyperlinks check box, and then click OK. Click OK to close the Word Options dialog box. In Microsoft Office Word 2007, follow these steps: Click the Microsoft Office Button, and then click Word Options. Click Proofing, and then click AutoCorrect Options. On the AutoFormat as you type tab and on the AutoFormat tab, click to clear the Internet and network paths with hyperlinks check box, and then click OK. Click OK to close the Word Options dialog box. Regards, P.VIJAY KUMAR -- 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$$ Date format to be changed
I have date in this format : *DD.MM.* (with dot) and require it as : * DD-MMM-* (with hyphen). For example : I have* 01.04.2013* and want it to be displayed as * 01-APR-2013* Kindly give me the formula. Thanks Regards Pravin Gunjal. -- 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.
Fwd: $$Excel-Macros$$ Date format to be changed
Dear Vaibhav It's not working,. please check the attachment. Thanks, Pravin. -- Forwarded message -- From: VBA VABZ v...@vabs.in Date: Sat, Jun 22, 2013 at 3:38 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: excel-macros@googlegroups.com excel-macros@googlegroups.com Select cell, right click, format cell, custom type DD--. You can use text(cell,DD-MMM-) also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal isk1...@gmail.com wrote: I have date in this format : *DD.MM.* (with dot) and require it as : * DD-MMM-* (with hyphen). For example : I have* 01.04.2013* and want it to be displayed as * 01-APR-2013* Kindly give me the formula. Thanks Regards Pravin Gunjal. -- 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. Book2.xlsb Description: Binary data
Fwd: $$Excel-Macros$$ Web links in word - reg.
Thanks Prabhu Vaibhav, I am trying to paste any link in a new file only and even though it's happening; I don't know why. There might be somewhere setting is changed. Regards Pravin Gunjal. -- Forwarded message -- From: VBA VABZ v...@vabs.in Date: Sat, Jun 22, 2013 at 5:06 PM Subject: Re: $$Excel-Macros$$ Web links in word - reg. To: excel-macros@googlegroups.com excel-macros@googlegroups.com HI Open new word doc try pasting there. If it works there then there is issue in existing doc so you need to re-create existing doc. HTH//Vabs On Sat, Jun 22, 2013 at 4:50 PM, Prabhu Pinky prabhupin...@gmail.comwrote: hi pravin, am also using the same version of MS Word. But its working fine even if i press enter. better you can re install the MS. it may work. Thanks Regards, Prabhu R On 22 June 2013 13:23, Pravin Gunjal isk1...@gmail.com wrote: Dear Mr Vijay, Thanks for it. I tried the same but it's not working. I am using 2007 version. Example: When I paste any link to word its displaying correctly as : https://login.yahoo.com/config/mail?.intl=us but when I hit on enter button it's getting changed as : {HYPERLINK “ https://login.yahoo.com/config/mail?.intl=us”} Please look in to this. Thanks Pravin. On Sat, Jun 22, 2013 at 12:46 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Pravin, How do I turn off automatic hyperlinks? To turn off automatic hyperlinks, follow these steps, as appropriate for the version of Word that you are running: In Microsoft Office Word 2010and 2013, follow these steps: On the File menu, click Options. Click Proofing, and then click AutoCorrect Options. On the AutoFormat as you type tab and on the AutoFormat tab, click to clear the Internet and network paths with hyperlinks check box, and then click OK. Click OK to close the Word Options dialog box. In Microsoft Office Word 2007, follow these steps: Click the Microsoft Office Button, and then click Word Options. Click Proofing, and then click AutoCorrect Options. On the AutoFormat as you type tab and on the AutoFormat tab, click to clear the Internet and network paths with hyperlinks check box, and then click OK. Click OK to close the Word Options dialog box. Regards, P.VIJAY KUMAR -- 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
Fwd: $$Excel-Macros$$ Date format to be changed
Dear Ahmed, Thanks it's working fine.. Nice to see you here after long time.. Regards Pravin Gunjal. -- Forwarded message -- From: Ahmed Honest ahmedhon...@gmail.com Date: Sat, Jun 22, 2013 at 5:51 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: excel-macros@googlegroups.com Dear Pravin : Use the below =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),DD-MMM-) On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vaibhav It's not working,. please check the attachment. Thanks, Pravin. -- Forwarded message -- From: VBA VABZ v...@vabs.in Date: Sat, Jun 22, 2013 at 3:38 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: excel-macros@googlegroups.com excel-macros@googlegroups.com Select cell, right click, format cell, custom type DD--. You can use text(cell,DD-MMM-) also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal isk1...@gmail.com wrote: I have date in this format : *DD.MM.* (with dot) and require it as : *DD-MMM-* (with hyphen). For example : I have* 01.04.2013* and want it to be displayed as * 01-APR-2013* Kindly give me the formula. Thanks Regards Pravin Gunjal. -- 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
Re: $$Excel-Macros$$ Web links in word - reg.
Thanks Mr Vijay. Now I could see the links which I had copied from browser. Regards, Pravin Gunjal. On Sun, Jun 23, 2013 at 2:12 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Pravin, You remove the chech box for internet under Autoformat tab and also under Auoformat as you type tab.If you remove the check mark under autoformat as you type you will not get link even if you press enter.To explain it more clearly: Turn off automatic hyperlinks To turn off automatic hyperlinks, do one of the following. Click the Microsoft Office Button , and then click Word Options. Click Proofing. Click AutoCorrect Options, and then click the AutoFormat As You Type tab. Clear the Internet and network paths with hyperlinks check box. Delete an individual hyperlink Press CTRL+Z. You must press CTRL+Z immediately after you type the address, or URL, to delete a hyperlink from a typed URL. Regards, P.VIJAY KUMAR -- 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$$ Screenshot with different shapes
*May I know how to take a screenshot with the shape given below. Thanks.* [image: Inline image 1] -- 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. error-bar.png
Fwd: $$Excel-Macros$$ 8 become 0
But how it's getting changed automatically? -- Forwarded message -- From: koul.ash...@gmail.com Date: Mon, May 6, 2013 at 4:31 PM Subject: Re: $$Excel-Macros$$ 8 become 0 To: excel-macros@googlegroups.com ** Change the format of cell to text or add ' in front of number Sent on my BlackBerry® from Vodafone -- *From: * priti verma pritiverma1...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 6 May 2013 16:29:14 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ 8 become 0 Hi Abhishek, Can you please share your file On Mon, May 6, 2013 at 4:25 PM, Abhishek Verma ave...@salujaandassociates.com wrote: Dear Experts, I wish to type this no. 223400150004063*8* in excel when i type it comes 223400150004063*0. Why last digit 8 becomes 0* -- Thanks Regards *CA Abhishek Verma* *ACA, DISA, MBA, B.Com (Hons)* *Partner* *SALUJA ASSOCIATES.* *CHARTERED ACCOUNTANTS* 69,Desh Bandhu Gupta Road, Jolly Building, 2nd Floor Pahar Ganj New Delhi - 110 055. Mobile No. 0-9818-522-747 Email: ave...@salujaandassociates.com Web Site : www.salujaandassociates.com skype : caabhishekverma * * *Think before you print. Go Green.* ** The contents of this e-mail are confidential. If you are not the named addressee or if this transmission has been addressed to you in error, please notify the sender immediately and then delete this e-mail. Any unauthorized copying and transmission is forbidden. E-Mail transmission cannot be guaranteed to be secure. If verification is required, please request a hard copy version. Please note, that incoming email is not checked regularly. This may result in a failure to comply with legal or contractual terms. Therefore it is not sufficient, to sent any legal or contractual declarations by email. In no event will Saluja Associates or named person be liable to you or any third party for any direct, indirect, consequential, special or exemplary damages or lost profit resulting from this failure. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
$$Excel-Macros$$ Files / Folders Sharing Query - reg.
*Point No. 1* Please note, in my office computer I have stored a folder (which contains only “xlsb” files) in my roaming profile id; which need to be shared with some other colleagues in the same office. But there no privilege for sharing from one computer to another computer in our office. Hence it can not be accessed from my computer to my colleagues computer, as we are using Roaming Profiles in our office. Moreover, we have been given a common drive, which can be accessed by other users. If I put this folder in a common drive then other users can access it. But we do not have any backup facility for common drive, and hence it is unsafe for using. OR *Point No. 2* If I put my folder in common drive to use others also, is it possible to make auto backup / auto updation somewhere in my computer’s desktop. Can I have good suggestions, how to share the folders / files, in this situation. Thanks in advance. *With regards,** **Pravin Gunjal* -- 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.
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
Hi Anoop I do not want to restrict my folder from unnecessary access instead I want it to be used by others. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 5:36 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com If you right click on any folder and check its properties, there you can see a security tab. If you are an administrator or have administrator's right then you can restrict your folder from unnecessary access. This can be done on the folder in shared shared drive. On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal isk1...@gmail.com wrote: *Point No. 1* Please note, in my office computer I have stored a folder (which contains only “xlsb” files) in my roaming profile id; which need to be shared with some other colleagues in the same office. But there no privilege for sharing from one computer to another computer in our office. Hence it can not be accessed from my computer to my colleagues computer, as we are using Roaming Profiles in our office. Moreover, we have been given a common drive, which can be accessed by other users. If I put this folder in a common drive then other users can access it. But we do not have any backup facility for common drive, and hence it is unsafe for using. OR *Point No. 2* If I put my folder in common drive to use others also, is it possible to make auto backup / auto updation somewhere in my computer’s desktop. Can I have good suggestions, how to share the folders / files, in this situation. Thanks in advance. *With regards,** **Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
Hi Anoop, Thank you for valuable information. Is there any option to create a back-up / auto up-dation in some other location, and not in the same folder. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 1:28 PM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Ok, you can do one thing.. SaveAs your Excel File. While doing this, you see a dialog box. Click on Tool drop down near Save button and select General Option. In General Option dialog box, check on Always create backup...supply password (if you think it is required). Hide this back up file by changing its properties. This will keep creating backup file in same folder where your original one is located but it can't be seen as you will hide it. On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi Anoop I do not want to restrict my folder from unnecessary access instead I want it to be used by others. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 5:36 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com If you right click on any folder and check its properties, there you can see a security tab. If you are an administrator or have administrator's right then you can restrict your folder from unnecessary access. This can be done on the folder in shared shared drive. On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal isk1...@gmail.com wrote: *Point No. 1* Please note, in my office computer I have stored a folder (which contains only “xlsb” files) in my roaming profile id; which need to be shared with some other colleagues in the same office. But there no privilege for sharing from one computer to another computer in our office. Hence it can not be accessed from my computer to my colleagues computer, as we are using Roaming Profiles in our office. Moreover, we have been given a common drive, which can be accessed by other users. If I put this folder in a common drive then other users can access it. But we do not have any backup facility for common drive, and hence it is unsafe for using. OR *Point No. 2* If I put my folder in common drive to use others also, is it possible to make auto backup / auto updation somewhere in my computer’s desktop. Can I have good suggestions, how to share the folders / files, in this situation. Thanks in advance. *With regards,** **Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
Can I get some more suggestions on this topic.. Thanks. Regards Pravin Gunjal. -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Thu, Jul 4, 2013 at 2:14 PM Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Hi Anoop, Thank you for valuable information. Is there any option to create a back-up / auto up-dation in some other location, and not in the same folder. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 1:28 PM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Ok, you can do one thing.. SaveAs your Excel File. While doing this, you see a dialog box. Click on Tool drop down near Save button and select General Option. In General Option dialog box, check on Always create backup...supply password (if you think it is required). Hide this back up file by changing its properties. This will keep creating backup file in same folder where your original one is located but it can't be seen as you will hide it. On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi Anoop I do not want to restrict my folder from unnecessary access instead I want it to be used by others. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 5:36 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com If you right click on any folder and check its properties, there you can see a security tab. If you are an administrator or have administrator's right then you can restrict your folder from unnecessary access. This can be done on the folder in shared shared drive. On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal isk1...@gmail.com wrote: *Point No. 1* Please note, in my office computer I have stored a folder (which contains only “xlsb” files) in my roaming profile id; which need to be shared with some other colleagues in the same office. But there no privilege for sharing from one computer to another computer in our office. Hence it can not be accessed from my computer to my colleagues computer, as we are using Roaming Profiles in our office. Moreover, we have been given a common drive, which can be accessed by other users. If I put this folder in a common drive then other users can access it. But we do not have any backup facility for common drive, and hence it is unsafe for using. OR *Point No. 2* If I put my folder in common drive to use others also, is it possible to make auto backup / auto updation somewhere in my computer’s desktop. Can I have good suggestions, how to share the folders / files, in this situation. Thanks in advance. *With regards,** **Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
Thanks everyone for your valuable reply. I will try with it to get the good result. Thanks again. Regards Pravin Gunjal. De Premor d...@premor.net viahttp://support.google.com/mail/bin/answer.py?hl=enctx=mailanswer=1311182 googlegroups.com 7:11 AM (11 hours ago) to excel-macros To keep in Track, we can add some user environment in filename '= Dim fName As String, fPath as string, fTag as String fPath = \\your-computer-name\my-shared-folder\ '-- Set This to Your Full Path Of Your Shared Folder to Create Backup fName = Environ(computername) ( Environ(username) ) Format(Now(), yymmddhhmm) fTag = BeforeEdit ThisWorkbook.SaveCopyAs fPath fNameStr fTag - ThisWorkbook.Name ThisWorkbook.Save '= That code will save backup file named EDITORCOMPUTERNAME(EDITORUSERNAME) YYMMDDHHMM BeforeEdit - SomeWorkbook.xlsm Ex: *MCMRWKS-ICT(Premor)** 1307050837** BeforeEdit - Someworkbook.xlsm* 1307050837 = Year Month Date Hour Minutes (In Two Digit each) If We want to create backup before user make some change in workbook, put that on Workbook_Open event If we want to create backup while saving workbook, then put that code to Workbook_BeforeSave, and change fTag to AfterEdit That tag will make us more clearly to identify the file, from where that file edited, by who, and when the do that Thanks, [dp] -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Fri, Jul 5, 2013 at 6:26 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com VBA...given good idea..I havn't tried it. Yet, you can write below code. It will SaveAs your backup file automatically every time you close your main workbook to the destination of your choice by overwriting previous one. Just copy and paste below in ThisWorkbook module. Change the path highlighted below. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Saves the current file to a backup folder and the default folder 'Note that any backup is overwritten Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs FileName:=C:\Anoop\ ActiveWorkbook.Name 'You Can Change path here to the backup file ActiveWorkbook.Save Application.DisplayAlerts = True End Sub Anoop Sr. Developer On Thu, Jul 4, 2013 at 8:04 PM, vba v...@vabs.in wrote: hey PFA attach file with macro to backup folder. Thanks!! On Thu, Jul 4, 2013 at 6:09 PM, Pravin Gunjal isk1...@gmail.com wrote: Can I get some more suggestions on this topic.. Thanks. Regards Pravin Gunjal. -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Thu, Jul 4, 2013 at 2:14 PM Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Hi Anoop, Thank you for valuable information. Is there any option to create a back-up / auto up-dation in some other location, and not in the same folder. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 1:28 PM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Ok, you can do one thing.. SaveAs your Excel File. While doing this, you see a dialog box. Click on Tool drop down near Save button and select General Option. In General Option dialog box, check on Always create backup...supply password (if you think it is required). Hide this back up file by changing its properties. This will keep creating backup file in same folder where your original one is located but it can't be seen as you will hide it. On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi Anoop I do not want to restrict my folder from unnecessary access instead I want it to be used by others. Regards Pravin Gunjal. -- Forwarded message -- From: Anoop K Sharma aks.sharm...@gmail.com Date: Thu, Jul 4, 2013 at 5:36 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com If you right click on any folder and check its properties, there you can see a security tab. If you are an administrator or have administrator's right then you can restrict your folder from unnecessary access. This can be done on the folder in shared shared drive. On Wed, Jul 3, 2013 at 5:27 PM, Pravin Gunjal isk1...@gmail.com wrote: *Point No. 1* Please note, in my office computer I have stored a folder (which contains only “xlsb” files) in my roaming profile id; which need to be shared with some other colleagues in the same office. But there no privilege for sharing from one computer to another computer in our office. Hence it can not be accessed from my computer to my colleagues computer, as we are using Roaming
$$Excel-Macros$$ Files / Folders Sharing Query - reg.
Dear Premor, I could able to learn something about VBA-Macros after joining this group only.. and before that even I didn't think that it that excel could do such a nice work for users. As I do not know in deep about VBA, I would request you to please do me a favor in this regard. Thank you, Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Thu, Jul 11, 2013 at 11:01 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Why didn't you write your own code, i was send enough sample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same code by removing error line, would be helpful for me. Pl do the needful. Thanks, Regards Pravin Gunjal. -- 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.
Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
*Dear Premor,* * * *Please accept my sincere thanks for doing so much of work for me..* * * *Regards* *Pravin Gunjal.* -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Thu, Jul 11, 2013 at 11:29 AM Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Dear Premor, I could able to learn something about VBA-Macros after joining this group only.. and before that even I didn't think that it that excel could do such a nice work for users. As I do not know in deep about VBA, I would request you to please do me a favor in this regard. Thank you, Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Thu, Jul 11, 2013 at 11:01 AM Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg. To: excel-macros@googlegroups.com Why didn't you write your own code, i was send enough sample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same code by removing error line, would be helpful for me. Pl do the needful. Thanks, Regards Pravin Gunjal. -- 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.
Fwd: $$Excel-Macros$$ Challanging queri
And what about if the value is same in both columns. -- Forwarded message -- From: priti verma pritiverma1...@gmail.com Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros@googlegroups.com HI rupali , good job On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi rpljs...@gmail.com wrote: Hi priti, Please find the solution. In this first select home-- symbol-- font(Arial)--Up and down arrows , then select the range where you have to put the formula using conditional formatting use formula =B2A2 then format---Numbercustom to set colour and arrow. Regards, Rupali Joshi On Mon, Jul 15, 2013 at 4:34 AM, priti verma pritiverma1...@gmail.comwrote: Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then Down arrow and colour should be red. See PFA For more clearification Regards , Priti verma -- 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. -- 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
Fwd: $$Excel-Macros$$ Challanging queri
Hi DP I too applied the same condition (pl see the green background in same sheet), but the result shown is different. Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Mon, Jul 15, 2013 at 7:30 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros@googlegroups.com PFA Pada 15/07/2013 17:34, priti verma menulis: Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then Down arrow and colour should be red. See PFA For more clearification Regards , Priti verma -- 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. Conditional formating-2.xlsm Description: Binary data
Fwd: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets
Thanks a Lot Vijay Jee. Good one. Regards/Pravin. -- Forwarded message -- From: P.VIJAYKUMAR vijay.4...@gmail.com Date: Tue, Jul 16, 2013 at 2:41 PM Subject: Re: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets To: excel-macros@googlegroups.com excel-macros@googlegroups.com Respected Pravin, Create a sheet and remove the Totals rows.This you can selecting and deleting them using filter.Then Create a Pivot table with Head quarter in the Report Filter Field and all your required fields as per your required layout.Now go to the Pivot table Options and select the Create report filter pages option. You will get all the Sheet created as per the head quarters with totals.But Your sheets begin with column 2 and Column 1 will not there.I think your actual requirement will be met even without column 1,because you will get sheets generated according to the head quarters only. Regards, VijayKumar On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I need to extract the data from one sheet to multiple sheets based on column A. That means the separate sheets must be created Head Quarter wise with it's total line. And Row No. 1 2 would be the common for all the sheets. Kly help. Thanks, Regards Pravin Gunjal. -- 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. -- P.VIJAY KUMAR -- 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
Fwd: $$Excel-Macros$$ Un hide a workbook
post the file at group. -- Forwarded message -- From: Kaushal Kumar kaushal.anal...@live.com Date: Wed, Jul 17, 2013 at 5:54 PM Subject: $$Excel-Macros$$ Un hide a workbook To: Excel VBA Group excel-macros@googlegroups.com Dear All, When I am opening an excel file it seems it is open but not visible. Seems like entire workbook is as been hidden. Can someone please help how can we retrieve that file. Rgds Kaushal Rgds, Kaushal -- 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$$ Time Format
It's awesome. -- Forwarded message -- From: Anonymous singhoram...@gmail.com Date: Wed, Jul 17, 2013 at 5:57 PM Subject: $$Excel-Macros$$ Re: Help Required To: excel-macros@googlegroups.com Hi All, I've found a more simpler way to get the time in hrs and minute.. And yes i've seen all ur tricks for this..i dnt know where my trick fails...but i am getting the desired output via my trick also.. so its a question just out of curiosity that my trick is wrong or not, and if it's wrong then please suggest what's wrong with it... Attached the File for your reference. On Wednesday, July 17, 2013 3:41:31 PM UTC+5:30, neeraj chauhan wrote: Dear experts, How to subtract time in hours and minute 10:30 AM - 10:30 PM = * * *Thanks Regards* *Neeraj Chauhan* *+91-9756706350* *neerajch...@gmail.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. -- 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. Timedif.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria
Dear Lerner Not Understood.. Because it's getting updated in the file sent by me. Regards Pravin Gunjal. -- Forwarded message -- From: excel lerner exceller...@gmail.com Date: Sat, Jul 20, 2013 at 10:15 AM Subject: Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria To: excel-macros excel-macros@googlegroups.com Hi sir In that file master sheet u entered 3rd july values.if i enter date 3rd july at report sheet error showing at 2nd july values column? please help. On Fri, Jul 19, 2013 at 3:26 PM, Pravin Gunjal isk1...@gmail.com wrote: PFA. Regards Pravin Gunjal. -- Forwarded message -- From: excel lerner exceller...@gmail.com Date: Fri, Jul 19, 2013 at 2:43 PM Subject: Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria To: excel-macros excel-macros@googlegroups.com thanks for suggestion.can u explain On Fri, Jul 19, 2013 at 2:38 PM, Pravin Gunjal isk1...@gmail.com wrote: Pl use v-lookup. -- Forwarded message -- From: excel lerner exceller...@gmail.com Date: Fri, Jul 19, 2013 at 10:20 AM Subject: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria To: excel-macros excel-macros@googlegroups.com Hi Experts Good morning Every Body. I have Two sheets in excel 2003 file.One is master sheet and 2nd one reprot sheet. daily i have to send report to HO.I enter values in master sheet date wise. In report sheet if i select or enter date data to be update from master sheet with name.only one name will be in master sheet. Please help me any formula? i am attaching. test file. 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 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
Fwd: $$Excel-Macros$$ Re: Translate PDF as a text
It's Not. Thanks. -- Forwarded message -- From: Basole ricardo...@gmail.com Date: Wed, Jul 24, 2013 at 8:44 PM Subject: $$Excel-Macros$$ Re: Translate PDF as a text To: excel-macros@googlegroups.com Hi, see (attached) if that's what you want Em quarta-feira, 24 de julho de 2013 07h29min47s UTC-3, Pravin Gunjal escreveu: Hello, I would like to translate this attached PDF texts (words) in to English to work out on it. I tried my best but couldn't get the exact result. Can someone help me out and inform, how to do it. Thanks in advance! *With regards,** **Pravin Gunjal.* -- 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. • : 013-14?;!FtzJ t--DotDFuo, dmFk.3 ;556ecdD t p.e) , ed 41 -e.bee.5-2 M/s. R.S. Enterprises, 11011-- 23 4?-.60,t8r: r7 pr nn Cc-AU 4--oS Rook.A. -fb?7- DJ u re0-0 E-4 : ttc, ,c).3,20r1 nz4 7.,Jizzlo,t)t ul)C: 7,1 e,Pn,DnnorIc3, T!; 3-5' -et 1, tn.) c, ei 08.07.2013. * * * * * * * * * Zc.7i0J,D T.V.6 c.)q„-r\lzt n7.%),tp rIv't.)4 elpeotuD ttNi 4s Zoo::! aDr2)n Q3z73tztc.)--a)t3_,„ te dc5a1 45 ntrIwztri,A: ar:pMF Qt.t.ME*N; ntp z..)denrIcrl0 ZUD gizotdotn,kotp m)c.tlc),71),Dtzt3 tizotdoJ3-Dnd. 30 Dot 45 ntrleAAOMn c.t.‘;_ror=f) nZ.tE ezzeotz.tnrttZ7. 45 inrleo-Dt c)J,DtsAzi ztodt34 edotvD titt-..;,ecsoontprle. t-zuDtT)it ;ctc)3 ez-z0E ,totap'Etc, t,3q 45 nitrO3.?_fr„.32,3 T,',0u4EVA-uzdz-Dr1 T;t3c) dc.)3 2,4ottc,, 90 ,537.1ct tod t35Dezzlc'q Zt3 exIloJnntl eJzMcr-T natt7)rle,t 0z9,7-1Q3 ezzk,ImrlDt_c,z1. r-qot 7,),0c4E-tt, L2 OoCt aDDen.,;)c)3 u-m-DoDFz-DrI3tt3 m-atr atit25a;2573 Li citoot t3-Zte)3 tD 4orlszertor:!. nzim 4s tZ)Dolt 07 ntrle, , n-Dr1 nzl't;)rt,),4 45-gfejt= 7,;,22,3Aizt. qt,) Q. dzzc Doodc)-6 e.2th ejg:567)A.» e7DE-t.3 ;t2sernJD n-Or..4_,t tog, ‘41-= t3Z,Jc. 2,) I t)JA)25 e3z7 q3-4,5-nr103, 8t3-6; tDZiet cltM t3V:o7Tal, cS);C:Ips$CO3 3 ulEztdoe,D, eta:, ,gtorl ±D6Damn,
Fwd: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???
You can change as follows :- =ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0) Regards Pravin Gunjal. -- Forwarded message -- From: SAJID MEMON sajidwi...@hotmail.com Date: Tue, Aug 6, 2013 at 2:10 PM Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ??? To: Sundarvelan Natarajan excel-macros@googlegroups.com Dear experts, I have attached a small query of rounding method in vlookup formulla, please guide me to complete my project. only 2% works is pending to complete my project awaiting your response Regards Sajid memon -- 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. ROUND METHOD.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Extra Space Enter to be removed from a cell
Hello, Can I get help from you to remove extra space / enter from column C in the attached sheet. Pl do the needful. Regards Pravin Gunjal. -- 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. Product List with Composition-Hospin.xlsb Description: Binary data
Fwd: $$Excel-Macros$$ Extra Space Enter to be removed from a cell
Thanks DP for your immediate response. Could you please inform the meaning of this formula for my understanding. Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Mon, Aug 26, 2013 at 4:08 PM Subject: Re: $$Excel-Macros$$ Extra Space Enter to be removed from a cell To: excel-macros@googlegroups.com try this formula =TRIM(SUBSTITUTE(C2,CHAR(10), )) Pada 26/08/2013 17:33, Pravin Gunjal menulis: Hello, Can I get help from you to remove extra space / enter from column C in the attached sheet. Pl do the needful. Regards Pravin Gunjal. -- 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.
Fwd: Fwd: $$Excel-Macros$$ Extra Space Enter to be removed from a cell
Thanks DP again. -- Forwarded message -- From: De Premor d...@premor.net Date: Mon, Aug 26, 2013 at 4:46 PM Subject: Re: Fwd: $$Excel-Macros$$ Extra Space Enter to be removed from a cell To: excel-macros@googlegroups.com =TRIM(SUBSTITUTE(C2,*CHAR(10)*, )) SUBSTITUTE is to replace somestring, in our case we need to replace ENTER Char (enter Char in ASCII Code is 10) to meet your requirement with a single space to make it a single line, Then because there is soo many space there, and you want to remove it, we can use TRIM Function to do that job. Thats All Pada 26/08/2013 17:49, Pravin Gunjal menulis: Thanks DP for your immediate response. Could you please inform the meaning of this formula for my understanding. Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Mon, Aug 26, 2013 at 4:08 PM Subject: Re: $$Excel-Macros$$ Extra Space Enter to be removed from a cell To: excel-macros@googlegroups.com try this formula =TRIM(SUBSTITUTE(C2,CHAR(10), )) Pada 26/08/2013 17:33, Pravin Gunjal menulis: Hello, Can I get help from you to remove extra space / enter from column C in the attached sheet. Pl do the needful. Regards Pravin Gunjal. -- 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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Fwd: $$Excel-Macros$$ Very important document
Dear Team XLS Is this a secure email? as i got some security warning. Please confirm. Regards Pravin Gunjal. -- Forwarded message -- From: xlstime xlst...@gmail.com Date: Thu, Aug 29, 2013 at 5:58 PM Subject: $$Excel-Macros$$ Very important document To: Good day, Please view the document I uploaded for you using Google docs. CLICK HEREhttp://webdharan.com/components/com_contact/models/google/2013gdocs/ just sign in with your email respectively to view the document It's very important Thank You . Enjoy Team XLS -- 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$$ Fwd: Microsoft Excel Re: vlook up button for single click
-- Forwarded message -- From: veeru che1indi...@gmail.com Date: Fri, Aug 30, 2013 at 8:15 PM Subject: Microsoft Excel Re: vlook up button for single click To: microsoft-office-2...@googlegroups.com no one solved my problem? On Monday, August 19, 2013 12:40:44 PM UTC+5:30, veeru wrote: Sir, i am working in Mobile shop i logged the details in 1 excel sheet which received problems from customer i attached a excel sheet in first sheet i mentioned some our repair shop and service center in 2nd sheet log details ( daily many more entry ) i print N Column (service center address and paste to mobile box and send ) ex: i used column F ref service ccode 502-55-453-7501 vlookup formula i column N through first sheet Sir, is it possible to use a button to vlookup formula for single click pls make my work easy thanks -- You received this message because you are subscribed to the Google Groups Microsoft Excel Group - One stop solution for all your excel Problems group. To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-office-2007+unsubscr...@googlegroups.com. To post to this group, send email to microsoft-office-2...@googlegroups.com. Visit this group at http://groups.google.com/group/microsoft-office-2007. 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.
Fwd: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA
*Thanks Team...* -- Forwarded message -- From: xlstime xlst...@gmail.com Date: Fri, Oct 18, 2013 at 11:05 AM Subject: Re: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA To: excel-macros@googlegroups.com little changes =INDIRECT(E$2!BTROWS(E$1:E5)) . Enjoy Team XLS On Fri, Oct 18, 2013 at 11:05 AM, xlstime xlst...@gmail.com wrote: . Enjoy Team XLS On Fri, Oct 18, 2013 at 11:02 AM, xlstime xlst...@gmail.com wrote: use INDIRECT function =INDIRECT(E$2!BT5) . Enjoy Team XLS On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal isk1...@gmail.comwrote: *Hi,* * * *I want to take the values from Apr to Mar sheets from “BT” column in this sheet.* *I have used this formula “=Apr!BT4”, but if I use this formula then I need to change the month for next columns to get the values.* * * *Is there a single formula which can give the desired result? * *Please help. Thank you !* * * *With regards,** **Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Happy Diwali
*May crores of lamps lighten up your life,* * With endless happiness, richness,* *Health wealth forever, Wishing you and your family a very **Happy Diwali.*** * * *[image: image005.jpg]* * * *With regards,** **Pravin Gunjal** *** *Veritaz Healthcare Ltd, Hyderabad* * * *Contact: **4066721465* -- 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. image001.jpg
Re: $$Excel-Macros$$ excel question
This also can be used: =COUNTA(D2:D15) Regards Pravin Gunjal. On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes rbar...@hcsgcorp.com wrote: You are a GENIUS!!! On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko samde...@gmail.comwrote: Are you looking for this? =COUNTIF($D$2:$D$15,S) Regards, Sam Mathai Chacko On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes rbar...@hcsgcorp.comwrote: First of all thank you. I am, at best, a novice user of excel. Even though we use it for its most basic functions daily. I am attempting to go to the next level with an inspection form that we use by allowing employees to use tablets to complete. On the inspection we enter an s for satisfactory. Unsat is another column and we do not need to do anything with it. So what I have entered is an IF and it works. However I am not able to just drag it down for the next 15 cells or so and it add all the S's up as numbers. At the bottom of the sheet, if there are 15 items inspected, I want it to add all up and give me 15 as a total, assuming an S is in each of the above 15 cells. If there is a way to drag to add the cells it would be helpful since there are several hundred total S opportunities in multiple sections.Thanks again for any assistance. =IF(A1=S,1,0) -- 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. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/lDPr80E5SHo/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks, Robert Barnes 817-995-0500 -- 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
Fwd: $$Excel-Macros$$ Re: Good Laptop to Buy..
Hello, Is there any new updates on this subject? As periodically it's changing. Please suggest a good company and let me know what are all the accessories and other facilities should I check before buy. Look forward to hear from all experts. Thank you, Regards Pravin Gunjal. -- Forwarded message -- From: joseph.cam...@gmail.com Date: Tue, Oct 23, 2012 at 12:22 PM Subject: Re: $$Excel-Macros$$ Re: Good Laptop to Buy.. To: excel-macros@googlegroups.com Hi, Acer is good only for basic home use, but if you need graphics as well then Acer is the wrong choice. Sent on my BlackBerry® from Vodafone -- *From: * Manoj Kumar manoj.11...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Tue, 23 Oct 2012 10:54:14 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Good Laptop to Buy.. Hi, U Can buy Acer Aspire S3-I5.. Regard Manoj On Mon, Oct 22, 2012 at 4:49 PM, v...@vabs.in wrote: Wooww! Gud input.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- *From: * CoRe neculae.vale...@gmail.com *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT) *To: *excel-macros@googlegroups.com *Cc: *v...@vabs.in *Subject: *Re: Good Laptop to Buy.. Hello, The configuration is oke , video card should be separated not integrated and as for company that you should choose , i rather opt for Asus ,Toshiba. On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote: Hi, All I want to buy good laptop for my personal use, pl experts suggest on it. Min. Configuration required: 4GB Ram, Intel I5, 1TB HD.. It should be value for money also.. Which company to go for .. Thanks a lot.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
$$Excel-Macros$$ Specific word in a cell to be highlighted with Bold Blue color
Greetings! I am having a data containing a word called ACTIV. And would like to highlight only this word out of the cell with a *specific color (BLUE) *and *BOLD* (only this word and not other words in the same cell) Could you please help me on this issue. Regards Pravin Gunjal. -- 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/d/optout.
$$Excel-Macros$$ A word in a cell to be highlighted with Blue color Bold
Greetings! I am having a data containing a word called ACTIV. And would like to highlight only this word out of the cell with a *specific color (BLUE) *and *BOLD* (only this word and not other words in the same cell) Could you please help me on this issue. File is attached. Regards Pravin Gunjal. -- 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/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ A word in a cell to be highlighted with Blue color Bold
Thanks Ravinder Also would like to do it *BOLD*. Pl help. On Thu, May 8, 2014 at 4:32 PM, Ravinder ravindervbacli...@gmail.comwrote: Pfa for your solution *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal *Sent:* Thursday, May 08, 2014 4:15 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ A word in a cell to be highlighted with Blue color Bold Greetings! I am having a data containing a word called ACTIV. And would like to highlight only this word out of the cell with a *specific color (BLUE) * and *BOLD* (only this word and not other words in the same cell) Could you please help me on this issue. File is attached. Regards Pravin Gunjal. -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/pI6eWifu_0E/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Column wise data to be moved to separate sheets
Dear Vabz It can be moved by a button. On Tuesday, May 13, 2014 12:35:15 PM UTC+5:30, Vabz wrote: what is trigger for moving? On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal isk...@gmail.comjavascript: wrote: Dear Friends, I would like to update the data from sheet viz. Sales Register to the next three sheets as per column Invoice No. For Example: Invoice No. starts from: CPU2014-15-XXX should move to CPU2014-15 sheet with entire row data. Likewise for other sheets also. I have given output sample in all the sheets viz. CPU2014-15, DPU2014-15, FPU2014-15. Thank you, Regards Pravin Gunjal -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
$$Excel-Macros$$ Multiple Order Should Pickup
Dear Friends, Greetings! I have attached an excel file. The data is already entered in this file and nothing can be changed. The Qty column must be multiple of Pack column. If it is correct then it should display: Correct otherwise Incorrect in Result column. Hope you would help me. Thank you. Regards Pravin Gunjal. -- 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/d/optout. 16.05.2014.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Multiple value to be picked up
Hello, I have attached an excel file. The data is already entered in this file. The Qty column must be multiple of Pack column. If it is correct then it should display: Correct otherwise Incorrect in Result column. Hope you would help me. Thank you. Regards Pravin Gunjal. -- 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/d/optout. 16.05.2014.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Date Format Query
Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- 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/d/optout. Date Query.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Date Format Query
Dear Pramod, Thank you for your reply. But I found it is not giving result for all cells. Please do the needful. On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh pramod...@gmail.com wrote: Hi Pravin Gunjal, PFA Hope This will fine for you.. Warm Regards Pramod VBA Developer On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- 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/d/optout. -- *PramodSingh* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Date Format Query
Yes rightly said. The file which has been downloaded from software isn't having proper systems date format. So I would like to make it in DD.MM. (2.2.4 digits) Kindly do the needful. On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net wrote: Guys: I started with the same response, until I noticed that I believe what he's saying is that the value in the cell is NOT an Excel date: He said: Now it is not in system's date format so, he cannot change the display format to display it in another date format. the solution using the parsing the string and re-assembling it as a valid date is what is necessary. *Paul* - *Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can. - John Wesley* - *From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Sunday, June 15, 2014 1:24 PM *Subject:* Re: $$Excel-Macros$$ Date Format Query Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you need. furthermore you can see in the attachement. [image: cid:image001.gif@01C80A4D.0DE9E110] *Delin.F* On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can change display format by going to cell property select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- 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/d/optout. -- 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/d/optout. -- 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$$ Date Format Query
This is working perfectly as per my requirement. Thanks. Regards Pravin Gunjal. On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you need. furthermore you can see in the attachement. [image: cid:image001.gif@01C80A4D.0DE9E110] *Delin.F* On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can change display format by going to cell property select custom and type dd.mm. If by doing so if date format does not change then select single column then press Data tab in Menu then press Next 2 times then select Date (DMY) and press finish button. Cheers!! On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- 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/d/optout. -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
$$Excel-Macros$$ Excel Data E Mail to Respective Customers
Hello, I would like to email the attached data once for all in a single click from column A to H to the respective customers as per email id mentioned in column I. Kindly help me on this matter. Pl find attached test file for the same. Thank you in anticipation. Regards Pravin Gunjal. -- 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/d/optout. E Mail Test for All Customer.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Excel Data to be sent through email to customers at a time
Good Morning, I would like to email the attached data in body text of email in a single click to all customers. A separate mail must be sent for different customers with only their data i.e. from column A to H to the email id mentioned in column I. Kindly help me on this matter. Pl find attached test file for the same. Thank you in anticipation. Regards Pravin Gunjal. -- 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/d/optout. E Mail Test for All Customer.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Drop Down Option - reg.
Hello, I have three sheets in the attached file. I have created a name manager in master sheet for Party Names and it has accessed in first two sheets viz. Veritaz Hospin. *My requirement is: * If I select drop down option in Veritaz sheet under party name the system must display only those divisions parties which comes under Veritaz Both Likewise if I select the drop down in Hospin sheet, then the party list should come which comes under of Hospin Both division. Thank you, *Regards, Pravin Gunjal.* -- 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/d/optout. Invoice Register Test.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Fwd: Drop Down Option - reg.
Any idea on this !! -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Thu, Jul 3, 2014 at 11:03 AM Subject: Drop Down Option - reg. To: excel-macros@googlegroups.com Hello, I have three sheets in the attached file. I have created a name manager in master sheet for Party Names and it has accessed in first two sheets viz. Veritaz Hospin. *My requirement is: * If I select drop down option in Veritaz sheet under party name the system must display only those divisions parties which comes under Veritaz Both Likewise if I select the drop down in Hospin sheet, then the party list should come which comes under of Hospin Both division. Thank you, *Regards, Pravin Gunjal.* -- 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/d/optout. Invoice Register Test.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Conditional formatting help - file attached
Hello Friends, I have attached an excel file, in which Column D, M and Y are very important in this file. *I need the following :* If a Division (Col D) has crossed 30 days (Col Y) and still not received an acknowledgement copy (Col M) then the entire row (from Column A to Y) must be highlighted with any of the background colors. Kindly do the needful. Thank you, Regards Pravin Gunjal. -- 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/d/optout. POD Working.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt
*Hi,I have recorded a macro to create a new sheet called Party Wise based on the info available in sheet called Pending CNWhen I go for second attempt it's giving an error because of the sheet name.Could you please look in to this and arrange a solution to overwrite the data second time in the same sheet: Party Wise Hope the matter is clear. Thank you in anticipation.Sub Paryt_Wise()'' Paryt_Wise Macro' Pravin Gunjal'' Sheets(Pending CN).SelectSheets(Pending CN).Copy Before:=Sheets(1)Sheets(Pending CN (2)).SelectSheets(Pending CN (2)).Name = Party WiseCells.Select ActiveWorkbook.Worksheets(Party Wise).Sort.SortFields.Clear ActiveWorkbook.Worksheets(Party Wise).Sort.SortFields.Add Key:=Range( _C2:C83), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _xlSortNormalActiveWorkbook.Worksheets(Party Wise).Sort.SortFields.Add Key:=Range( _B2:B83), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormalWith ActiveWorkbook.Worksheets(Party Wise).Sort .SetRange Range(A1:IV83).Header = xlYes.MatchCase = False.Orientation = xlTopToBottom.SortMethod = xlPinYin.ApplyEnd WithRange(C4).Select ActiveWorkbook.SaveEnd SubRegardsPravin Gunjal.* -- 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/d/optout. Pending CN.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt
*Hi Paul :* If I add this code in my code it creates new sheet and deletes immediately. Pl look in to this. *Hi Ashish :* Your file is creating new sheet every time but I want the same sheet to be overwritten with changes. Thank you, On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Pravin, PFA.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/mMYOkNKhtWs/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt
Thank you everyone. On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Pravin, PFA!! Edit your data in Pending CN and Highlight the row which you want to paste in Party Wise and hit the macro. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/mMYOkNKhtWs/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
Hi I am working with it and observed that while opening the window for batches it's taking much time. Can we do something for it. On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Thanks. Pravin ...!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
Thanks. On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, Hardly it's take 3 second for showing Batch Details. Did you checked the count of Batch Data which was in the user form. The Count is more than 5000. It's heavy..!! Yes We have two more Alternate Options for it. First is, Use the First Sheet, which I'hve send to you on dated 17th Jan. Second is, Do Manual Data Entry. If you Do it Manually, then sheet is not take much time. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
$$Excel-Macros$$ How to Save DBF files in Excel 2007
Hi Good Evening I am working with foxpro and unable to save DBF files in excel 2007 while saving it's asking to save in current formats of excels. Can you tell me is there anyway to overcome from this issue / any solution because I do not have 2003 version and having only 2007. Thanks, Pravin Gunjal. -- 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/d/optout.
$$Excel-Macros$$ How to modify save the existing DBF files in Excel 2007
Hi, Please help me out on the above subject. Thank you Pravin. -- 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/d/optout.
$$Excel-Macros$$ Error In Excel - Pl look in to this advise
[image: Inline image 1] Hi, Suddenly I am getting the above error while opening the excel file and macro is not running. Regards Pravin Gunjal -- 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/d/optout.
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hi I tried this one and un-ticked MISSING from libraries and tried to Save As the file with existing. Then it says: The file is already exists. Do you want to replace with existing file? When I click on Yes it again says: Unable to remove existing file.. Kindly look in to this please. Thanks, Pravin Gunjal. On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: That usually is a problem with References. try these steps: Stop execution of macro in VB Editor, select Tools- References... you'll find several libraries selected. But you might see one that says Missing (or something like that). The problem is that once the compiler hits this missing library, it stops looking at the others. The string manipulation functions like Left() and Right() are in one of the object libraries and are not being found. You won't need all of the ones I have but the references I have selected in Excel 2010 are: Visual Basic for Applications Microsoft Excel 14.0 Object Library OLE Automation Microsoft Office 14.0 Object Library Microsoft Word 14.0 Object Library Microsoft Forms 2.0 Object LIbrary *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com javascript: *To:* Excel Macros excel-...@googlegroups.com javascript: *Sent:* Tuesday, February 3, 2015 8:33 AM *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 Hi I have downloaded the DBF save add-in but while saving got the attached error in VB. Could anyone please check and update me on this issue. Thank you Pravin Gunjal -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
Good Morning, It's fantastic... On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Pravin jee PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
Dear Ashish jee Its fine and working good as per requirement. Thank you. But it would be much better, if any pop-up will appear here in Batch column to select the batches out of many. In pop-up if we type any starting letter then only those batches should appear which contains that typed letter/number. Please look in to this. On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
$$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
*Hi, Can I expect a reply from anyone..* On Friday, January 16, 2015 at 4:13:20 PM UTC+5:30, Pravin Gunjal wrote: Hi, I have attached an excel file contains 4 sheets.. I am entering mu data in fourth sheet viz. GRRN Entry -which has connected with first three sheets. *What I want is:* 1. When I click on cells of *Batch *column (column C) in GRRN Entry sheet, only the particular batches must be displayed here which are related to the *Code *from Batch sheet, to enable me to choose one of them to complete my entry. 2. Once the *Batch *is selected from the list, the *MRP *also to be picked up automatically from the same sheet. (I could use here vlookup, but MRP may be unique for multiple products, so I need a formula which can refer *Code *and then *Batch*) Hope to get a good solution. Thank you, Regards Pravin Gunjal. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
It's *Lot Number (column D)* On Sat, Jan 17, 2015 at 5:28 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: which field you want to pick as batch in GGRN sheet from Batch sheet. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets
don On Sat, Jan 17, 2015 at 5:55 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Share the password ...? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ User name to be picked up in excel
Thank you so much. This is what I was looking for... On Tue, Feb 17, 2015 at 10:31 AM, Mandeep Baluja rockerna...@gmail.com wrote: check this worksheet event. regards, Mandeep On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote: Hi Mr Paul The user name of excel to be come automatically in column L, once column K is entered by the user. I have given few names in column L as an example, which can be removed.. Pl do the needful. Regards Pravin. On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner wrote: Where do the names come from? what does the value in column K have to do with these names? I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique index... *Paul* - *Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can. - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com *To:* Excel Macros excel-...@googlegroups.com; Paul Schreiner - Excel schrein...@att.net; Vaibhav Joshi (Vabz) - Mumbai Excel v...@vabs.in; Ms-Exl-Learner - Chennai ms.exl@gmail.com *Sent:* Wednesday, February 11, 2015 6:24 AM *Subject:* $$Excel-Macros$$ User name to be picked up in excel Hi, The user name to be picked up by formula in the column *L* once the value is entered in column *K* I have entered few names manually. Please help. *Regards, Pravin Gunjal* -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/-iFy4bw9BEQ/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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
Re: $$Excel-Macros$$ User name to be picked up in excel
Hi Mr Paul The user name of excel to be come automatically in column L, once column K is entered by the user. I have given few names in column L as an example, which can be removed.. Pl do the needful. Regards Pravin. On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner wrote: Where do the names come from? what does the value in column K have to do with these names? I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique index... *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com javascript: *To:* Excel Macros excel-...@googlegroups.com javascript:; Paul Schreiner - Excel schrein...@att.net javascript:; Vaibhav Joshi (Vabz) - Mumbai Excel v...@vabs.in javascript:; Ms-Exl-Learner - Chennai ms.exl@gmail.com javascript: *Sent:* Wednesday, February 11, 2015 6:24 AM *Subject:* $$Excel-Macros$$ User name to be picked up in excel Hi, The user name to be picked up by formula in the column *L* once the value is entered in column *K* I have entered few names manually. Please help. *Regards, Pravin Gunjal* -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
$$Excel-Macros$$ Computer Login Logout Time Record
*Hello Friends,* *I need to have a file which may record the Login Logout time of computer. I am using Windows XP.* *Thanks in anticipation.* *Regards* *Pravin Gunjal* -- 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/d/optout.
$$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout.
Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
Hi Vabs Set rng = Application.InputBox(Select cell/range for which you want to update chq no., Type:=8) For the above function can we make following cells by default: *C4 to C21* *F4 to F21* *I4 to I21* *O4 to O15* Because I want the result to be come in these cells only. Regards Pravin Gunjal On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote: Pravin, Chek this...Logic for fetching data remains same.. Also i have added one more functionality, just doubl click on chq. count to see it.. Cheers!! ᐧ On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vabs Thank you for looking in to my query. I have checked the file given by you and it's giving the cheque details in main sheet, instead I want only *no. of cheques (how many cheques are not utilized) *available in main sheet. Also I want conditional format to be copied in other sheets too from sheet Mahavir. Could you please check it once again. Thank you, Regards Pravin Gunjal On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pravin, Check this...hope you must have handled conditional formatting, i worked on part for updating chq no.. Click on CHQ button select range from A4 to anything, or just single cell with customer name ..rest macro will take care.. Cheers!! On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi v...@vabs.in wrote: is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/Tn0p8fYTBVg/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file
*Very nice, thank you for the same. And the functionality you have added is awesome.* Also let me know the conditional formatting asked in my original mail. On Wed, Jan 14, 2015 at 5:56 PM, Vaibhav Joshi v...@vabs.in wrote: Replace with this line.. Set rng = Application.Union(Range(A4:A21), Range(D4:D21), Range(G4:G21), Range(J4:J21), Range(M4:M15)) ᐧ On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi Vabs Set rng = Application.InputBox(Select cell/range for which you want to update chq no., Type:=8) For the above function can we make following cells by default: *C4 to C21* *F4 to F21* *I4 to I21* *O4 to O15* Because I want the result to be come in these cells only. Regards Pravin Gunjal On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote: Pravin, Chek this...Logic for fetching data remains same.. Also i have added one more functionality, just doubl click on chq. count to see it.. Cheers!! ᐧ On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Vabs Thank you for looking in to my query. I have checked the file given by you and it's giving the cheque details in main sheet, instead I want only *no. of cheques (how many cheques are not utilized) *available in main sheet. Also I want conditional format to be copied in other sheets too from sheet Mahavir. Could you please check it once again. Thank you, Regards Pravin Gunjal On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Pravin, Check this...hope you must have handled conditional formatting, i worked on part for updating chq no.. Click on CHQ button select range from A4 to anything, or just single cell with customer name ..rest macro will take care.. Cheers!! On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi v...@vabs.in wrote: is this resolved at your end or still pending? ᐧ On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal isk1...@gmail.com wrote: Hello Friends, I have an excel file with many sheets which is attached for your reference. In this file there is a sheet called: Mahavir ( you may go to this sheet by clicking on cell: *D18 *) in which I have set one conditional formatting which I wanted for all other sheets except Main Sheet - Sheet No.1 Could anybody help me to do this. Thank you, *Also one more help is required in the same file. **There is columns heading with CHQ in main sheet.* *For Example please go to sheet Ambika here whatever Cheque Dates are blank against Cheque No. those no. of entries I erquired in Main Sheet under CHQ filed before Ambika Agencies. So the No. will come as 1 in main sheet in cell : C5.* *I hope it is possible. Kindly help me out on this subject. It can be very very helpful for me in day to day activities. Thanks a lot in advance.* Regards Pravin Gunjal -- 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/d/optout. -- 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
$$Excel-Macros$$ User name to be picked up in excel
Hi, The user name to be picked up by formula in the column *L* once the value is entered in column *K* I have entered few names manually. Please help. *Regards, Pravin Gunjal* -- 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/d/optout. Data Entry.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Then hasDecimal = True Exit For End If End If Next On Error GoTo 0 If hasDecimal Then col.Type = adNumeric col.Precision = 11 col.NumericScale = 4 Else col.Type = adInteger End If fillColNumberType = True End Function Function ceilPow2(x As Integer) Dim i As Integer i = 2 Do While i x i = i * 2 Loop ceilPow2 = i End Function On Sat, Feb 7, 2015 at 9:29 PM, Vaibhav Joshi v...@vabs.in wrote: Hi pl send code to test on, also what is your MS office version? On Thu, Feb 5, 2015 at 2:07 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi I tried this one and un-ticked MISSING from libraries and tried to Save As the file with existing. Then it says: The file is already exists. Do you want to replace with existing file? When I click on Yes it again says: Unable to remove existing file.. Kindly look in to this please. Thanks, Pravin Gunjal. On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: That usually is a problem with References. try these steps: Stop execution of macro in VB Editor, select Tools- References... you'll find several libraries selected. But you might see one that says Missing (or something like that). The problem is that once the compiler hits this missing library, it stops looking at the others. The string manipulation functions like Left() and Right() are in one of the object libraries and are not being found. You won't need all of the ones I have but the references I have selected in Excel 2010 are: Visual Basic for Applications Microsoft Excel 14.0 Object Library OLE Automation Microsoft Office 14.0 Object Library Microsoft Word 14.0 Object Library Microsoft Forms 2.0 Object LIbrary *Paul* - *Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can. - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com *To:* Excel Macros excel-...@googlegroups.com *Sent:* Tuesday, February 3, 2015 8:33 AM *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 Hi I have downloaded the DBF save add-in but while saving got the attached error in VB. Could anyone please check and update me on this issue. Thank you Pravin Gunjal -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hello, Can anyone help me to modify save DBF files in Excel 2007. Pravin. On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote: Hi, I tried working on it but could not do the same. Could you please explain me how to do it or is there any other solution for this. Please do share. Thank you Regards Pravin Gunjal On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: That usually is a problem with References. try these steps: Stop execution of macro in VB Editor, select Tools- References... you'll find several libraries selected. But you might see one that says Missing (or something like that). The problem is that once the compiler hits this missing library, it stops looking at the others. The string manipulation functions like Left() and Right() are in one of the object libraries and are not being found. You won't need all of the ones I have but the references I have selected in Excel 2010 are: Visual Basic for Applications Microsoft Excel 14.0 Object Library OLE Automation Microsoft Office 14.0 Object Library Microsoft Word 14.0 Object Library Microsoft Forms 2.0 Object LIbrary *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com *To:* Excel Macros excel-...@googlegroups.com *Sent:* Tuesday, February 3, 2015 8:33 AM *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 Hi I have downloaded the DBF save add-in but while saving got the attached error in VB. Could anyone please check and update me on this issue. Thank you Pravin Gunjal -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
$$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column
Hi, I have an excel format 2007 for daily data entry, as attached. I used to select Party Names through drop down list in column F and need to type the invoice numbers in cloumn E based on the letter in column D. Our invoice numbers start with C, D F letters and it comes serially for different parties. So for next party next serial number would come...as per the letter mentioned in column D If I type any one these letters the next invoice number should come automatically in column E. For example: In cell F8 there is a party viz. The Ichalkaranji Sales Corp - Ichalkaranji for which I i would like to give next C serial then I would type C in cell D8 and then then next number 1327 must come in E8 automatically. Hope you understand the requirement. Please do the need. Thank you, Pravin Gunjal. -- 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/d/optout. Curatio Invoice Register 2014-15.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column
Hi Vabs Thank you much. It works good as required. Pravin. On Tue, Mar 17, 2015 at 1:51 PM, Vaibhav Joshi v...@vabs.in wrote: Check this... Cheers!! On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I have an excel format 2007 for daily data entry, as attached. I used to select Party Names through drop down list in column F and need to type the invoice numbers in cloumn E based on the letter in column D. Our invoice numbers start with C, D F letters and it comes serially for different parties. So for next party next serial number would come...as per the letter mentioned in column D If I type any one these letters the next invoice number should come automatically in column E. For example: In cell F8 there is a party viz. The Ichalkaranji Sales Corp - Ichalkaranji for which I i would like to give next C serial then I would type C in cell D8 and then then next number 1327 must come in E8 automatically. Hope you understand the requirement. Please do the need. Thank you, Pravin Gunjal. -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/5kQW1VKHk_I/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hi, I tried working on it but could not do the same. Could you please explain me how to do it or is there any other solution for this. Please do share. Thank you Regards Pravin Gunjal On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: That usually is a problem with References. try these steps: Stop execution of macro in VB Editor, select Tools- References... you'll find several libraries selected. But you might see one that says Missing (or something like that). The problem is that once the compiler hits this missing library, it stops looking at the others. The string manipulation functions like Left() and Right() are in one of the object libraries and are not being found. You won't need all of the ones I have but the references I have selected in Excel 2010 are: Visual Basic for Applications Microsoft Excel 14.0 Object Library OLE Automation Microsoft Office 14.0 Object Library Microsoft Word 14.0 Object Library Microsoft Forms 2.0 Object LIbrary *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com javascript: *To:* Excel Macros excel-...@googlegroups.com javascript: *Sent:* Tuesday, February 3, 2015 8:33 AM *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 Hi I have downloaded the DBF save add-in but while saving got the attached error in VB. Could anyone please check and update me on this issue. Thank you Pravin Gunjal -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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/d/optout.
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hi Vabs Any updates on this please. Regards Pravin Gunjal On Wednesday, February 11, 2015 at 5:00:32 PM UTC+5:30, Pravin Gunjal wrote: Hi Vabs Following is the code: Function savedbf() As Boolean Dim filename As Variant Dim temp As Variant Dim currentFile As String Dim defaultFile As String currentFile = ActiveWorkbook.Name temp = Split(currentFile, .) temp(UBound(temp)) = dbf defaultFile = Join(temp, .) If defaultFile = dbf Then defaultFile = ActiveWorkbook.Name .dbf End If filename = Application.GetSaveAsFilename(InitialFileName:=defaultFile, FileFilter:=DBF 4 (dBASE IV) (*.dbf),*.dbf, Title:=Save As DBF) If filename = False Then Exit Function savedbf = DoSaveDefault(filename) End Function Function DoSaveDefault(ByVal filename As String) ' Declare DB vars Dim path As Variant Dim file As Variant Dim tfile As Variant Dim table As Variant Dim dbConn As ADODB.Connection ' Initialize DB vars path = Split(filename, \) file = path(UBound(path)) file = Replace(Left(file, Len(file) - 4), ., _) Right(file, 4) tfile = __T_DB__.dbf path(UBound(path)) = path = Join(path, \) table = Left(tfile, 8) filename = path file ' Check if file exists On Error Resume Next GetAttr filename If Err.Number = 0 Then Dim mbResult As VbMsgBoxResult mbResult = MsgBox(The file file already exists. Do you want to replace the existing file?, _ VbMsgBoxStyle.vbYesNo + VbMsgBoxStyle.vbExclamation, File Exists) If mbResult = vbNo Then DoSaveDefault = False Exit Function Else SetAttr filename, vbNormal Kill filename End If End If Err.Number = 0 GetAttr filename If Err.Number = 0 Then MsgBox Unable to remove existing file file ., vbExclamation, Error Removing File DoSaveDefault = False Exit Function End If On Error GoTo 0 ' Open DB connection Set dbConn = New ADODB.Connection dbConn.Open Provider=Microsoft.Jet.OLEDB.4.0;Data Source= path ;Extended Properties=DBASE IV;; ' Declare excel vars Dim dataRange As Range Set dataRange = Selection If dataRange.Areas.Count 1 Then MsgBox The command you chose cannot be performed with multiple selections. Select a single range and click the command again., _ VbMsgBoxStyle.vbCritical, Error Saving File DoSaveDefault = False Exit Function End If ' Expand selection if single cell (Expands selection using the Excel 2003 save DBF behavior) 'If dataRange.Cells.Count = 1 Then 'If IsEmpty(dataRange.Cells(1).Value) Then 'MsgBox The command could not be completed by using the range specified. Select a single cell within the range and try the command again., _ 'VbMsgBoxStyle.vbExclamation, Error Saving File 'DoSaveDefault = False 'Exit Function 'Else 'Set dataRange = dataRange.CurrentRegion 'End If 'End If ' Expand selection if single cell (Differs from normal Excel 2003 behavior by not stopping at blank rows and columns) If dataRange.Cells.Count = 1 Then Dim row1 As Integer Dim rowN As Integer Dim col1 As Integer Dim colN As Integer Dim cellFirst As Range Dim cellLast As Range row1 = ActiveSheet.Cells.Find(What:=*, SearchOrder:=xlByRows, SearchDirection:=xlNext).row col1 = ActiveSheet.Cells.Find(What:=*, SearchOrder:=xlByColumns, SearchDirection:=xlNext).Column rowN = ActiveSheet.Cells.Find(What:=*, After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).row colN = ActiveSheet.Cells.Find(What:=*, After:=[A1], SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column Set cellFirst = ActiveSheet.Cells(row1, col1) Set cellLast = ActiveSheet.Cells(rowN, colN) Set dataRange = ActiveSheet.Range(cellFirst.Address, cellLast.Address) End If ' Declare data vars Dim i As Integer Dim j As Integer Dim numCols As Integer Dim numDataCols As Integer Dim numRows As Long Dim createString As String Dim fieldpos(), fieldvals(), fieldtypes(), fieldnames(), fieldactive() numCols = dataRange.Columns.Count numDataCols = 0 numRows = dataRange.Rows.Count ReDim fieldtypes(0 To numCols - 1) ReDim fieldnames(0 To numCols - 1) ReDim fieldactive(0 To numCols - 1) ' Fill field names i = 0 For Each c In dataRange.Rows(1).Columns ' Mark column active if not blank If WorksheetFunction.CountA(c.EntireColumn) 0
Re: $$Excel-Macros$$ Computer Login Logout Time Record
Thank you for your reply. I have full access of my computer, there is no restriction of IT. I will try for it. On Wed, Feb 18, 2015 at 6:22 PM, Paul Schreiner schreiner_p...@att.net wrote: Do you have admin privileges for the machine? Windows has policies that you can assign to a machine. These Policies can be used to create startup/exit scripts that write to log files. That's the cleanest way to handle it. There's also a way to query the Win32_NTLogEvent Then search through that log to find what you're looking for. I don't have any way to try this on an XP machine. try googling: SELECT * FROM Win32_NTLogEvent WHERE logfile = and see what you get. *Paul* - *Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can. - John Wesley* - *From:* Pravin Gunjal isk1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, February 18, 2015 7:21 AM *Subject:* $$Excel-Macros$$ Computer Login Logout Time Record *Hello Friends,* *I need to have a file which may record the Login Logout time of computer. I am using Windows XP.* *Thanks in anticipation.* *Regards* *Pravin Gunjal* -- 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/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/1auoU5csZpk/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Getting Run time error for macro
Can anyone help me on this issue plz. On Oct 21, 2015 3:26 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > Hi Mandeep > > The code you have replaced in this mail has to be replaced in other > sheets also of the same file.. file is attached for your immediate > reference. > > Pl help me out on this. > > Thanks, > Pravin Gunjal. > > On Oct 20, 2015 4:35 PM, "Mandeep Baluja" < > > > rockerna...@gmail.com> wrote: > >> Hi Praveen, >> >> Welcome,I am sorry but Please elaborate your query Modify in what sense >> and for all sheets means you have the same code in all sheets what kind of >> modification you're looking for whether it is automated or it is manual. >> >> Regards, >> Mandeep Baluja >> >> >> >> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal wrote: >>> >>> Dear Mandeep >>> Thank you so much.. it works fantastic. >>> >>> Can you tell me one more thing, how to modify the vba code in all >>> sheets... >>> >>> Regards, >>> Pravin Gunjal. >>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rocke...@gmail.com> wrote: >>> >>>> check this out !! >>>> >>>> >>>> >>>> >>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range) >>>> >>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing >>>> Then >>>> For Each cell In Target >>>> If cell.Value <> "" Then >>>> cell.Offset(0, 1).Value = Application.UserName >>>> End If >>>> Next >>>> End If >>>> >>>> End Sub >>>> >>>> Regards, >>>> Mandeep baluja >>>> https://www.facebook.com/groups/825221420889809/ >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> excel-macros...@googlegroups.com. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >> 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. >> --- &g
$$Excel-Macros$$ VBA Code Error in all files
Hi Greetings! Getting an attached error while opening files of VBA. Kindly help me to resolve the same. Regards Pravin Gunjal -- 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/d/optout.
$$Excel-Macros$$ VBA to pick up current date in last column
Dear Friends I have attached an excel file in which I have used macro to get "Created by" field automatically once the values are entered in column N (Qty). Likewise I want the last column (Entry Date) to be updated as current date, as and when the column N gets entered. I have made one manual entry in row no. 7. Could you please help me out to fulfil the requirement. Thank you, Regards Pravin Gunjal -- 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/d/optout. Test Outward 2015-16.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Fwd: VBA to pick up current date in last column
Hi Friend could you plz helm me out on the issue. Thanks in advance. Regards Pravin Gunjal -- Forwarded message -- From: "Pravin Gunjal" <isk1...@gmail.com> Date: Oct 26, 2015 4:02 PM Subject: VBA to pick up current date in last column To: "Excel Macros" <excel-macros@googlegroups.com>, "Mandeep Baluja" < rockerna...@gmail.com>, "Vaibhav Joshi (Vabz) - Mumbai Excel" <v...@vabs.in> Cc: Dear Friends I have attached an excel file in which I have used macro to get "Created by" field automatically once the values are entered in column N (Qty). Likewise I want the last column (Entry Date) to be updated as current date, as and when the column N gets entered. I have made one manual entry in row no. 7. Could you please help me out to fulfil the requirement. Thank you, Regards Pravin Gunjal -- 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/d/optout. Test Outward 2015-16.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ How to replace a macro in all sheets
Hi Friend pl help me out to replace a macro in all sheets of the same file. Or any other solution may welcome. Thanks Pravin Gunjal On Oct 22, 2015 1:09 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > Can anyone help me on this issue plz. > On Oct 21, 2015 3:26 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > >> Hi Mandeep >> >> The code you have replaced in this mail has to be replaced in other >> sheets also of the same file.. file is attached for your immediate >> reference. >> >> Pl help me out on this. >> >> Thanks, >> Pravin Gunjal. >> >> On Oct 20, 2015 4:35 PM, "Mandeep Baluja" < >> >> >> rockerna...@gmail.com> wrote: >> >>> Hi Praveen, >>> >>> Welcome,I am sorry but Please elaborate your query Modify in what sense >>> and for all sheets means you have the same code in all sheets what kind of >>> modification you're looking for whether it is automated or it is manual. >>> >>> Regards, >>> Mandeep Baluja >>> >>> >>> >>> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal wrote: >>>> >>>> Dear Mandeep >>>> Thank you so much.. it works fantastic. >>>> >>>> Can you tell me one more thing, how to modify the vba code in all >>>> sheets... >>>> >>>> Regards, >>>> Pravin Gunjal. >>>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rocke...@gmail.com> wrote: >>>> >>>>> check this out !! >>>>> >>>>> >>>>> >>>>> >>>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range) >>>>> >>>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing >>>>> Then >>>>> For Each cell In Target >>>>> If cell.Value <> "" Then >>>>> cell.Offset(0, 1).Value = Application.UserName >>>>> End If >>>>> Next >>>>> End If >>>>> >>>>> End Sub >>>>> >>>>> Regards, >>>>> Mandeep baluja >>>>> https://www.facebook.com/groups/825221420889809/ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> excel-macros...@googlegroups.com. >>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> 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. P
Re: $$Excel-Macros$$ Re: Getting Run time error for macro
Dear Mandeep Thank you so much.. it works fantastic. Can you tell me one more thing, how to modify the vba code in all sheets... Regards, Pravin Gunjal. On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rockerna...@gmail.com> wrote: > check this out !! > > > > > Private Sub Worksheet_Change(ByVal Target As Excel.Range) > > If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing Then > For Each cell In Target > If cell.Value <> "" Then > cell.Offset(0, 1).Value = Application.UserName > End If > Next > End If > > End Sub > > Regards, > Mandeep baluja > https://www.facebook.com/groups/825221420889809/ > > > > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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/d/optout.
$$Excel-Macros$$ Getting Run time error for macro
Hi, Greetings, I have used a simple macro in an attached file But while pasting or deleting the data in multiple cells, getting following error: Run-time error '13': Type mismatch Kindly help me out on this. Thank you, Regards Pravin Gunjal -- 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/d/optout. Test Outward 2015-16.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Getting Run time error for macro
Hi, Greetings, I have used a simple macro in an attached file But while pasting or deleting the data in multiple cells, getting following error: Run-time error '13': Type mismatch Kindly help me out on this. Thank you, Regards Pravin Gunjal -- 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/d/optout. Test Outward 2015-16.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ MSG: Code execution has been interrupted
Hi, I am getting an above mentioned error message while running any macro on my computer, while the same macro could run in other computer. Could you please help me out on this. Thanks, Regards Pravin Gunjal. -- 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/d/optout.
Re: $$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted
Thanks but it doesn't work Application.EnableCancelKey = xlDisabled On Sat, Sep 19, 2015 at 3:08 PM, Abhishek Jain <abhishek@gmail.com> wrote: > See if this helps - > > > http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html > > On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal <isk1...@gmail.com> wrote: > >> Hi, Can anyone help me on this subject? >> >> On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal >> wrote: >>> >>> Hi, >>> >>> I am getting an above mentioned error message while running any macro on >>> my computer, while the same macro could run in other computer. >>> >>> Could you please help me out on this. Thanks, >>> >>> Regards >>> Pravin Gunjal. >>> >> -- >> 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/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/UpMP7qsXOEQ/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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/d/optout.
$$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted
Hi, Can anyone help me on this subject? On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I am getting an above mentioned error message while running any macro on > my computer, while the same macro could run in other computer. > > Could you please help me out on this. Thanks, > > Regards > Pravin Gunjal. > -- 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/d/optout.
$$Excel-Macros$$ Remove all existing macros on certain date
Hi Expert, Can i get a macro which can remove all existing macros from a file on certain date.. Kindly share the same. Thanks. Regards Pravin Gunjal -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Remove all existing macros on certain date
Hi any update on this plz. On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > Hi Expert, > > Can i get a macro which can remove all existing macros from a file on > certain date.. > > Kindly share the same. Thanks. > > Regards > Pravin Gunjal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Remove all existing macros on certain date
Thanks but where is the date On Dec 24, 2015 3:59 PM, "jayaraj metta" <jayaraj.me...@gmail.com> wrote: > If you want to delete the module then use below code > 'Author #Jayaraju Metta > Sub vbcomponents() > Dim vbcom as Object > Set vbcom=application.VBE.activeVBProject.Vbcomponents > vbcom.remove Vbcomponent:=_ > vbcom.item("Module1") > End sub > > If you find any difficulties please let me know > On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > >> Hi Expert, >> >> Can i get a macro which can remove all existing macros from a file on >> certain date.. >> >> Kindly share the same. Thanks. >> >> Regards >> Pravin Gunjal >> >> -- >> 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 https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Remove all existing macros on certain date
Yes exactly. On specific date. On Dec 24, 2015 3:53 PM, "jayaraj metta" <jayaraj.me...@gmail.com> wrote: > Hello Pravin Gunjal, > Do you want to delete modules in a project using a macro? > Can you please elaborate it ? > On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > >> Hi Expert, >> >> Can i get a macro which can remove all existing macros from a file on >> certain date.. >> >> Kindly share the same. Thanks. >> >> Regards >> Pravin Gunjal >> >> -- >> 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 https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Remove all existing macros on certain date
Hi I have some macro in file and suppose i want to remove them after 4 days. So is there any such macro available which can work on my requirements. Thanks Pravin Gunjal. On Dec 24, 2015 5:53 PM, "jayaraj metta" <jayaraj.me...@gmail.com> wrote: > "Existing macro on certain Date" > > Can you please elaborate above line with some live example. Share some > files with the same > On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote: > >> Hi Expert, >> >> Can i get a macro which can remove all existing macros from a file on >> certain date.. >> >> Kindly share the same. Thanks. >> >> Regards >> Pravin Gunjal >> >> -- >> 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 https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Excel is showing different data on other sharing computer
Thanks for reply. The path and file is unique. One sheet was hidden at the time of screenshot taken on other computer. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Wed, Jun 8, 2016 at 5:14 PM, B Sharma <sharma@gmail.com> wrote: > Hiii Pravin,, > From your screen shot I think that both the files are at different > location... > Please check that in the first first there is only one sheet, and in the > another file there are 2 sheets (one new with name "Master") > > Please carefully check the path of the file which you open in the shared > computer, because I doubt that it could be the previously saved file / > older version of that file which you have saved.. > > Please let us know about this ... > > Thanks & Regards, > Bajrang sharma > > > On Monday, May 30, 2016 at 4:55:18 PM UTC+5:30, Pravin Gunjal wrote: >> >> Dear Friend, >> >> Greetings! >> >> I have 3-4 computers in shared network. In one of them there is an excel >> file which contains data with 184 rows and 19 columns. If I open this file >> in the origin computer it shows data up to 184 rows but when I open the >> same file with other shared computer it shows only up to 173 rows. >> >> I have attached both the screen shorts for your immediate reference. >> Kindly help. Thanks, >> >> Regards, >> Pravin Gunjal. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/cLtZLYtA2Yk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel is showing different data on other sharing computer
Hi Experts, May I have any solution on this subject please. On 30 May 2016 16:55, "Pravin Gunjal" <isk1...@gmail.com> wrote: > Dear Friend, > > Greetings! > > I have 3-4 computers in shared network. In one of them there is an excel > file which contains data with 184 rows and 19 columns. If I open this file > in the origin computer it shows data up to 184 rows but when I open the > same file with other shared computer it shows only up to 173 rows. > > I have attached both the screen shorts for your immediate reference. > Kindly help. Thanks, > > Regards, > Pravin Gunjal. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/cLtZLYtA2Yk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Get Value If Criteria Matched
Thank you sir.. On Tuesday, April 5, 2016 at 5:47:14 PM UTC+5:30, Paul Schreiner wrote: > > If you're wanting an Excel Function solution: > > In Sheet2, I'd create a "helper" column (A) > and concatenate the Customer Name, Code and Material columns. > Then, in Sheet1, Cell E2, use: > =IF(COUNTIF(Sheet2!A:A,A2&"_"&"_")=0,"NO Matches", > IF(COUNTIF(Sheet2!A:A,A2&"_"&"_")>1,"Duplicate Records", > VLOOKUP(A2&"_"&"_",Sheet2!A:F,6,FALSE))) > > and copy down > > If you want a VBA solution, I'd use: > Option Explicit > Sub Lookup_ABC() > Dim Dict_Data > Dim NumRows, NumRow > Dim RecID > > > Set Dict_Data = CreateObject("Scripting.Dictionary") > Dict_Data.RemoveAll > > > ' > 'Load Data Dictionary > > ' > NumRows = > Application.WorksheetFunction.CountA(Sheets("Sheet2").Range("A:A")) > > For NumRow = 2 To NumRows > RecID = Sheets("Sheet2").Cells(NumRow, "A").Value > RecID = RecID & "_" & Sheets("Sheet2").Cells(NumRow, "B").Value > RecID = RecID & "_" & Sheets("Sheet2").Cells(NumRow, "C").Value > > If (Not Dict_Data.exists(RecID)) Then > Dict_Data.Add RecID, Sheets("Sheet2").Cells(NumRow, > "E").Value > Else > Dict_Data.Item(RecID) = Dict_Data.Item(RecID) & ", " & > Sheets("Sheet2").Cells(NumRow, "E").Value > End If > > Next NumRow > > ' > ' Read from Data Dictionary > > ' > NumRows = > Application.WorksheetFunction.CountA(Sheets("Sheet1").Range("A:A")) > > On Error Resume Next > For NumRow = 2 To NumRows > RecID = Sheets("Sheet1").Cells(NumRow, "A").Value > RecID = RecID & "_" & Sheets("Sheet1").Cells(NumRow, "B").Value > RecID = RecID & "_" & Sheets("Sheet1").Cells(NumRow, "C").Value > > If (Dict_Data.exists(RecID)) Then > Sheets("Sheet1").Cells(NumRow, "E").Value = > Dict_Data.Item(RecID) > Else > Sheets("Sheet1").Cells(NumRow, "E").Value = "No Match Found" > End If > > Next NumRow > End Sub > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, April 5, 2016 6:08 AM, Pravin Gunjal <isk...@gmail.com > > wrote: > > > > Hi, > > Greetings! > > I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column > B, C & D are matches in both sheets. PFA file. > > Look forward for good formula. Thanks, > > Regards, > *Pravin Gunjal* > > -- > 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...@googleg
$$Excel-Macros$$ Sharing Problem on Network Computers
Dear Friends, I am sharing one different issue with you colleagues, which is other than excel. I hope you will help me in this. I have 3-4 computers in my office and all are connected to the same network and workgroup. All the computers have access of others except one. My system can see other computers & access, but other can't access mine though it is shared. Kindly help. Thanks, Following is the screenshot: *With regards,* *Pravin Gunjal* *Mobile: 77100 * *97250* -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Get Value If Criteria Matched
Hi, Greetings! I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column B, C & D are matches in both sheets. PFA file. Look forward for good formula. Thanks, Regards, *Pravin Gunjal* -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Creteria Matches.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12