Re: $$Excel-Macros$$ Data validation solution
Hi Noorin Sir Actually there are two worksheet in sheet.I think y are not see it. On Fri, Aug 24, 2012 at 11:28 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, See attached sheet, Hope it will help to you. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Fri, Aug 24, 2012 at 11:12 AM, amar takale amartak...@gmail.comwrote: Hi All I found Data validation sheet in group,It is ok if click main head then show its subhead.But if I will try it My sheet it show same subhead which is first subhead in list.I used same formula like Example sheet then what my mistake anybody show me my mistake where I wrong.Pls see sheet Thanks Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Data validation solution
Thanks Karan But middle column is necessary? I think not.Y can see Arun reply it is correct,select all cell Then Press Ctr+Enter. On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh karan1...@gmail.com wrote: Hi Amar, See attached sheet.. Karan Singh On Fri, Aug 24, 2012 at 11:12 AM, amar takale amartak...@gmail.comwrote: Hi All I found Data validation sheet in group,It is ok if click main head then show its subhead.But if I will try it My sheet it show same subhead which is first subhead in list.I used same formula like Example sheet then what my mistake anybody show me my mistake where I wrong.Pls see sheet Thanks Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Remove reference
=INDEX(August!$C$4:$O$51,MATCH(1,((August!$A$4:$A$51=Main!$I7)*(August!$B$4:$B$51=Main!$I$3)),0),MATCH(Main!J$5,August!$C$3:$O$3,0)) I will used this formula where criteria is not match give #NA So How to use ISERR funtion in this formula then cell show blank only instead of #NA but formula are in. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Remove reference
Hi Amar, Plz try this. =IF(ISERROR(INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0))), ,INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0))) On Fri, Aug 24, 2012 at 12:26 PM, amar takale amartak...@gmail.com wrote: =INDEX(August!$C$4:$O$51,MATCH(1,((August!$A$4:$A$51=Main!$I7)*(August!$B$4:$B$51=Main!$I$3)),0),MATCH(Main!J$5,August!$C$3:$O$3,0)) I will used this formula where criteria is not match give #NA So How to use ISERR funtion in this formula then cell show blank only instead of #NA but formula are in. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Remove reference
Thanks Chandra On Fri, Aug 24, 2012 at 1:10 PM, Chandra Gupta cgmaury...@gmail.com wrote: Hi Amar, Plz try this. =IF(ISERROR(INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0))), ,INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0))) On Fri, Aug 24, 2012 at 12:26 PM, amar takale amartak...@gmail.comwrote: =INDEX(August!$C$4:$O$51,MATCH(1,((August!$A$4:$A$51=Main!$I7)*(August!$B$4:$B$51=Main!$I$3)),0),MATCH(Main!J$5,August!$C$3:$O$3,0)) I will used this formula where criteria is not match give #NA So How to use ISERR funtion in this formula then cell show blank only instead of #NA but formula are in. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ NUM ERROR
Nice its working,this is a beautiful formula pal , i am learning new stuff everyday , but tell me what is the essence of =--(ROW()O2) in the formula? thanks On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.comwrote: Refer the attached excel for modified solution. Let us know in case of any further assistance. --- Ms.Exl.Learner --- On Thu, Aug 23, 2012 at 8:26 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Bosses, PFA, i am trying to sort my data(in sheet1) by the largest figures(in sheet 2), i am getting a num error in the formular and i also realised that when two figures have same figure it repeats the first instance all though i thought the below formula will resolve that. kindly assist. thanks INDEX(Sheet1!A$2:A$21,SMALL(IF(Sheet1!$N$2:$N$21=P20,ROW(Sheet1!$A$2:$A$21)-ROW(Sheet1!$A$2)+1,),COUNTIF(Sheet1!$N$2:N19,Sheet1!N19))) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ NUM ERROR
One more thing, i want the data in the automated sheet to be arranged in order of the largest amount down to the least figure On Fri, Aug 24, 2012 at 8:35 AM, Hilary Lomotey resp...@gmail.com wrote: Nice its working,this is a beautiful formula pal , i am learning new stuff everyday , but tell me what is the essence of =--(ROW()O2) in the formula? thanks On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Refer the attached excel for modified solution. Let us know in case of any further assistance. --- Ms.Exl.Learner --- On Thu, Aug 23, 2012 at 8:26 PM, Hilary Lomotey resp...@gmail.comwrote: Hello Bosses, PFA, i am trying to sort my data(in sheet1) by the largest figures(in sheet 2), i am getting a num error in the formular and i also realised that when two figures have same figure it repeats the first instance all though i thought the below formula will resolve that. kindly assist. thanks INDEX(Sheet1!A$2:A$21,SMALL(IF(Sheet1!$N$2:$N$21=P20,ROW(Sheet1!$A$2:$A$21)-ROW(Sheet1!$A$2)+1,),COUNTIF(Sheet1!$N$2:N19,Sheet1!N19))) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Data validation solution
No, middle column is not necessary, I just put it for you. Yeah! Arun's method is right, he's told as I did. First Select all cells put formula Ctrl+Shift+Enter. Karan Singh On Fri, Aug 24, 2012 at 12:01 PM, amar takale amartak...@gmail.com wrote: Thanks Karan But middle column is necessary? I think not.Y can see Arun reply it is correct,select all cell Then Press Ctr+Enter. On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh karan1...@gmail.com wrote: Hi Amar, See attached sheet.. Karan Singh On Fri, Aug 24, 2012 at 11:12 AM, amar takale amartak...@gmail.comwrote: Hi All I found Data validation sheet in group,It is ok if click main head then show its subhead.But if I will try it My sheet it show same subhead which is first subhead in list.I used same formula like Example sheet then what my mistake anybody show me my mistake where I wrong.Pls see sheet Thanks Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to
Re: $$Excel-Macros$$ Data validation solution
Ok Karan, Thanks for reply Help. On Fri, Aug 24, 2012 at 2:23 PM, Karan Singh karan1...@gmail.com wrote: No, middle column is not necessary, I just put it for you. Yeah! Arun's method is right, he's told as I did. First Select all cells put formula Ctrl+Shift+Enter. Karan Singh On Fri, Aug 24, 2012 at 12:01 PM, amar takale amartak...@gmail.comwrote: Thanks Karan But middle column is necessary? I think not.Y can see Arun reply it is correct,select all cell Then Press Ctr+Enter. On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh karan1...@gmail.comwrote: Hi Amar, See attached sheet.. Karan Singh On Fri, Aug 24, 2012 at 11:12 AM, amar takale amartak...@gmail.comwrote: Hi All I found Data validation sheet in group,It is ok if click main head then show its subhead.But if I will try it My sheet it show same subhead which is first subhead in list.I used same formula like Example sheet then what my mistake anybody show me my mistake where I wrong.Pls see sheet Thanks Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure.
$$Excel-Macros$$ please join me in this group
Dear sir, Please join me in this group THNKS REGARDS GRKNAIDU -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ please join me in this group
Dear Krishna, Welcome you in Excel Macro world. You have already joined, Now you can post your query : Group email ID : excel-macros@googlegroups.com. On Fri, Aug 24, 2012 at 3:47 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote: Dear sir, Please join me in this group THNKS REGARDS GRKNAIDU -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Excel Photo Background - reg.
Dear Pravin Can I copy that background photo. On Fri, Aug 24, 2012 at 3:41 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Amar There would be more blank space available in the small baby photo. And the extra blank size is not available in big baby's photo. Thant is reason it looks like this.. Pravin. -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Fri, Aug 24, 2012 at 10:50 AM Subject: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure) To: excel-macros@googlegroups.com -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Thu, Aug 23, 2012 at 6:00 PM Subject: Re: Delivery Status Notification (Failure) To: Mail Delivery Subsystem mailer-dae...@google.com I send small size file Pls check it On Thu, Aug 23, 2012 at 4:40 PM, Mail Delivery Subsystem mailer-dae...@google.com wrote: Hello amar takale amartak...@gmail.com, The message you are sending is too large. All messages must be less than 5.00 MBytes. The max size was set by the owners of this list ( excel-macros+ow...@googlegroups.com). If you have questions related to this or any other Google Group, visit the Help Center at http://groups.google.com/support/?hl=en. Thanks, Google Groups - Original message - Received: by 10.66.77.39 with SMTP id p7mr187986paw.0.1345720220610; Thu, 23 Aug 2012 04:10:20 -0700 (PDT) Received: by 10.66.77.39 with SMTP id p7mr187979paw.0.1345720219369; Thu, 23 Aug 2012 04:10:19 -0700 (PDT) Return-Path: amartak...@gmail.com Received: from mail-pb0-f48.google.com (mail-pb0-f48.google.com[209.85.160.48]) by gmr-mx.google.com with ESMTPS id nv4si3153530pbc.2.2012.08.23.04.10.18 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 23 Aug 2012 04:10:18 -0700 (PDT) Received-SPF: pass (google.com: domain of amartakale@gmail.comdesignates 209.85.160.48 as permitted sender) client-ip=209.85.160.48; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of amartak...@gmail.com designates 209.85.160.48 as permitted sender) smtp.mail=amartak...@gmail.com; dkim=pass header.i=@gmail.com Received: by mail-pb0-f48.google.com with SMTP id rq13so1200322pbb.21 for excel-macros@googlegroups.com; Thu, 23 Aug 2012 04:10:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=rJnEnqYOMGPkY6GI/56XmDc7jaSPV87oWaAq7Uy+7RI=; b=YvyHWv95ItYr6Fldl+dXh1aNq2Ayg+awfof+i2U6UrNGQTWRQ08taHP9H2AqHewcCL zr3IoxqZ0Nmc26v/ULRQtI63n2YmZ4AZlKG09KxFTJq6HxNOUOaAaE41knB4pwx4v4Tl wSS3F95/HVVm8liF0bZEyT4IESMkTqStecx6mSktgtBleNikkrtT/U6CIllhBDcy71ex f1R5iIBO+37TN1qn0zSZJesCX//O8k1bQyx42+hTnadjMXzv877s3YrnCihDFP7U7LB2 IJkRdoEIUU5wDJEoqtw8rHzGDvtwlwPDX7mFHFWsgkh5cECCWyqv6yyd2Ul81VVl05JS lK+g== MIME-Version: 1.0 Received: by 10.68.129.168 with SMTP id nx8mr3699333pbb.112.1345720217537; Thu, 23 Aug 2012 04:10:17 -0700 (PDT) Received: by 10.66.218.136 with HTTP; Thu, 23 Aug 2012 04:10:14 -0700 (PDT) Date: Thu, 23 Aug 2012 16:40:14 +0530 Message-ID: camnn7oyvq453uvh3qmmw+s0facwa5zd_zn7n67r+2uyfy7e...@mail.gmail.com Subject: Excel Background Picture Adjustment problem From: amar takale amartak...@gmail.com To: excel-macros@googlegroups.com Content-Type: multipart/mixed; boundary=047d7b10cb6f889fb004c7ece701 Hi All Experts, I found one excel in which baby picture photo properly adjusted above name (Baby Picture Background) But I try like this in my excel Photo expand big size.How to adjusted it in proper small size like first file?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw Anyone guide me about that Thanks Amar ?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To
Re: $$Excel-Macros$$ Excel Photo Background - reg.
You cant, but you can change the photo whatever you would like. On Fri, Aug 24, 2012 at 4:05 PM, amar takale amartak...@gmail.com wrote: Dear Pravin Can I copy that background photo. On Fri, Aug 24, 2012 at 3:41 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Amar There would be more blank space available in the small baby photo. And the extra blank size is not available in big baby's photo. Thant is reason it looks like this.. Pravin. -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Fri, Aug 24, 2012 at 10:50 AM Subject: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure) To: excel-macros@googlegroups.com -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Thu, Aug 23, 2012 at 6:00 PM Subject: Re: Delivery Status Notification (Failure) To: Mail Delivery Subsystem mailer-dae...@google.com I send small size file Pls check it On Thu, Aug 23, 2012 at 4:40 PM, Mail Delivery Subsystem mailer-dae...@google.com wrote: Hello amar takale amartak...@gmail.com, The message you are sending is too large. All messages must be less than 5.00 MBytes. The max size was set by the owners of this list ( excel-macros+ow...@googlegroups.com). If you have questions related to this or any other Google Group, visit the Help Center at http://groups.google.com/support/?hl=en. Thanks, Google Groups - Original message - Received: by 10.66.77.39 with SMTP id p7mr187986paw.0.1345720220610; Thu, 23 Aug 2012 04:10:20 -0700 (PDT) Received: by 10.66.77.39 with SMTP id p7mr187979paw.0.1345720219369; Thu, 23 Aug 2012 04:10:19 -0700 (PDT) Return-Path: amartak...@gmail.com Received: from mail-pb0-f48.google.com (mail-pb0-f48.google.com[209.85.160.48]) by gmr-mx.google.com with ESMTPS id nv4si3153530pbc.2.2012.08.23.04.10.18 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 23 Aug 2012 04:10:18 -0700 (PDT) Received-SPF: pass (google.com: domain of amartakale@gmail.comdesignates 209.85.160.48 as permitted sender) client-ip=209.85.160.48; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of amartak...@gmail.com designates 209.85.160.48 as permitted sender) smtp.mail=amartak...@gmail.com; dkim=pass header.i=@gmail.com Received: by mail-pb0-f48.google.com with SMTP id rq13so1200322pbb.21 for excel-macros@googlegroups.com; Thu, 23 Aug 2012 04:10:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=rJnEnqYOMGPkY6GI/56XmDc7jaSPV87oWaAq7Uy+7RI=; b=YvyHWv95ItYr6Fldl+dXh1aNq2Ayg+awfof+i2U6UrNGQTWRQ08taHP9H2AqHewcCL zr3IoxqZ0Nmc26v/ULRQtI63n2YmZ4AZlKG09KxFTJq6HxNOUOaAaE41knB4pwx4v4Tl wSS3F95/HVVm8liF0bZEyT4IESMkTqStecx6mSktgtBleNikkrtT/U6CIllhBDcy71ex f1R5iIBO+37TN1qn0zSZJesCX//O8k1bQyx42+hTnadjMXzv877s3YrnCihDFP7U7LB2 IJkRdoEIUU5wDJEoqtw8rHzGDvtwlwPDX7mFHFWsgkh5cECCWyqv6yyd2Ul81VVl05JS lK+g== MIME-Version: 1.0 Received: by 10.68.129.168 with SMTP id nx8mr3699333pbb.112.1345720217537; Thu, 23 Aug 2012 04:10:17 -0700 (PDT) Received: by 10.66.218.136 with HTTP; Thu, 23 Aug 2012 04:10:14 -0700 (PDT) Date: Thu, 23 Aug 2012 16:40:14 +0530 Message-ID: camnn7oyvq453uvh3qmmw+s0facwa5zd_zn7n67r+2uyfy7e...@mail.gmail.com Subject: Excel Background Picture Adjustment problem From: amar takale amartak...@gmail.com To: excel-macros@googlegroups.com Content-Type: multipart/mixed; boundary=047d7b10cb6f889fb004c7ece701 Hi All Experts, I found one excel in which baby picture photo properly adjusted above name (Baby Picture Background) But I try like this in my excel Photo expand big size.How to adjusted it in proper small size like first file?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw Anyone guide me about that Thanks Amar ?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you
$$Excel-Macros$$ Office 2010, activating sheet fails in Workbook_Open after going out of protected view
Hi Experts, there is a problem with my code, when i open my application first time and got error during sheet activate in workbook_open method. can you help me to solve out. Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need Help Urgent !!!!!!!!!!!!!!!!!!!
Why is YOUR request more URGENT than the request of anyone else? And, it appears that instead of asking a question to help yourself you are asking for a project to be done for free. Really! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jocky Beta Sent: Friday, August 24, 2012 7:15 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help Urgent !!! Hi, Please find the attached excel sheet in which their is a report Tab which generates following report automatically 1)Current Stock 2)Current stock by Reference but following report it did not generate as there is no Macros code for the same. Current Stock by Supplier Entrances by Supplier Entrances by Month Entrances by year Exit by Customer Exit by Month Exit by Year hence request all of you to do the needful. Regards, Jocky -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ New blog about IT
Hey everybody. I'm here to show my blog. Acess *www.trocandoideiasti.com.br*http://www.trocandoideiasti.com.br/. This is a blog that covers issues related to the IT field. Discussions about professions, technologies, tips, all this will be seen on our website. I hope all of you a visit. Thank you. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ New blog about IT
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. On Fri, Aug 24, 2012 at 6:16 PM, Trocando Ideias trocandoideia...@gmail.com wrote: Hey everybody. I'm here to show my blog. Acess * www.trocandoideiasti.com.br* http://www.trocandoideiasti.com.br/. This is a blog that covers issues related to the IT field. Discussions about professions, technologies, tips, all this will be seen on our website. I hope all of you a visit. Thank you. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Office 2010, activating sheet fails in Workbook_Open after going out of protected view
Dear Divaker, Please confirm, what's type error you are getting. IF possible send screen shot. On Fri, Aug 24, 2012 at 5:52 PM, Divaker Pandey divake...@gmail.com wrote: Hi Experts, there is a problem with my code, when i open my application first time and got error during sheet activate in workbook_open method. can you help me to solve out. Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ You are gonna like it !!
Was just making fun with Bubble Chart J Comments are welcome Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Fun.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ You are gonna like it !!
i just added it to the front page of one of my dashboards, its looking great. thanks Raj On Fri, Aug 24, 2012 at 1:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Was just making fun with Bubble Chart **J*** * * *Comments are welcome * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ You are gonna like it !!
Very nice, But don't forget to handle event on Activate and deactivate sheet, Start Macro on Sheet Activate and Stop that on Sheet Deactivate. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hilary Lomotey Sent: 24 August 2012 7:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ You are gonna like it !! i just added it to the front page of one of my dashboards, its looking great. thanks Raj On Fri, Aug 24, 2012 at 1:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Was just making fun with Bubble Chart J Comments are welcome Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ You are gonna like it !!
I dont get it, can u xplain more, did u name the macro KK, i tried it nothing happened, however if i click outside the range its goes round. can u xplain how it works?. thansk On Fri, Aug 24, 2012 at 1:47 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Very nice,* * But don’t forget to handle event on Activate and deactivate sheet, Start Macro on Sheet Activate and Stop that on Sheet Deactivate.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* 24 August 2012 7:14 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ You are gonna like it !! ** ** i just added it to the front page of one of my dashboards, its looking great. thanks Raj On Fri, Aug 24, 2012 at 1:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: * * *Was just making fun with Bubble Chart **J* * * *Comments are welcome * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of
Re: $$Excel-Macros$$ You are gonna like it !!
Mind blowing Rajan !!! On Fri, Aug 24, 2012 at 7:40 PM, Hilary Lomotey resp...@gmail.com wrote: I dont get it, can u xplain more, did u name the macro KK, i tried it nothing happened, however if i click outside the range its goes round. can u xplain how it works?. thansk On Fri, Aug 24, 2012 at 1:47 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Very nice,* * But don’t forget to handle event on Activate and deactivate sheet, Start Macro on Sheet Activate and Stop that on Sheet Deactivate.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* 24 August 2012 7:14 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ You are gonna like it !! ** ** i just added it to the front page of one of my dashboards, its looking great. thanks Raj On Fri, Aug 24, 2012 at 1:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: * * *Was just making fun with Bubble Chart **J* * * *Comments are welcome * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
Re: $$Excel-Macros$$ Re: plz solve problem
Hi Kiran, it's working fine. thank you very much for help me if have very dynamic dashboard with chart plz share Thanks! Pravesh On 8/24/12, Kiran Kancharla srkira...@gmail.com wrote: Please have a look on the file. I am sure sure abt AHT as u have not provided the remaining details for AHT calculation.. On Fri, Aug 24, 2012 at 12:29 AM, PRAVESH KUMAR praveshkash...@gmail.com wrote: Hi Excel Experts! Could you please solved this question though vb coding. if I select start date and end date then pick-up date from selected date.. it's urgent please Thanks Pravesh Kumar -- Forwarded message -- From: PRAVESH KUMAR praveshkash...@gmail.com Date: Sat, 18 Aug 2012 15:16:40 +0530 Subject: Re: $$Excel-Macros$$ Re: plz solve problem To: excel-macros@googlegroups.com, ms.exl.lear...@gmail.com Hi experts, thank you so much for help and it's working fine. could we pickup data on the date and all program base if we change date and program the pick data selected date with select program plz reply Thanks Pravesh Kumar On 8/18/12, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Pravesh, Copy and paste the below formula in C15 cell =VLOOKUP($D$2,INDIRECT('$D$3'!$A$1:$E$7),MATCH(C$14,INDIRECT('$D$3'!$A$1:$E$1),0),0) Drag the C15 cell formula to Right upto F15 cell. Hope that helps! --- Ms.Exl.Learner --- On Sat, Aug 18, 2012 at 1:01 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi experts please solve this problem for the same file attached. Thanks Pravesh Kumar On 8/15/12, PRAVESH KUMAR praveshkash...@gmail.com wrote: Hi All, please find attached file and solve my problem urgent. Thanks Pravesh -- *Thanks Regards* *Pravesh Kumar* -- Thanks Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards Pravesh Kumar -- Thanks Regards Pravesh Kumar -- Thanks Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
Re: $$Excel-Macros$$ You are gonna like it !!
Mind Freaking Rajan !!! Awesome!!! From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 24 August 2012 6:53 PM Subject: $$Excel-Macros$$ You are gonna like it !! Was just making fun with Bubble Chart J Comments are welcome Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need Help Urgent !!!!!!!!!!!!!!!!!!!
Better you should have created it in Ms-Access. *Ms.Exl.Learner* On Fri, Aug 24, 2012 at 5:45 PM, jocky Beta jocky6...@gmail.com wrote: Hi, Please find the attached excel sheet in which their is a report Tab which generates following report automatically 1)Current Stock 2)Current stock by Reference but following report it did not generate as there is no Macros code for the same. Current Stock by Supplier Entrances by Supplier Entrances by Month Entrances by year Exit by Customer Exit by Month Exit by Year hence request all of you to do the needful. *Regards,* *Jocky* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ NUM ERROR
Using Vlookup Or Match Function with the duplicated data will pick only the first match and it wont pick the second or third occurrence of the data as expected. In your case your data is having 4 zero values in Total and your data needs to be get sorted by the Total Value. So we are setting the Total Value as base value and trying to pull the remaining data. But due to duplication (0) in Total the vlookup and Match functions will leads to result the first match instead of the next subsequent data. So we need to tell Vlookup or Match function that each data are different by way of adding some other Number with the Total Value which should not be common. So I am using the Row() Function for differentiating each data. =Row() Using the above function in any of the cell will get the current row number of that cell. For example if you use the =Row() in cell C5 then it will result 5 as result. The Row() function will get the Row Number and I just merged the Row Number and Total using the symbol. =ROW()O2 Will merge both the Number by Treating As Text Data, since comes under Text Data Type, so it makes both the numbers [Row() and Total] as text data. But we cannot use the Large or Small function with the Number which is considered as text. So we need to convert the Text Number to real number for calculation purpose. =--(ROW()O2) Value() - Length 7 characters -- (Unary Operator) - Length 2 characters Using Value function or using double hyphen (--) Unary operator in front of the text Number will convert it as Real Number. But the same will result #VALUE! Error when it is referred to Text Characters other than Text Number. Mostly I prefer to use Double Hyphen (--) (Length 2 chrs) instead of Value() Function (Length 7 chrs), because it will be useful for us when we are building a lengthy formula. Hope that helps! *Ms.Exl.Learner* On Fri, Aug 24, 2012 at 2:05 PM, Hilary Lomotey resp...@gmail.com wrote: Nice its working,this is a beautiful formula pal , i am learning new stuff everyday , but tell me what is the essence of =--(ROW()O2) in the formula? thanks On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Refer the attached excel for modified solution. Let us know in case of any further assistance. --- Ms.Exl.Learner --- On Thu, Aug 23, 2012 at 8:26 PM, Hilary Lomotey resp...@gmail.comwrote: Hello Bosses, PFA, i am trying to sort my data(in sheet1) by the largest figures(in sheet 2), i am getting a num error in the formular and i also realised that when two figures have same figure it repeats the first instance all though i thought the below formula will resolve that. kindly assist. thanks INDEX(Sheet1!A$2:A$21,SMALL(IF(Sheet1!$N$2:$N$21=P20,ROW(Sheet1!$A$2:$A$21)-ROW(Sheet1!$A$2)+1,),COUNTIF(Sheet1!$N$2:N19,Sheet1!N19))) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message
Re: $$Excel-Macros$$ Excel Photo Background - reg.
ok pravin On Fri, Aug 24, 2012 at 4:09 PM, Pravin Gunjal isk1...@gmail.com wrote: You cant, but you can change the photo whatever you would like. On Fri, Aug 24, 2012 at 4:05 PM, amar takale amartak...@gmail.com wrote: Dear Pravin Can I copy that background photo. On Fri, Aug 24, 2012 at 3:41 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Amar There would be more blank space available in the small baby photo. And the extra blank size is not available in big baby's photo. Thant is reason it looks like this.. Pravin. -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Fri, Aug 24, 2012 at 10:50 AM Subject: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure) To: excel-macros@googlegroups.com -- Forwarded message -- From: amar takale amartak...@gmail.com Date: Thu, Aug 23, 2012 at 6:00 PM Subject: Re: Delivery Status Notification (Failure) To: Mail Delivery Subsystem mailer-dae...@google.com I send small size file Pls check it On Thu, Aug 23, 2012 at 4:40 PM, Mail Delivery Subsystem mailer-dae...@google.com wrote: Hello amar takale amartak...@gmail.com, The message you are sending is too large. All messages must be less than 5.00 MBytes. The max size was set by the owners of this list ( excel-macros+ow...@googlegroups.com). If you have questions related to this or any other Google Group, visit the Help Center at http://groups.google.com/support/?hl=en. Thanks, Google Groups - Original message - Received: by 10.66.77.39 with SMTP id p7mr187986paw.0.1345720220610; Thu, 23 Aug 2012 04:10:20 -0700 (PDT) Received: by 10.66.77.39 with SMTP id p7mr187979paw.0.1345720219369; Thu, 23 Aug 2012 04:10:19 -0700 (PDT) Return-Path: amartak...@gmail.com Received: from mail-pb0-f48.google.com (mail-pb0-f48.google.com[209.85.160.48]) by gmr-mx.google.com with ESMTPS id nv4si3153530pbc.2.2012.08.23.04.10.18 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 23 Aug 2012 04:10:18 -0700 (PDT) Received-SPF: pass (google.com: domain of amartakale@gmail.comdesignates 209.85.160.48 as permitted sender) client-ip=209.85.160.48; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of amartak...@gmail.com designates 209.85.160.48 as permitted sender) smtp.mail=amartak...@gmail.com; dkim=pass header.i=@gmail.com Received: by mail-pb0-f48.google.com with SMTP id rq13so1200322pbb.21 for excel-macros@googlegroups.com; Thu, 23 Aug 2012 04:10:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=rJnEnqYOMGPkY6GI/56XmDc7jaSPV87oWaAq7Uy+7RI=; b=YvyHWv95ItYr6Fldl+dXh1aNq2Ayg+awfof+i2U6UrNGQTWRQ08taHP9H2AqHewcCL zr3IoxqZ0Nmc26v/ULRQtI63n2YmZ4AZlKG09KxFTJq6HxNOUOaAaE41knB4pwx4v4Tl wSS3F95/HVVm8liF0bZEyT4IESMkTqStecx6mSktgtBleNikkrtT/U6CIllhBDcy71ex f1R5iIBO+37TN1qn0zSZJesCX//O8k1bQyx42+hTnadjMXzv877s3YrnCihDFP7U7LB2 IJkRdoEIUU5wDJEoqtw8rHzGDvtwlwPDX7mFHFWsgkh5cECCWyqv6yyd2Ul81VVl05JS lK+g== MIME-Version: 1.0 Received: by 10.68.129.168 with SMTP id nx8mr3699333pbb.112.1345720217537; Thu, 23 Aug 2012 04:10:17 -0700 (PDT) Received: by 10.66.218.136 with HTTP; Thu, 23 Aug 2012 04:10:14 -0700 (PDT) Date: Thu, 23 Aug 2012 16:40:14 +0530 Message-ID: camnn7oyvq453uvh3qmmw+s0facwa5zd_zn7n67r+2uyfy7e...@mail.gmail.com Subject: Excel Background Picture Adjustment problem From: amar takale amartak...@gmail.com To: excel-macros@googlegroups.com Content-Type: multipart/mixed; boundary=047d7b10cb6f889fb004c7ece701 Hi All Experts, I found one excel in which baby picture photo properly adjusted above name (Baby Picture Background) But I try like this in my excel Photo expand big size.How to adjusted it in proper small size like first file?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw Anyone guide me about that Thanks Amar ?ui=2ik=95477cf6e6view=attth=13952d1770f97448attid=0.1disp=saferealattid=f_h67ne6l50zw -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and
Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
Hi Hilary I used Excel 2003 Then how to see it On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.com wrote: Hi Guys, i just completed an upgrade of my stock market dashboard, pls use as you will. cheers -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.