Re: $$Excel-Macros$$ Pivot Help
On Fri, 2/2/18, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Friday, February 2, 2018, 4:20 AM On Wed, 1/31/18, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Wednesday, January 31, 2018, 5:09 PM On Wed, 1/31/18, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Wednesday, January 31, 2018, 4:21 AM On Tue, 1/30/18, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Tuesday, January 30, 2018, 2:58 PM On Tue, 1/30/18, Saleem Ansari wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com, "Chandra Shekar" Date: Tuesday, January 30, 2018, 7:12 AM On Thu, Jan 25, 2018 at 5:13 PM, Chandra Shekar wrote: Hello Saleem, There is a small change in the data have attached same. Regards, Chandru On Thu, Jan 25, 2018 at 4:53 PM, Chandra Shekar wrote: Hello Saleem, Is it possible to get field one after another. that is Accp then Accp %. Can you explain in steps how to do it. Thanks in advance. Regards, Chandru On Thu, Jan 25, 2018 at 12:09 PM, Saleem Ansari wrote: Please check & revert On Wed, Jan 24, 2018 at 7:41 PM, Chandra Shekar wrote: Hello, Can I get result in attached using Pivot. Thanks in advance. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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/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
Re: $$Excel-Macros$$ Pivot Help
On Tue, 1/30/18, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Tuesday, January 30, 2018, 2:58 PM On Tue, 1/30/18, Saleem Ansari wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com, "Chandra Shekar" Date: Tuesday, January 30, 2018, 7:12 AM On Thu, Jan 25, 2018 at 5:13 PM, Chandra Shekar wrote: Hello Saleem, There is a small change in the data have attached same. Regards, Chandru On Thu, Jan 25, 2018 at 4:53 PM, Chandra Shekar wrote: Hello Saleem, Is it possible to get field one after another. that is Accp then Accp %. Can you explain in steps how to do it. Thanks in advance. Regards, Chandru On Thu, Jan 25, 2018 at 12:09 PM, Saleem Ansari wrote: Please check & revert On Wed, Jan 24, 2018 at 7:41 PM, Chandra Shekar wrote: Hello, Can I get result in attached using Pivot. Thanks in advance. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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/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 from this group and st
Re: $$Excel-Macros$$ macros won't run as written
On Fri, 1/12/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ macros won't run as written To: excel-macros@googlegroups.com Date: Friday, January 12, 2018, 4:27 AM On Wed, 1/10/18, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ macros won't run as written To: "excel-macros@googlegroups.com" Date: Wednesday, January 10, 2018, 10:08 PM What does your macro look like? I recorded a macro, then "cleaned it up".the result being: Sub PageFormat ActiveSheet.PageSetup.LeftFooter = "&D" ActiveSheet.PageSetup.RightFooter = "&Z&F" End Sub it seems to work great in Excel 2010 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 9, 2018 5:26 PM, "kspeck...@kearnycountyhospital.com" wrote: I have a very basic macro to do a page set up format. Even though it looks right in VBA it doesn't do what it is set up to do. I set up the following: Page - Fit 1 to 1 and Landscape - this part worksMargins settings - this part also worksHeader/Footer - Put [&(Date] in the Left section and &{Path]&[File] in Right section - it always changes it to this in the Left section &&R&[Path] with nothing in Right sectionSheet - Rows to Repeat at top - this works, but it changes the Comments from none to At end of sheet. I have gone to Trust Center and have Enable all macros selected, and I save my workbooks as Excel Macro-Enabled Workbook.Our IT dept has uninstalled and reinstalled my Microsoft Excel products and it just happens again. They cannot figure it out.I can copy the VBA out here if it helps. Any ideas would be greatly appreciated!Kelly Ann -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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. lUa*'a concreta a Principatelor unde autoritatea puterii suzerane fusese Cata. a determinat insa interventia armata a
Re: $$Excel-Macros$$ Re: concatenate in one cell
On Sat, 12/30/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Saturday, December 30, 2017, 11:18 AM On Fri, 12/29/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Friday, December 29, 2017, 3:34 AM On Thu, 12/28/17, N.Shivkumar wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Thursday, December 28, 2017, 8:14 AM see attached solution On 25 December 2017 at 14:35, Aamir Shahzad wrote: this is manual formula & need select cells one by one I want to use entire range e.g. A1:HL1 On Mon, Dec 25, 2017 at 4:40 AM, who wrote: =trim(C4)&trim(D4)&trim(E4)&tr im(F4)&trim(G4) Try the above, assuming the data is in the addresses used. Thanks, David On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:Friends, I want to concatenate all below data in one cell without any space. Formula please. data148351,183776,032290, result148351,183776,032290 Regards, Aamir Shahzad -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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. -- Regards,Aamir Shahzad -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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 n
Re: $$Excel-Macros$$ reconiling large data in excel
On Thu, 9/21/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ reconiling large data in excel To: excel-macros@googlegroups.com Date: Thursday, September 21, 2017, 3:28 PM On Thu, 9/21/17, Mohammed Hamed Ajaz wrote: Subject: Re: $$Excel-Macros$$ reconiling large data in excel To: excel-macros@googlegroups.com Date: Thursday, September 21, 2017, 1:24 PM Dear All, I was trying to reconcile the amount from ven & led sheets and identify the differences. date column and other column is irrelevant.I tired through vlookup but couldn't make out the differences.Pls help in reconciling it. Thanks,Regards. On Tue, Sep 19, 2017 at 2:36 PM, Mohammed Hamed Ajaz wrote: Dear All, I was trying to reconcile the amount from ven & led sheets and identify the differences. date column and other column is irrelevant.I tired through vlookup but couldn't make out the differences.Pls help in reconciling it. Thanks,Regards. On Mon, Sep 18, 2017 at 6:44 PM, Paul Schreiner wrote: I have no idea what you're trying to do.You have one sheet called "ven" which has 998 rows dating from April 1, 2017 to December 24, 2019then you have a sheet called "ledg" which has 2009 rows from to April 1, 2016 April 10, 2016.None of the dates overlap, so trying to guess what you're trying to accomplish with "reconciling" the data is not possible. Please provide an example of what results you're trying to achieve. 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, September 18, 2017 10:50 AM, Mohammed Hamed Ajaz wrote: Dear All, Please Help in reconciling large data in excel. i had tried through vlookup but i am not reconcile since data contains same values twice or more times hence in vlookup its ignoring the same value. Kindly do the needful in finding the solution. For your reference i have attached file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/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/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
Re: $$Excel-Macros$$ Help on Week Formula
On Sun, 7/30/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 3:31 PM On Sun, 7/30/17, Chandra Shekar wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 2:57 PM Hello Paul, For Ex: If I mention date as 07/01/2017(Sat) formula should give Week 1 from there every week it should increase by 1.1) 07-01-2017 to 07-07-2017 = Week12) 22-01-2017 to 28-07-2017 = Week43) 29-07-2017 - 04-08-2017 = Week5 Regards, Chandru On Tue, Jul 25, 2017 at 4:31 PM, Paul Schreiner wrote: I think you'll need to be more specific on how you want the "weeks" calculated.For instance, in August (2017) August 1 is on a Tuesday. so, the weeks are handled: but, July 1 is on a Saturday,so, does Week 1 only have a single day? Or is July 1 counted as part of week 5 of June.If so, what is the minimum number of days counted in a week 1? Or are you wanting a simple count of days:Week 1 = first 7 daysWeek 2 = Second 7 daysetc. 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, July 25, 2017 3:34 AM, Chandra Shekar wrote: Hello Team, Could you please help me in attached week formula. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or ma
Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
On Thu, 7/6/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Thursday, July 6, 2017, 4:44 PM Hi Swapnil, Thanks you so much appreciate your time and help on getting this macro. I think got almost what required, there is only small changes, which need to be done. Sorry its my mistake not giving right information on that. The reason I am looking a macro is I can't educate others who are very beginning stage of learning. Macro will be more easier for them to use than conditional formatting. I have added my comments in Final Tab. Please review and let me know if any points are unclear. Thanks Putta On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande wrote: Hi, Why are you not using conditional formatting. If your main purpose is to display user duplicates and empty cells, conditional formatting is best solution. Have applied both solutions (conditional formatting as well as macro) in attached excel. Regards, Swapnil. On Wed, Jul 5, 2017 at 12:24 AM, Puttu * wrote: anyhelp please On Tue, Jul 4, 2017 at 12:33 PM, Puttu * wrote: Thanks Sir, Formula match exactly my requirement, however I have more than 50 columns, quite difficult to input formula for every column. Thus the reason I am looking for macro. Please help On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande wrote: Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: Experts, Any help on this will be much appreciated On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: Hi Experts Please help on this. Thanks Putta On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: Hi Experts, I am not a vba expert and need your help me on the attached requirement. I have list of columns and from that I need to know based on the Model No. column filter if the other columns have any duplicate values, if yes then it should display comments column as Column Name + duplicate value (Ex: Category_description having duplicate value) 2. If the any of the column is blank it should print Column Name is blank (Ex: Parent Category ID has blank value). Attached is the sample spread sheet. Please review and help me on it. -- Putta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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. -- Putta -- Putta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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 gro
Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
On Wed, 7/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Wednesday, July 5, 2017, 2:43 AM On Tue, 7/4/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Tuesday, July 4, 2017, 10:03 AM Thanks Sir, Formula match exactly my requirement, however I have more than 50 columns, quite difficult to input formula for every column. Thus the reason I am looking for macro. Please help On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande wrote: Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: Experts, Any help on this will be much appreciated On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: Hi Experts Please help on this. Thanks Putta On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: Hi Experts, I am not a vba expert and need your help me on the attached requirement. I have list of columns and from that I need to know based on the Model No. column filter if the other columns have any duplicate values, if yes then it should display comments column as Column Name + duplicate value (Ex: Category_description having duplicate value) 2. If the any of the column is blank it should print Column Name is blank (Ex: Parent Category ID has blank value). Attached is the sample spread sheet. Please review and help me on it. -- Putta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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. -- Putta -- Putta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? 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
Re: $$Excel-Macros$$ Re: Required break chart in excel
On Sat, 6/17/17, amar takale wrote: Subject: Re: $$Excel-Macros$$ Re: Required break chart in excel To: excel-macros@googlegroups.com Date: Saturday, June 17, 2017, 7:10 AM no,I have got it but how to done it?I will try but not success,if possible can you Create line chart in my attached excel so I got confidence. On Fri, Jun 16, 2017 at 2:12 PM, Rajan Verma wrote: so you have already got it. Regards Rajan On Fri, 16 Jun 2017 at 12:08 PM, amar takale wrote: http://www. exceldashboardtemplates.com/ how-to-show-gaps-in-a-line- chart-when-using-the-excel-na- function/ On Thu, Jun 15, 2017 at 12:53 PM, Rajan Verma wrote: show me some image to replicate the chart. RegardRajan Verma On Tuesday, 6 June 2017 05:39:58 UTC-6, amar takale wrote:Dear all friends I Required break chart in excel.between data if there are blank cell then chart show break. Actually in blank cell there are formula(yellow cell) which show blank cell (If +is error+blank formula). Finally I need prepare Break chart on yellow cell data range ,Can We do this? 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. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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@
Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Friday, June 2, 2017, 4:22 AM On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Thursday, June 1, 2017, 6:30 PM On Thu, 6/1/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: "excel-macros@googlegroups.com" Date: Thursday, June 1, 2017, 4:47 PM There is no standard format for "Raw Data".It depends on the original Application used to CREATE the source of data.Some systems output ASCII (text) files Some are tab delimited.Others are comma delimited (csv). The mechanism you used to read in the "raw data" used known characteristics of the data to determine how it is to be interpreted. Without knowing the characteristics of the "raw data", it would be impossible to reverse-engineer the file. It's like saying: "I'm standing outside of my home, tell me how I got here"The answer requires first knowing where you started and what options are available to get from the start to the end.Lots of options are AVAILABLE, but if your starting point is two streets away, the use of an airplane is unlikely. Teleportation is WAY cooler, and should remain in consideration for that reason! :) More details are required. 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, June 1, 2017 10:20 AM, Secret Shot wrote: Dear Team, I have one very large excel table which i made from Raw data, accidentally raw data has been deleted and the only option i have is that table to convert back in raw data. Its about my job so pls help, i have attached of the sample of what i am talking about. if anyone can me in writing a macro which can create raw data basis on the count in front of number and considering their header. Please help -- Pankaj Pandey Bhopal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are 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
Re: $$Excel-Macros$$ Re: Macros for screenshot
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 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