Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 9:29 AM On Fri, 3/10/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 9:21 AM On Fri, 3/10/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 8:27 AM On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 4:10 AM On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 3:32 AM On Fri, 3/10/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 3:04 AM On Fri, 3/10/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 1:34 AM On Fri, 3/10/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 12:17 AM On Thu, 3/9/17, Mohd Sadiq wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: "Pankaj Sharma" Cc: excel-macros@googlegroups.com Date: Thursday, March 9, 2017, 4:54 PM Hello Pankaj , Pls response as I need to closed it asap. Regards,Sadiq979223 On Wed, Mar 8, 2017 at 6:50 PM, Mohd Sadiq wrote: Pls response ? On Tue, Mar 7, 2017 at 7:00 PM, Mohd Sadiq wrote: Dear Pankaj , Sorry for delayed response as I was on leave. Here is attached one more resolution for the same but when I am trying to put same formula in another sheet then it does not working Specially when I'm putting in Night Shift. Pls look into this and let me know what should I do now. PN- Column highlighted in Yellow/Orange color. Thanks On Thu, Mar 2, 2017 at 7:46 AM, Pankaj Sharma wrote: resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica1 43pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: Didn't get your query, what you want to do in this sheet, pls mention example with result.
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Mon, 3/13/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: "excel-macros@googlegroups.com" Date: Monday, March 13, 2017, 3:04 PM What I would do is first load your "Roll No." values into a Dictionary object.Then, loop through your "S.No." values and look to see if they are in the Dictionary.Report the missing values.Like: Sub Find_Missing() Dim Dict_SN, SN Dim nRows, nRow, drow Set Dict_SN = CreateObject("Scripting.Dictionary") Dict_SN.RemoveAll nRows = Range("A1").SpecialCells(xlLastCell).Row ' Load Dictionary For nRow = 2 To nRows SN = Trim(ActiveSheet.Cells(nRow, "B").Value) If (SN & "X" <> "X") Then If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow End If Next nRow ActiveSheet.Range("C2:C65000").ClearContents drow = 1 For nRow = 2 To nRows SN = Trim(ActiveSheet.Cells(nRow, "A").Value) If (SN & "X" <> "X") Then If (Not Dict_SN.exists(SN)) Then drow = drow + 1 ActiveSheet.Cells(drow, "C").Value = SN End If End If Next nRow End SubPaul- “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 Sunday, March 12, 2017 1:23 AM, Sunil Kumar Yadav wrote: Dear Paul, I have need your help for this query. Please guide me. -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 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. Continuarea revolutiei de la 1848 in Transilvania66 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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)
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:49 PM On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:38 PM On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:26 PM On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 12:10 PM On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 11:04 AM On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:54 AM On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:49 AM On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:48 AM On Tue, 3/14/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:22 AM Thank you so much it's working perfectly:) On Mar 13, 2017 6:34 PM, "Paul Schreiner" wrote: What I would do is first load your "Roll No." values into a Dictionary object.Then, loop through your "S.No." values and look to see if they are in the Dictionary.Report the missing values.Like: Sub Find_Missing() Dim Dict_SN, SN Dim nRows, nRow, drow Set Dict_SN = CreateObject("Scripting. Dictionary") Dict_SN.RemoveAll nRows = Range("A1").SpecialCells( xlLastCell).Row ' Load Dictionary For nRow = 2 To nRows SN = Trim(ActiveSheet.Cells(nRow, "B").Value) If (SN & "X" <> "X") Then If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow End If Next nRow ActiveSheet.Range("C2:C65000") .ClearContents drow = 1 For nRow = 2 To nRows SN = Trim(ActiveSheet.Cells(nRow, "A").Value) If (SN & "X" <> "X") Then If (Not Dict_SN.exists(SN)) Then drow = drow + 1 ActiveSheet.Cells(drow, "C").Value = SN End If End If Next nRow End SubPaul-- --- “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.
Re: $$Excel-Macros$$ book for excel
On Sun, 3/19/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Sunday, March 19, 2017, 10:27 PM On Sun, 3/19/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Sunday, March 19, 2017, 7:54 PM On Sun, 3/19/17, 'Izhar Ul Haq' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: "excel-macros@googlegroups.com" Date: Sunday, March 19, 2017, 4:12 PM There are so many books from which you may learn excel, and so many example from the internet from which you may learn excel, there is no comprehensive book from which you may learn a lot. From: Cori To: MS EXCEL AND VBA MACROS Sent: Friday, March 17, 2017 3:42 PM Subject: $$Excel-Macros$$ book for excel Can you suggest a book for excel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 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. a 25 iunie 1942 Rene de Weck ministrul Elvetiei la Bucuresti aprecia ca pierderile armatei romane in Rasarit erau de 6 000 ofiteri 2 600 subofiteri si 149 000 soldati din care 70% erau totusi recuperabili. in cadrul inclestarii de la Stalingrad' iulie 1942 - februarie 1943 26 divizii romanesti au luptat alaturi de fortele Axei. Ele au inregistrat insa grave pierderi - 156 000 morti disparuti si prizonieri. Armata a 3-a Romana s-a aflat in incercuire alaturi de trupele germane italiene si maghiare. in anii. 1943-1944 fortele romane au sustinut in continuare lupte grele in Cuban pentru apararea Crimeii si Basarabiei. Dupa anul 1943 Ion Antonescu a inteles ca Germania a pierdut razboiul si a actionat pentru a scoate tara din razboi. in acelasi timp multi ofiteri superiori au cerut retragerea Armatei Romane de pe front date fiind si marile pierderi materiale si umane in campania din Uniunea Sovi
Re: $$Excel-Macros$$ Required Macro Coding
On Sun, 3/26/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Required Macro Coding To: excel-macros@googlegroups.com Date: Sunday, March 26, 2017, 11:38 AM On Sun, 3/26/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Required Macro Coding To: excel-macros@googlegroups.com Date: Sunday, March 26, 2017, 4:58 AM On Sat, 3/25/17, JAYAVELU SUN wrote: Subject: Re: $$Excel-Macros$$ Required Macro Coding To: excel-macros@googlegroups.com Date: Saturday, March 25, 2017, 3:55 PM On Fri, Mar 24, 2017 at 5:55 PM, sriram ji wrote: Dear Team, Kindly help us to create macro coding for the below attached file. Thanks In Advance. Sriram G -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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. -- JAYAVELU 9710847899 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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. ent omul de casa al Glogovenilor cu proiectele de dezmembrare ale -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 e
Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook
On Tue, 3/28/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Tuesday, March 28, 2017, 3:49 PM On Tue, 3/28/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Tuesday, March 28, 2017, 6:04 AM On Tue, 3/28/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Tuesday, March 28, 2017, 5:15 AM On Tue, 3/28/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Tuesday, March 28, 2017, 1:41 AM On Mon, 3/27/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Monday, March 27, 2017, 9:31 PM On Mon, 3/27/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Monday, March 27, 2017, 4:45 PM On Mon, 3/27/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Monday, March 27, 2017, 4:17 PM On Mon, 3/27/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Monday, March 27, 2017, 11:29 AM On Mon, 3/27/17, Swapnil Palande wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Monday, March 27, 2017, 8:25 AM Hi, You want do develop kind of WorkForce Management Application. Will recommend not to do it in Excel. For small scale use MS Access. It is complex application. You have to contact software developer to develop it. Regards, Swapnil Suresh Palande. On Sat, Mar 25, 2017 at 10:09 AM, Dollar Chande wrote: Hello Paul / Ayush, Can you guys help me or guide me on this one... Best regards, Dollar Chande On Friday, March 10, 2017 at 4:28:34 PM UTC+5:30, Dollar Chande wrote:Hi All, I am a novice at macro (very little knowledge) and would seek your kind assistance on my attached sheet. I am a MS Office 2013 user and attached sheet refers to automating a daily time table scheduling crisis I have to go through for school. I have tried my best to input all info i know in the comments and "INFO" sheet. Look forward to your kind help and guidance...thx Best regards, Dollar Chande -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 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.
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM -------- On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 a
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:28 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 AM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:39 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM ---------------- On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM ---------------- On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:17 PM On Wed, 4/5/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 PM On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:43 PM On Wed, 4/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 2:27 PM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 7:21 AM -------- On Wed, 4/5/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 6:25 AM On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:28 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 AM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:39 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM
Re: $$Excel-Macros$$ Re: Macros for screenshot
On Sat, 4/8/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:53 PM On Sat, 4/8/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:13 AM On Sat, 4/8/17, priti verma wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:03 AM first you need to open that excel file and activate that particular excel file by using application.actiavte "workbbok name" and paste into excel file in desired range. On Fri, Mar 31, 2017 at 4:40 PM, suresh k wrote: Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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. .Demonstrati caracterul radicai ai rascoalei taranesti din 1907.CULTURA ROMaNEASCa LA SFaRsITUL SECOLULUI AL XIX-LEA SI iNCEPUTUL SECOLULUI AL XX-LEA -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 me
Re: $$Excel-Macros$$ Re: Macros for screenshot
On Sat, 4/8/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:11 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 7:49 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 8:18 PM On Sat, 4/8/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 5:28 PM -------- On Sat, 4/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:57 PM On Sat, 4/8/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:53 PM On Sat, 4/8/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:13 AM On Sat, 4/8/17, priti verma wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:03 AM first you need to open that excel file and activate that particular excel file by using application.actiavte "workbbok name" and paste into excel file in desired range. On Fri, Mar 31, 2017 at 4:40 PM, suresh k wrote: Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 rec
Re: $$Excel-Macros$$ Re: Macros for screenshot
On Mon, 4/10/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Monday, April 10, 2017, 1:39 AM On Sun, 4/9/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 7:05 PM On Sun, 4/9/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 5:55 PM On Sun, 4/9/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 3:56 PM On Sun, 4/9/17, 'Keisha Fry' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 2:02 PM On Sun, 4/9/17, 'Martinez David' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 9:05 AM On Sun, 4/9/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 2:02 AM On Sun, 4/9/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 1:41 AM On Sun, 4/9/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 12:12 AM On Sat, 4/8/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 11:09 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 11:06 PM ---------------- On Sat, 4/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:51 PM On Sat, 4/8/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:11 PM
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/ discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscribe@ googlegroups.com. >> To post to this group, send email to excel-...@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 Advic
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sat, 12/10/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:49 PM On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:45 PM On Sat, 12/10/16, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:06 PM On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/ discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure.
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 12:56 AM On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:55 PM On Sat, 12/10/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:49 PM On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:45 PM On Sat, 12/10/16, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:06 PM On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sun, 12/11/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 6:34 AM On Sun, 12/11/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 5:16 AM On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 4:20 AM On Sun, 12/11/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 3:54 AM On Sun, 12/11/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 3:48 AM On Sun, 12/11/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 3:14 AM On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 12:56 AM On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:55 PM On Sat, 12/10/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:49 PM On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:45 PM On Sat, 12/10/16, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:06 PM On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 10:55 PM On Sun, 12/11/16, taher bootwala wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: "MS EXCEL AND VBA MACROS" Cc: julienneschind...@yahoo.com Date: Sunday, December 11, 2016, 8:12 PM PLEASE ADD 8819978652 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/ discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscribe@ googlegroups.com. >> To post to this group, send email to excel-...@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
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Mon, 12/12/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 1:01 AM On Mon, 12/12/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 12:18 AM On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 10:55 PM On Sun, 12/11/16, taher bootwala wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: "MS EXCEL AND VBA MACROS" Cc: julienneschind...@yahoo.com Date: Sunday, December 11, 2016, 8:12 PM PLEASE ADD 8819978652 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/ discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to e
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Tue, 12/13/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 1:18 AM On Mon, 12/12/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 11:44 PM On Mon, 12/12/16, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 11:05 PM On Mon, 12/12/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 8:53 PM On Mon, 12/12/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 4:53 PM On Mon, 12/12/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: "excel-macros@googlegroups.com" Date: Monday, December 12, 2016, 3:22 PM There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. 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 Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: On Mon, 12/12/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 2:43 PM Thanks Paul for quick guidance. This file is used by many people and they are working without reading few guidelines from first sheet. There may be chances of not using the sheet_hide macro option by other user. Is there any macros which automatically hide those sheets when close the file. Attached is the my workbook. Regards,Vijayendra 2016-12-12 17:46 GMT+05:30 Paul Schreiner : Just as you created a macro to "unhide" the sheets, you need to create a macro to hide them. Additionally, you can create a BeforeSave event to check to see if the sheets are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before saving (that way the sheets are always hidden before saving the file) Note: Using a macro, you can use .Visible = xlVeryHiddenwhich will hide the sheets and they will not show up when trying to manually unhide the sheets! 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 Monday, December 12, 2016 7:04 AM, Vijayendra Rao wrote: Hi Experts, I have created one excel file and except one sheet all sheets are hided. I have added shape button in first sheet to unhide all the sheets with the help of macro. When i worked and saved all sheets will be visible when I opened again. Is it possible to remain hide those sheets after saving the file. Request you to help on the same.-- Regards, Vijayendra
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Tue, 12/13/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 4:07 AM On Tue, 12/13/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:56 AM On Tue, 12/13/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:50 AM Thanks Paul for quick help, it fulfilled my most of the requirement. One last favor, Now while opening last saved sheet only visible and guidelines sheet is hide , is it possible to view only first sheet (sheet name read) of the file. Regards,Vijayendra 2016-12-12 18:52 GMT+05:30 Paul Schreiner : There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. 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 Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: -- -- On Mon, 12/12/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 2:43 PM Thanks Paul for quick guidance. This file is used by many people and they are working without reading few guidelines from first sheet. There may be chances of not using the sheet_hide macro option by other user. Is there any macros which automatically hide those sheets when close the file. Attached is the my workbook. Regards,Vijayendra 2016-12-12 17:46 GMT+05:30 Paul Schreiner : Just as you created a macro to "unhide" the sheets, you need to create a macro to hide them. Additionally, you can create a BeforeSave event to check to see if the sheets are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before saving (that way the sheets are always hidden before saving the file) Note: Using a macro, you can use .Visible = xlVeryHiddenwhich will hide the sheets and they will not show up when trying to manually unhide the sheets! 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 Monday, December 12, 2016 7:04 AM, Vijayendra Rao wrote: Hi Experts, I have created one excel file and except one sheet all sheets are hided. I have added shape button in first sheet to unhide all the sheets with the help of macro. When i worked and saved all sheets will be visible when I opened again. Is it possible to remain hide those sheets after saving the file. Request you to help on the same.-- Regards, Vijayendra 94491 67631 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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
Re: $$Excel-Macros$$ Average of Columns while excluding certain columns
On Tue, 12/13/16, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 9:18 PM On Tue, 12/13/16, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 9:00 PM On Tue, 12/13/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 8:37 PM On Tue, 12/13/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 7:18 PM On Tue, 12/13/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: "excel-macros@googlegroups.com" Date: Tuesday, December 13, 2016, 6:14 PM Could I get a copy of the sheet?What do you base "current" year on, the year of "today's" date?(rather than a fiscal year or other criteria) There are several options.But I'd rather not try to recreate your data, only to find out my creation doesn't match yours! 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, December 13, 2016 11:06 AM, Joseph Carney wrote: Hello all , I have a conundrum. I have a table that i am using to collate data from previous years sales. The data is from 2008 thru current year. I have the table set up as follows:Month | 2008 | 2009 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 5year Average Under each of the headings, I have a numeric value sorted by month. What I would like to be able to do is to average the PREVIOUS 5 years sales while ignoring the current year. Is there a way/formula that I can set up that would give me the previous 5 year average without having to manually adjust the formula? Thank you for your kind assistance, Joe -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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
Re: $$Excel-Macros$$ Average of Columns while excluding certain columns
On Tue, 12/13/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 10:56 PM On Tue, 12/13/16, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 9:18 PM On Tue, 12/13/16, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 9:00 PM On Tue, 12/13/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 8:37 PM On Tue, 12/13/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 7:18 PM On Tue, 12/13/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain columns To: "excel-macros@googlegroups.com" Date: Tuesday, December 13, 2016, 6:14 PM Could I get a copy of the sheet?What do you base "current" year on, the year of "today's" date?(rather than a fiscal year or other criteria) There are several options.But I'd rather not try to recreate your data, only to find out my creation doesn't match yours! 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, December 13, 2016 11:06 AM, Joseph Carney wrote: Hello all , I have a conundrum. I have a table that i am using to collate data from previous years sales. The data is from 2008 thru current year. I have the table set up as follows:Month | 2008 | 2009 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 5year Average Under each of the headings, I have a numeric value sorted by month. What I would like to be able to do is to average the PREVIOUS 5 years sales while ignoring the current year. Is there a way/formula that I can set up that would give me the previous 5 year average without having to manually adjust the formula? Thank you for your kind assistance, Joe -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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.
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 10:13 AM On Wed, 12/14/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 10:05 AM On Wed, 12/14/16, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 3:37 AM On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 3:14 AM On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 2:51 AM On Wed, 12/14/16, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 12:37 AM On Tue, 12/13/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: "excel-macros@googlegroups.com" Date: Tuesday, December 13, 2016, 2:11 PM I'd suggest changing the HideAllSheets macro to first display the "read" sheet (what you called "guidelines"?)then hide everything EXCEPT the "read" sheet. Like: Sub HideAllSheets() Dim wsSheet As Worksheet Sheets("read").Visible = True For Each wsSheet In ActiveWorkbook.Worksheets If wsSheet.Name <> "read" Then wsSheet.Visible = xlSheetHidden End If Next wsSheet 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, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 8:27 AM On Tue, 12/13/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:50 AM Thanks Paul for quick help, it fulfilled my most of the requirement. One last favor, Now while opening last saved sheet only visible and guidelines sheet is hide , is it possible to view only first sheet (sheet name read) of the file. Regards,Vijayendra 2016-12-12 18:52 GMT+05:30 Paul Schreiner : There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. 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 Monday, D
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Thu, 12/15/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Thursday, December 15, 2016, 5:12 PM Hi Paul, Thank you very much for your time, I tried both the option and both are working very fine. You have fulfilled my all requirement. Thank you once again for your timely help.🙏 Regards,Vijayendra 2016-12-15 20:17 GMT+05:30 Paul Schreiner : Look at the "Thisworkbook" module in the VB Editor. Notice that in the Hide...xlsm workbook, this module has the Workbook_Open event macro? Your testing.xlsm workbook doesn't have this. I noticed that you've added an Auto_Open macro.this is also an option.You could simply add a call to HideAllSheets to this macro before the Msgbox line. 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 Thursday, December 15, 2016 7:43 AM, Vijayendra Rao wrote: Dear Paul, I am facing one issue here, I try to use the macros to my other file by using you have provided macros. It is not hide when I open second time. I am not sure where I made a mistake or do I need to change any settings. Can you please help on the same. Attached are the both the files. "Hide & unhilde - 2nd page" is the macro provided by you and "TESTING - 001" is my file. Regards,Vijayendra 2016-12-13 18:24 GMT+05:30 Vijayendra Rao : Thanks Paul for your help, it is working fine. You saved my lot of time. Thank you again. Regards,Vijayendra 2016-12-13 17:41 GMT+05:30 Paul Schreiner : I'd suggest changing the HideAllSheets macro to first display the "read" sheet (what you called "guidelines"?)then hide everything EXCEPT the "read" sheet. Like: Sub HideAllSheets() Dim wsSheet As Worksheet Sheets("read").Visible = True For Each wsSheet In ActiveWorkbook.Worksheets If wsSheet.Name <> "read" Then wsSheet.Visible = xlSheetHidden End If Next wsSheet 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, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: -- -- On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 8:27 AM -- -- On Tue, 12/13/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:50 AM Thanks Paul for quick help, it fulfilled my most of the requirement. One last favor, Now while opening last saved sheet only visible and guidelines sheet is hide , is it possible to view only first sheet (sheet name read) of the file. Regards,Vijayendra 2016-12-12 18:52 GMT+05:30 Paul Schreiner : There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. 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 Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: -- -- On Mon, 12/12/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 2:43 PM Thanks Paul for quick guidance. This file is used by many people and they are working without reading few guidelines from first sheet. There may be chances of not using the sheet_hide macro option by other user. Is there any macros which automatically hide those sheets when close the file. Attached is the my workbook. Regards,Vijayendra 2016-12-12 17:46 GMT+05:30 Paul Schreiner : Just as you c
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 12:26 PM On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 6:03 AM On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 3:28 AM On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 1:40 AM On Thu, 12/15/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Thursday, December 15, 2016, 5:12 PM Hi Paul, Thank you very much for your time, I tried both the option and both are working very fine. You have fulfilled my all requirement. Thank you once again for your timely help.🙏 Regards,Vijayendra 2016-12-15 20:17 GMT+05:30 Paul Schreiner : Look at the "Thisworkbook" module in the VB Editor. Notice that in the Hide...xlsm workbook, this module has the Workbook_Open event macro? Your testing.xlsm workbook doesn't have this. I noticed that you've added an Auto_Open macro.this is also an option.You could simply add a call to HideAllSheets to this macro before the Msgbox line. 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 Thursday, December 15, 2016 7:43 AM, Vijayendra Rao wrote: Dear Paul, I am facing one issue here, I try to use the macros to my other file by using you have provided macros. It is not hide when I open second time. I am not sure where I made a mistake or do I need to change any settings. Can you please help on the same. Attached are the both the files. "Hide & unhilde - 2nd page" is the macro provided by you and "TESTING - 001" is my file. Regards,Vijayendra 2016-12-13 18:24 GMT+05:30 Vijayendra Rao : Thanks Paul for your help, it is working fine. You saved my lot of time. Thank you again. Regards,Vijayendra 2016-12-13 17:41 GMT+05:30 Paul Schreiner : I'd suggest changing the HideAllSheets macro to first display the "read" sheet (what you called "guidelines"?)then hide everything EXCEPT the "read" sheet. Like: Sub HideAllSheets() Dim wsSheet As Worksheet Sheets("read").Visible = True For Each wsSheet In ActiveWorkbook.Worksheets If wsSheet.Name <> "read" Then wsSheet.Visible = xlSheetHidden End If Next wsSheet 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, December 13, 2016 1:45 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: -- -- On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 8:27 AM -- -- On Tue, 12/13/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:50 AM
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Sat, 12/17/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 1:04 AM On Fri, 12/16/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 6:08 PM On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 5:34 PM On Fri, 12/16/16, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 4:56 PM On Fri, 12/16/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 2:42 PM On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 2:14 PM On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 12:26 PM On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 6:03 AM On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 3:28 AM On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 1:40 AM On Thu, 12/15/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Thursday, December 15, 2016, 5:12 PM Hi Paul, Thank you very much for your time, I tried both the option and both are working very fine. You have fulfilled my all requirement. Thank you once again for your timely help.🙏 Regards,Vijayendra 2016-12-15 20:17 GMT+05:30 Paul Schreiner : Look at the "Thisworkbook" module in the VB Editor. Notice that in the Hide...xlsm workbook, this module has the Workbook_Open event macro? Your testing.xlsm workbook doesn't have this. I noticed that you've added an Auto_Open macro.this is also an option.You could simply add a call to HideAllSheets to this macro before the Msgbox line. 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 Thursday, December 15, 2016 7:43 AM, Vijayendra Rao wrote: Dear Paul,
Re: $$Excel-Macros$$ sap fico Training in Hyderabad
On Tue, 12/27/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ sap fico Training in Hyderabad To: excel-macros@googlegroups.com Date: Tuesday, December 27, 2016, 10:43 PM On Tue, 12/27/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ sap fico Training in Hyderabad To: excel-macros@googlegroups.com Date: Tuesday, December 27, 2016, 7:40 PM On Tue, 12/27/16, Sanjay Kumar Maurya wrote: Subject: Re: $$Excel-Macros$$ sap fico Training in Hyderabad To: excel-macros@googlegroups.com Date: Tuesday, December 27, 2016, 1:53 PM What's basic qualification required to participate in SAP fico training. My younger brother is BSC student. Is he eligible? On 27-Dec-2016 12:36 PM, "kumar pmpTraining" wrote: SAP FICO Training in Hyderabad with working IT Consultants. sap fico Training in Hyderabad We are the Best SAP Training Institute in Hyderabad,Ameerpet with advanced course syllabus, Corporate Trainings with 12+ Years MNC Real time Faculty Live Projects, Placements, Free DEMO in Hyderabad, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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. omania in relatiile internationale in perioada aniior 1930-1936. icolae Titulescu si politica securitatii colective. Anii de la inceputul sceniului patru au adus importante si semnificative mutatii in planul vietii xinomice si politice pe continentul european. S-a dezvoltat cu toate teribilele ale consecinte cea mai puternica criza economica din cate cunoscuse pana unei istoria si in contextul ei a sporit numarul regimurilor politice dictatoriale si rtremiste. Preluarea puterii in Germania de catre partidul nazist condus de Adolf itier a fost imediat insotita de afirmarea revizionismului ca politica oficiala de stat >ea ce a determinat o puternica neliniste in tarile Europei centrale si sud-estice. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’
Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template
On Wed, 12/28/16, amar takale wrote: Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template To: excel-macros@googlegroups.com Date: Wednesday, December 28, 2016, 12:46 PM Sir, which Language I cant understand.Can you translate in english. On Wed, Dec 28, 2016 at 3:17 PM, julienneschindler via MS EXCEL AND VBA MACROS wrote: -- -- On Wed, 12/28/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template To: excel-macros@googlegroups.com Date: Wednesday, December 28, 2016, 10:41 AM -- -- On Wed, 12/28/16, amar takale wrote: Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management ) excel template To: excel-macros@googlegroups.com Date: Wednesday, December 28, 2016, 6:44 AM Dear Friends Any Ides? On Tue, Dec 27, 2016 at 10:02 AM, amar takale wrote: Dear All Friends, Goog Morning Can anyone send me CRM (Customer relationship management ) excel template (customer discussion date by date & their follow up discussion) in excel.With the goal of improving business relationships with customers. I know this is not possible in excel due to many issue.But I try to do something new with my ideas. Pls send excel template OR related weblink. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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+unsubscribe@ 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. ECOUL SI URMaRILE PENTRU EVOLUtIA ULTERIOARa A ROMaNIEI PARTICIPAREA taRII NOASTRE LA RaZBOIUL ANTIHITLERIST. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/ discussexc
Re: $$Excel-Macros$$ Re: Using range names in formulas
On Thu, 1/5/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Using range names in formulas To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10:14 AM On Thu, 1/5/17, Mack Mans wrote: Subject: Re: $$Excel-Macros$$ Re: Using range names in formulas To: "MS EXCEL AND VBA MACROS" Date: Thursday, January 5, 2017, 7:41 AM http://tutorialway.com/use-named-range-in-excel/ visit this vsite for answer -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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. ste stiut ca tezaurul polonez estimat la 230 milioane de zloti aproximativ 45 milioane de dolari a tranzitat pe teritoriul romanesc inainte de a fi imbarcat la 15 septembrie 1939 pe un vas englez in portul Constanta. Putina vreme apoi dupa ce la 17 septembrie 1939 Uniunea Sovietica a atacat la randul ei Polonia ocupand Bielorusia si Ucraina apuseneana prima grabnica materializare a anexelor secrete ale pactului Ribbentrop-Molotov guvernul roman a acceptat ca presedintele si intreg guvernul polonez sa treaca frontiera in tara noastra cu conditia de a nu desfasura nici o activitate politica. ii vor urma peste 100 000 refugiati dintre care 60 000 militari. Atitudinea Romaniei nu s-a schimbat nici dupa asasinarea lui Armand Calinescu crima premeditata ordonata de la Berlin 21 septembrie 1939 . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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.ate privind structura confesionala a locuitorilor spatiului carpato-da-ubian i-pontic. Majoritatea covarsitoare a populatiei de la Dunarea de Jos Pont si Carpati apartine in continuare confesiunii traditionale respectiv cea a credinciosilor crestini ortodocsi. Acestia sunt indeosebi romani a- caror viata religioasa este coordonata de Mitropolia Ungro-Vlahiei si de Mitropolia Moldovei in 1821 este intemeiata Mitropolia Basarabiei in frunte cu Gavriil Banu-lescu-Bodoni 1746-1821 . De sub autoritatea Mitropolitului Moldovei au fost scosi anterior si romanii ortodocsi din Bucovina. Episcopia acestora cu resedinta la Cernauti impreuna cu cele sase protopopiate ale sale intre care cele ale Ceremusului Nistrului Sucevei impreuna cu ortodocsi din Banat romani si sarbi Crisana Maramures si Transilvania romani in majoritatea lor si greci sunt trecuti in subordinea Scaunului mitropolitan de la Karlowitz. La Sibiu se men
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM On Tue, 1/10/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. 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, January 10, 2017 2:34 AM, amar takale wrote: Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM On Wed, 1/11/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. 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, January 10, 2017 11:48 PM, amar takale wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM -- -- On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM -- -- On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM -- -- On Tue, 1/10/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which w
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Sun, 1/15/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 10:03 AM On Sun, 1/15/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 6:21 AM On Sun, 1/15/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 4:39 AM On Sun, 1/15/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 4:25 AM On Sat, 1/14/17, Devendra Sahay wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Saturday, January 14, 2017, 7:37 AM Hi Paul, Yes both columns have only one column, I just wanted to check howmany values ar availble in the dump using vlookup. I just changed the column referrence in the code but its not running properly. Thanks,Devendra On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner wrote: I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? 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 Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. 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 Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul,
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Mon, 1/16/17, Devendra Sahay wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 6:01 AM Hey Paul, Would you please look into this. On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay wrote: Hi Paul, Yes both columns have only one column, I just wanted to check howmany values ar availble in the dump using vlookup. I just changed the column referrence in the code but its not running properly. Thanks,Devendra On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner wrote: I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? 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 Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. 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 Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? 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 Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the Workbook2.xlsx file? 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 Saturday, January 7, 2017 10:42 PM, Devendra Sahay wrote: Hi Team, Sorry for posting such a long query on the forum, but
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Mon, 1/16/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 10:11 PM On Mon, 1/16/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 3:18 PM On Mon, 1/16/17, Devendra Sahay wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 6:01 AM Hey Paul, Would you please look into this. On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay wrote: Hi Paul, Yes both columns have only one column, I just wanted to check howmany values ar availble in the dump using vlookup. I just changed the column referrence in the code but its not running properly. Thanks,Devendra On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner wrote: I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? 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 Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. 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 Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? 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 Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul,
Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES
On Mon, 1/23/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "excel-macros@googlegroups.com" Date: Monday, January 23, 2017, 2:42 PM Are you wanting the end result such that cell A19 contains "Bill" (the value of A2)A20 = JoeA21 = DaveA22 = Fredand so on, then repeating this series for 15 sets? For THAT, you could use something like:Option ExplicitSub Dup_Sets() Dim nRow, nRows, dRow, SetCnt, SetNo SetCnt = 15 nRows = Application.WorksheetFunction.CountA(Range("A:A")) For SetNo = 1 To SetCnt - 1 For nRow = 2 To nRows Debug.Print nRow + (SetNo * (nRows - 1)) Cells(nRow + (SetNo * (nRows - 1)), "A").Value = Cells(nRow, "A").Value Next nRow Next SetNo End Sub If that's not what you meant, then I need further explanation. 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 Friday, January 20, 2017 11:15 PM, Izhar wrote: I need code for the above nameSCENARIOif I want to copy the above names below the range for about 15 times -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 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. lteta Regala ceea ce a semnificat intarirea prestigiului sau dar si in special afirmarea unui nou statut international pentru Romania. Ulterior guvernele europene au recunoscut noul titlu oficial. Consolidarea pozitiei internationale a tarii noastre dupa cucerirea independentei de stat a permis proclamarea Romaniei ca regat. Aceasta s-a realizat la 14 martie 1881 dupa votul din parlament. in urma unor festivitati la 10 22 mai 1881 Carol'si sotia sa Ehsabeta de Wfeo poeta Carmen Sylva au fost incoronati. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 i
Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
On Fri, 1/27/17, Greg Della-Croce wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 4:00 PM You all caught the problem with this solution (which I still like). I need to find a String within a String, not an exact String match. But I think I found where I went wrong. The InStr command is very picky about what parms you use. Thus when I changed this to InStr(1, Cell.Value, ChkFor, vbTextCompare) the function worked. Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Fri, Jan 27, 2017 at 4:43 AM, martinez.david533 via MS EXCEL AND VBA MACROS wrote: -- -- On Fri, 1/27/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 9:50 AM -- -- On Thu, 1/26/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 10:47 PM -- -- On Thu, 1/26/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 9:29 PM -- -- On Thu, 1/26/17, Vicky wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 6:53 PM Hi Greg, The given code only works when you are comparing the contents of the entire cell from one in the range. It won't work if your chkFor cell is matching partially with one of the cells from range. Regards,Vicky On 26-Jan-2017 9:47 PM, "Greg Della-Croce" wrote: Vicky, thanks for the idea. I will see how it works for me. I appreciate the time/effort you put in to help me! Greg Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572Greg_Della-Croce@ sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Thu, Jan 26, 2017 at 11:13 AM, Vicky wrote: Hi Greg, I have found a solution. Hope this helps! Function Contains(ChkFor As String, ChkRng As Range) For Each cell In ChkRng If cell.Value = ChkFor Then Contains = "Found" Exit For Else Contains = "Not Found" End If Next cellEnd Function The above code worked for me. :) Regards,Vicky On Thursday, January 19, 2017 at 7:15:03 PM UTC+5:30, Greg Della-Croce wrote:I am trying to create a very simple function that will take a string of text and read a range of texts to see if I have any that string in any of the ranges of the texts. Should be a 10-minute problem to solve. I am however getting a #VALUE back.I call the function with this:=Contains(F2,' Scrape'!$D$2:$D$2062) The function is this: Function Contains(ChkFor As String, ChkRng As Range) As String For Each cell In ChkRng If (InStr(cell.Value, ChkFor, 1)) Then Contains = "Found" Exit For End If Contains = "Not Found"Next cellEnd Function OK, I said it was simple :) However, can anyone point to the problem in this code. I have looked at it until I have become frustrated. Thanks, Greg -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discu ssexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help
Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Saturday, January 28, 2017, 5:22 AM On Fri, 1/27/17, Greg Della-Croce wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 4:00 PM You all caught the problem with this solution (which I still like). I need to find a String within a String, not an exact String match. But I think I found where I went wrong. The InStr command is very picky about what parms you use. Thus when I changed this to InStr(1, Cell.Value, ChkFor, vbTextCompare) the function worked. Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Fri, Jan 27, 2017 at 4:43 AM, martinez.david533 via MS EXCEL AND VBA MACROS wrote: -- -- On Fri, 1/27/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 9:50 AM -- -- On Thu, 1/26/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 10:47 PM -- -- On Thu, 1/26/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 9:29 PM -- -- On Thu, 1/26/17, Vicky wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 6:53 PM Hi Greg, The given code only works when you are comparing the contents of the entire cell from one in the range. It won't work if your chkFor cell is matching partially with one of the cells from range. Regards,Vicky On 26-Jan-2017 9:47 PM, "Greg Della-Croce" wrote: Vicky, thanks for the idea. I will see how it works for me. I appreciate the time/effort you put in to help me! Greg Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572Greg_Della-Croce@ sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Thu, Jan 26, 2017 at 11:13 AM, Vicky wrote: Hi Greg, I have found a solution. Hope this helps! Function Contains(ChkFor As String, ChkRng As Range) For Each cell In ChkRng If cell.Value = ChkFor Then Contains = "Found" Exit For Else Contains = "Not Found" End If Next cellEnd Function The above code worked for me. :) Regards,Vicky On Thursday, January 19, 2017 at 7:15:03 PM UTC+5:30, Greg Della-Croce wrote:I am trying to create a very simple function that will take a string of text and read a range of texts to see if I have any that string in any of the ranges of the texts. Should be a 10-minute problem to solve. I am however getting a #VALUE back.I call the function with this:=Contains(F2,' Scrape'!$D$2:$D$2062) The function is this: Function Contains(ChkFor As String, ChkRng As Range) As String For Each cell In ChkRng If (InStr(cell.Value, ChkFor, 1)) Then Contains = "Found" Exit For End If Contains = "Not Found"Nex
Re: $$Excel-Macros$$ Formula help needed
On Wed, 2/8/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Formula help needed To: "excel-macros@googlegroups.com" Date: Wednesday, February 8, 2017, 2:29 PM The Match() function will return the relative column for the date matching the header.So: Your array of data is in E1:AI1 and if you're looking for the date in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for when you copy the formulas) In this case, the function returns 31, which is the number of columns beginning from column E.The index() function starts with the entire array of data (E1:AI7)and uses a row,column offset into this array. In cell C2, use the formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1)) the row() function returns the current row.You can then copy this function to the rows in column C and D. 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, February 7, 2017 10:34 AM, Amit Desai (MERU) wrote: #yiv0040706336 #yiv0040706336 -- filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv0040706336 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv0040706336 p.yiv0040706336MsoNormal, #yiv0040706336 li.yiv0040706336MsoNormal, #yiv0040706336 div.yiv0040706336MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;} #yiv0040706336 a:link, #yiv0040706336 span.yiv0040706336MsoHyperlink {color:blue;text-decoration:underline;} #yiv0040706336 a:visited, #yiv0040706336 span.yiv0040706336MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv0040706336 p.yiv0040706336MsoAcetate, #yiv0040706336 li.yiv0040706336MsoAcetate, #yiv0040706336 div.yiv0040706336MsoAcetate {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;} #yiv0040706336 span.yiv0040706336EmailStyle17 {color:windowtext;} #yiv0040706336 span.yiv0040706336BalloonTextChar {} #yiv0040706336 .yiv0040706336MsoChpDefault {} #yiv0040706336 filtered {margin:72.0pt 72.0pt 72.0pt 72.0pt;} #yiv0040706336 div.yiv0040706336WordSection1 {} #yiv0040706336 Dear Friends, I am stuck while preparing a dashboard. I need auto pickup of data based (in cell highlighted yellow) on model & date from the right side. If I change date (from 31-Jan-17 to 27-Jan-17) the data should change.. I think Index/Match with vlookup should work.. but not sure how to use it.. please help. Best Regards, Amit Desai Contact: - 09867232534 Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 gr
Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!
On Fri, 2/10/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 11:46 AM On Fri, 2/10/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 10:58 AM On Fri, 2/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 8:02 AM On Fri, 2/10/17, RamiZ Majid wrote: Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!! To: "Kishore P V K" Cc: excel-macros@googlegroups.com Date: Friday, February 10, 2017, 7:47 AM Thanks bro!!! It worked. On Fri, Feb 10, 2017 at 2:09 AM, Kishore P V K wrote: Here is the simple solution for your requirement: Insert a new column before the URL column: Enter the formula as showed in A2 column below after enter the formula in A2 drag the column till the URL values. Then you will find the all domain names in the column A as per the below screen shot Then select the required columns and go to DATA ribbon and select "Remove duplicates" option when option comes just select the newly created column A (Domain) Then click OK. There you go: Hope this helps you !!! Cheers On Thu, Feb 9, 2017 at 3:34 AM, Ramiz Majid wrote: I have a list of webpages contacting different domain pages!!! I want to pick a single webpage of each domains Please help ! This is an example list: And I need this as . Thanks! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discu ssexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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
Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)
On Thu, 2/16/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:39 AM On Thu, 2/16/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:36 AM On Thu, 2/16/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 12:59 AM On Wed, 2/15/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 9:04 PM On Wed, 2/15/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 5:11 PM On Wed, 2/15/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: "excel-macros@googlegroups.com" Date: Wednesday, February 15, 2017, 4:51 PM There are several ways to approach this.Here's the logic I used:first: Excel date is stored as a number. (the number of days since 1/1/1900)Excel TIME is stored as the decimal part of a day.so, the date/time: 19/11/2016 12:10 PM is actually 42693.50694Excel allows you to DISPLAY this value in a variety of ways, but it doesn't change the value. That means that to determine the time of day without regard to the date, you must subtract the "integer" portion of the value. Now, if you worked from Monday, 2-Feb to Friday, 10-Feb, you expect the result to show you worked 5 days.However, simply subtracting day #42772 from day #42776 gives you a DIFFERENCE of 4 instead of 5!So, you have to be careful with date arithmetic... Excel provides two functions:NetworkdaysNetworkdays.intl Networkdays.intl provides a means to define which days are your "weekend".(some people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and Wednesday off for their "weekend")This also provides a means to say ALL days are workdays! (thereby, "including weekends"). In the file attached, I created a sheet with Named Ranges for Start_Time, End_Time and HolidayListYou can add/remove dates to this HolidayList as appropriate to your needs. The logic is to first calculate the number of workdays between the Start date and End data.=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)Now, the End_Time - Start_Time gives you the fractional part of a day that represents a "full" workday.Multiplying this times the number of workdays results in the number of hours if full days are worked. This number needs to be adjusted based on the actual start/end time.If the start or end day is on a weekend, then the actual start/end time is disregarded.IF(WEEKDAY($A2,2)>5,0 Otherwise, for the start time, subtract the actual start time (A2 - int(A2)) from the scheduled "Start_Time".Now, if the person started BEFORE the scheduled start time, this value will be negative and should be disregarded. (unless you wish to calculate "overtime", or allow for a person to come in 30 minutes early and leave 30 minutes early?) so, to use only positive numbers, you can use: MAX(($A2-INT($A2))-Start_Time,0) For End time, the arithmetic is reversed: MAX(End_Time-($B2-INT($B2)),0) So, calculating the full working days, and removing the adjustments for start/end time, you get:=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)*(End_Time-Start_Time) -(IF(WEEKDAY($A2,2)>5,0,MAX($A2-INT($A2)-Start_Time,0)))
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 12:59 AM On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 8:50 PM On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 2:56 PM On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 7:11 AM On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 6:21 PM On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 11:52 AM On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 10:38 AM On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 9:46 AM On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 7:40 AM On Wed, 2/22/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 12:07 AM On Tue, 2/21/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Tuesday, February 21, 2017, 4:01 PM On Tue, 2/21/17, Emamuddin Shah wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Tuesday, February 21, 2017, 3:11 PM Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote:Dear Paul, i will share my both excel sheets, so that you can check where iam wrong and correct it, since the document is confidential i cant share here, plz provide your email id. regards Emam
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Sat, 2/25/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Saturday, February 25, 2017, 5:37 AM On Sat, 2/25/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Saturday, February 25, 2017, 1:19 AM On Fri, 2/24/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:16 PM On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 6:07 PM On Fri, 2/24/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 1:02 PM On Fri, 2/24/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:57 AM On Fri, 2/24/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:44 AM On Fri, 2/24/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 9:21 AM On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 3:56 AM On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 12:59 AM On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 8:50 PM On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 2:56 PM On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 7:11 AM On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017
Re: $$Excel-Macros$$ Solve Query
On Tue, 2/28/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Tuesday, February 28, 2017, 9:28 AM On Tue, 2/28/17, Gowrisankar Arthanari GSA wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Tuesday, February 28, 2017, 7:35 AM PFA On Mon, Feb 27, 2017 at 4:18 PM, Ram ji wrote: hey anyone solve the query -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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. n directa corelatie cu raspandirea culturii prin invatamant se prezinta si tabloul vietii editoriale. Nu numai Bucurestiul sau cateva mari orase centre universitare iau parte la aceasta activitate editoriala ci uneori chiar centre urbane de mai mica importanta isi au editurile lor este suficient un spirit intreprinzator pentru a initia o asemenea activitate. Exemplul lui Nicolae orga care a transformat Valenii de Munte intr-un focar de cultura este cel mai rasunator dar nu singurul. Cele mai importante edituri ale epocii raman Cartea Romaneasca Casa- scoalelor Cugetarea Fundatia pentru literatura si arta Regele Carol al II Scrisul Romanesc . Diversitatea publicatiilor este mare de la editii de lux la editii populare cea mai cunoscuta fiind Biblioteca pentru toti . Ea a publicat de la clasici la contemporani atat din literatura romana cat si traduceri din diferite limbi straine. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 an
Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA
On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 11:48 PM On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date: Thursday, March 2, 2017, 9:32 PM I deleted a row and received the "Type Mismatch" error.If you select "Debug", you'll see that the offending line of code is: If Target.Value = "OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it isn't a single cell, but an array of cells! When you change multiple cells (even by deleting, or inserting, or copying), then the Change event is passed an range ARRAY rather than a single range. In your case, you have a choice.You can add an if() statement like:if (Target.count > 1) then exit sub Or, you can process each cell in the target array like: dim Targ as rangefor each Targ in Target... (replace each occurrence of "Target" with "Targ") ...Next Targ 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 Thursday, March 2, 2017 12:33 PM, Maatangi M. Karthik wrote: I am absolutely new to excel VBA. I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references. What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns. Following are the issues that I want help with: When inserting / deleting row / rows, get error "Type Mismatch error 13" The same error appears while certain columns are extended down to the cells. Same error while cut copy pasting a row Although the run time error occurs, the action is partially completed Earliest response would be much appreciated. My sample excel is attached -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 thr
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
On Sat, 3/4/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 7:10 AM Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: First of all, your IF() statement:A nested if statement will evaluate each section until it finds a true() option.So, in the first case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it!Your IF statement could be simplified to:IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0 ) But, you can simplify it even more.You're using the 15th of the month as the "break point".So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th.Basically, by subtracting 15, you're setting the "break point" as the first of the month.So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or:MONTH(A6-15) * 15Now, the issue is with the first half of January.subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year:=IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5) This seems match the same as your sample values for rows 5-9,but I'm not sure what you were doing with rows 12-16Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ???I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2.You can accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps. 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 Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:IF(TODAY()<=42750,0,IF(AND( TODAY()>=42751,TODAY()<=42781) ,1.5,IF(AND(TODAY()>=42782, TODAY()<=42809),3,IF(AND( TODAY()>=42810,TODAY()<=42840) ,4.5,IF(AND(TODAY()>=42841, TODAY()<=42870),6,IF(AND( TODAY()>=42871,TODAY()<=42901) ,7.5,IF(AND(TODAY()>=42902, TODAY()<=42931),9,IF(AND( TODAY()>=42932,TODAY()<=42962) ,10.5,IF(AND(TODAY()>=42963, TODAY()<=42993),12,IF(AND( TODAY()>=42994,TODAY()<=43023) ,13.5,IF(AND(TODAY()>=43024, TODAY()<=43054),15,IF(AND( TODAY()>=43055,TODAY()<=43084) ,16.5,IF(AND(TODAY()>=43085, TODAY()>=43085),18,0)) ))) Please check excel sheet...Thanks in advance for help! -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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+unsubscribe@ 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
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
On Sat, 3/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 8:02 AM On Sat, 3/4/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 7:10 AM Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: First of all, your IF() statement:A nested if statement will evaluate each section until it finds a true() option.So, in the first case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it!Your IF statement could be simplified to:IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0 ) But, you can simplify it even more.You're using the 15th of the month as the "break point".So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th.Basically, by subtracting 15, you're setting the "break point" as the first of the month.So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or:MONTH(A6-15) * 15Now, the issue is with the first half of January.subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year:=IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5) This seems match the same as your sample values for rows 5-9,but I'm not sure what you were doing with rows 12-16Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ???I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2.You can accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps. 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 Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:IF(TODAY()<=42750,0,IF(AND( TODAY()>=42751,TODAY()<=42781) ,1.5,IF(AND(TODAY()>=42782, TODAY()<=42809),3,IF(AND( TODAY()>=42810,TODAY()<=42840) ,4.5,IF(AND(TODAY()>=42841, TODAY()<=42870),6,IF(AND( TODAY()>=42871,TODAY()<=42901) ,7.5,IF(AND(TODAY()>=42902, TODAY()<=42931),9,IF(AND( TODAY()>=42932,TODAY()<=42962) ,10.5,IF(AND(TODAY()>=42963, TODAY()<=42993),12,IF(AND( TODAY()>=42994,TODAY()<=43023) ,13.5,IF(AND(TODAY()>=43024, TODAY()<=43054),15,IF(AND( TODAY()>=43055,TODAY()<=43084) ,16.5,IF(AND(TODAY()>=43085, TODAY()>=43085),18,0)) ))) Please check excel sheet...Thanks in advance for help! -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 mea
Re: $$Excel-Macros$$ Solve Query
On Sun, 3/5/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Sunday, March 5, 2017, 10:13 PM On Sun, 3/5/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Sunday, March 5, 2017, 6:59 PM On Sun, 3/5/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Sunday, March 5, 2017, 5:02 PM On Sun, 3/5/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Sunday, March 5, 2017, 1:13 PM On Sun, 3/5/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: excel-macros@googlegroups.com Date: Sunday, March 5, 2017, 9:09 AM On Sun, 3/5/17, Ram ji wrote: Subject: Re: $$Excel-Macros$$ Solve Query To: "MS EXCEL AND VBA MACROS" Date: Sunday, March 5, 2017, 8:05 AM hey hi change the data base not working pls explain me ...? bro... On Tuesday, February 28, 2017 at 11:05:50 AM UTC+5:30, a.gowri wrote:PFA On Mon, Feb 27, 2017 at 4:18 PM, Ram ji wrote: hey anyone solve the query -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 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 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 htt