Re: $$Excel-Macros$$ Pie Chart Help
Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pie Chart Help
Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For
Re: $$Excel-Macros$$ Pie Chart Help
Pfa Are you looking for this On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To
Re: $$Excel-Macros$$ Pie Chart Help
Respected Ranjan, For that type of data you can use a stacked pie chart or a pie of pie chart .You can find how to prepare a stacked pie chart in Ms Excel Help or you can follow the following links also.hope they may be of some help to you http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted
Re: $$Excel-Macros$$ Pie Chart Help
Thanks Priti and Vijay and to all, yes it will help me to figure out my solution. thanks a ton champs. With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Ranjan, For that type of data you can use a stacked pie chart or a pie of pie chart .You can find how to prepare a stacked pie chart in Ms Excel Help or you can follow the following links also.hope they may be of some help to you http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question
$$Excel-Macros$$ Intersection of points in graph
CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. inline: image001.jpg Intersection of points.xlsx Description: Intersection of points.xlsx
Re: $$Excel-Macros$$ Pie Chart Help
Respected Priti, Can you explain the process of fusing the Pie and Doughnut Chart.How to edit the series as to show both the charts as single chart as shown in your attachment.Can you explain the process of making the chart or can you give a link to it. Thanks in advance, Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 12:39 PM, Rajan sharma rajansharma9...@gmail.comwrote: Thanks Priti and Vijay and to all, yes it will help me to figure out my solution. thanks a ton champs. With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, For that type of data you can use a stacked pie chart or a pie of pie chart .You can find how to prepare a stacked pie chart in Ms Excel Help or you can follow the following links also.hope they may be of some help to you http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.com wrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or
Re: $$Excel-Macros$$ Pie Chart Help
HI vijay use following steps 1).prepare two chart one is pie chart based on intermediate data and second is doughnut chart based on original data. 2).paste doughtnut chart on pie chart 3) and then arrange data labels of corresponding chart On Wed, Jun 26, 2013 at 12:53 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Priti, Can you explain the process of fusing the Pie and Doughnut Chart.How to edit the series as to show both the charts as single chart as shown in your attachment.Can you explain the process of making the chart or can you give a link to it. Thanks in advance, Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 12:39 PM, Rajan sharma rajansharma9...@gmail.comwrote: Thanks Priti and Vijay and to all, yes it will help me to figure out my solution. thanks a ton champs. With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, For that type of data you can use a stacked pie chart or a pie of pie chart .You can find how to prepare a stacked pie chart in Ms Excel Help or you can follow the following links also.hope they may be of some help to you http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.com wrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange color) is only a subset of B, So, A= 927688 B= 1093947 Now C = 20 should be under B Area, it means out of total B area, some portion of C is covered. Hope you might have understand my query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear All, I am trying to plot Pie chart, but unable to plot as per my data. Can somebody help me in plotting the data as pie chart. My requirement and the criteria is attached here with, plse find the attachment. Actually as of now i have done with the shapes and tried to explain, plse refer attached file. Thanks With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop
Re: $$Excel-Macros$$ Pie Chart Help
Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the one you did in the attachment. Regards, VIJAYKUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel
Here is the sample, i'am using xpdf, a free software to convert your pdf to text, then read that text to get the desired value You can download xpdf from www.foolabs.com/xpdf/download.html and put file named pdftotext.exe in same folder with this attachment. Rgds, [dp] On 26/06/2013 11:45, Francis Mukobi wrote: Basole ricardo...@gmail.com wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. New Microsoft Excel Worksheet.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Collate data from folder
Dear All, I have more than 100 excel files in a single folder. And all the folder has common headings. I want to collate all the 100 excel files into as one single sheets. How to do that, Is there option in excel upload option or by Vba ?. Plse suggest. My files are in D drive and folder name as Group_Data. Thanks experts. With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Screenshot with different shapes
*May I know how to take a screenshot with the shape given below. Thanks.* [image: Inline image 1] -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. error-bar.png
Re: $$Excel-Macros$$ Collate data from folder
http://www.excelfox.com/forum/f2/copy-data-from-multiple-workbooks-to-a-master-workbook-1045/ http://www.excelfox.com/forum/f2/consolidate-multiple-workbooks-from-a-folder-into-one-master-file-vba-1077/ Try these Regards, Sam On Wed, Jun 26, 2013 at 6:16 PM, Rajan sharma rajansharma9...@gmail.comwrote: Dear All, I have more than 100 excel files in a single folder. And all the folder has common headings. I want to collate all the 100 excel files into as one single sheets. How to do that, Is there option in excel upload option or by Vba ?. Plse suggest. My files are in D drive and folder name as Group_Data. Thanks experts. With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Intersection of points in graph
. check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Intersection of points.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Intersection of points in graph
Hi Sir, superb !! can u please share steps ..how to create *Thanks Regards,* *Santy* On Wed, Jun 26, 2013 at 8:47 PM, ashish koul koul.ash...@gmail.com wrote: . check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel
Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel
Ups sorry, my mistake Try new attached file Rgds, dp On 27/06/2013 1:13, ha...@mst.edu wrote: Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. New Microsoft Excel Worksheet.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ Intersection of points in graph
Thanks a lot Ashish. Regards, Krishnaraddi V Madolli. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 26 June 2013 20:48 To: excel-macros Subject: Re: $$Excel-Macros$$ Intersection of points in graph . check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.commailto:krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- Regards Ashish Koul Visit My Excel Bloghttp://www.excelvbamacros.com/ Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebookhttp://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Collate data from folder
Dear Sam, Sorry for the late reply. Thanks sir for sharing me the link, really that was awesome and help me solve my query. thanks With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 7:35 PM, Sam Mathai Chacko samde...@gmail.comwrote: http://www.excelfox.com/forum/f2/copy-data-from-multiple-workbooks-to-a-master-workbook-1045/ http://www.excelfox.com/forum/f2/consolidate-multiple-workbooks-from-a-folder-into-one-master-file-vba-1077/ Try these Regards, Sam On Wed, Jun 26, 2013 at 6:16 PM, Rajan sharma rajansharma9...@gmail.comwrote: Dear All, I have more than 100 excel files in a single folder. And all the folder has common headings. I want to collate all the 100 excel files into as one single sheets. How to do that, Is there option in excel upload option or by Vba ?. Plse suggest. My files are in D drive and folder name as Group_Data. Thanks experts. With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Plz help me to solve this prob
Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Plz help me to solve this prob
In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select shift cells up. You will not see that message.. Do similar steps for columnar data deletion. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:22 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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.commailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. 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 group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Plz help me to solve this prob
Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: In this case, you should do as follows; ** ** In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select “shift cells up”. You will not see that message.. ** ** Do similar steps for columnar data deletion. ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 10:22 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Plz help me to solve this prob ** ** Dear all, ** ** Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. ** ** ** ** the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please
$$Excel-Macros$$ Re: Introduce Yourself !!
Hi Everyone, I am Sandeep S Singh from India Hyderabad. I am a Software Engineer working with Cognizant. I have just now joined this group It is my first post. I work on QTP and Excel Macros. looking forward to interact with everyone here. have a good day :-) Thank, Sandeep Singh On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Plz help me to solve this prob
When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select shift cells up. You will not see that message.. Do similar steps for columnar data deletion. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:22 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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.commailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. 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
Re: $$Excel-Macros$$ Plz help me to solve this prob
Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. On Thu, Jun 27, 2013 at 9:33 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 10:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob ** ** Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. ** ** On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select “shift cells up”. You will not see that message.. Do similar steps for columnar data deletion. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 10:22 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- 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
RE: $$Excel-Macros$$ Plz help me to solve this prob
Yes, you can select those raws by shift +control + Down Arrow Delete. Similarly columns can be removed by shift + Control + Right Arrow Delete. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 11:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. On Thu, Jun 27, 2013 at 9:33 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:49 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select shift cells up. You will not see that message.. Do similar steps for columnar data deletion. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:22 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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.commailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. 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
Re: $$Excel-Macros$$ Plz help me to solve this prob
getting error as excel cannot complete this task with available resources. choose less data or close other applications On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Yes, you can select those raws by shift +control + Down Arrow Delete.** ** Similarly columns can be removed by shift + Control + Right Arrow Delete. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 11:07 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob ** ** Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. ** ** On Thu, Jun 27, 2013 at 9:33 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 10:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select “shift cells up”. You will not see that message.. Do similar steps for columnar data deletion. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *thameem *Sent:* 27 June 2013 10:22 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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
RE: $$Excel-Macros$$ Plz help me to solve this prob
It might be due to low RAM. If you are using MS Excel 2007, change the file type to Excel Binary Workbook. This file type will compress the data in lowest possible size. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 11:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob getting error as excel cannot complete this task with available resources. choose less data or close other applications On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: Yes, you can select those raws by shift +control + Down Arrow Delete. Similarly columns can be removed by shift + Control + Right Arrow Delete. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 11:07 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Is any possibility to delete unused cells in row and column, so i can reduce load, present am using 3000 rows and 40 columns rest all rows and coloumns are empty, thank you for ur support. On Thu, Jun 27, 2013 at 9:33 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: When you select entire raw/column... it selects all the cells of that raw/column (even unused) of your sheet...so in case if the file is huge this will definitely take long time to process by excel. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:49 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob Thank you, i will follow your step, but is any other solution for this? plz tell me, y this prob occurs, so i can take precautions in any other files. On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: In this case, you should do as follows; In case if you wants to delete all the contents of raw, select all the cells of that raw from first to last till the column heads are there, right click with mouse, select on Delete, on asking where to shift the below cells select shift cells up. You will not see that message.. Do similar steps for columnar data deletion. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of thameem Sent: 27 June 2013 10:22 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz help me to solve this prob Dear all, Am getting below message, when ever I delete row or column, and my system is getting hanged, am unable to do any editing. plz help me out. the operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. are you sure you want to continue? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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.commailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. 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.