Re: $$Excel-Macros$$ Cell show blank but in it show formula
NOORAIN Sir, Thanks very much Sir On Fri, Aug 17, 2012 at 12:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, Please try it. *=IF(ISERR(INDEX(INDIRECT($D$2),C4)),,INDEX(INDIRECT($D$2),C4))* see attached sheet. On Thu, Aug 16, 2012 at 5:18 PM, amar takale amartak...@gmail.com wrote: Thanks to all very much.One question ask to all there are custom formatting then error will disappear in cell?Is it right? I used index formula in my sheet but it show reference. I attached sheet here Pl see all. On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: You're Great Noorain Sir. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, In case of 2003 Version You can also use.. =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),,VLOOKUP(F5,$B$4:$D$9,3,0)) Or =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),,VLOOKUP(F5,$B$4:$D$9,3,0)) On Thu, Aug 16, 2012 at 3:39 PM, amar takale amartak...@gmail.comwrote: -- 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. -- 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
Re: $$Excel-Macros$$ How the excel searching the data in it
Hi Indrajit, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? Thanks Amar On Fri, Aug 17, 2012 at 5:02 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Pravin, You are right @ David, below is a formula in the Conditional formatting: =AND($F$4,ISERROR(FIND(LOWER($F$4),LOWER(B7)))=FALSE) Kindly find attached the image; you will understand how its work. Thanks Regards, Indrajit On Fri, Aug 17, 2012 at 4:52 PM, David Grugeon da...@grugeon.com.auwrote: Hi Pravin It is not magic it is condtional formatting. The condition looks if a cell is the same as the search cell and colors it. On 17 August 2012 17:59, Pravin Gunjal isk1...@gmail.com wrote: *Can anyone inform me how it works.. Thanks!* * * *With regards, **Pravin Gunjal** * -- 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. -- Regards David Grugeon -- 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
Re: $$Excel-Macros$$ MS Excel Vlookup query
Dear Vinod, Please try it.. =OFFSET($O$11,SMALL(IF($L$12:$L$20=$F$13,ROW($O$12:$O$20),),ROW(A1))-11,0) with ctrl+shift+enter See attachment for more clarity. On Tue, Aug 21, 2012 at 9:49 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Vinod, Please See attached file. Regards, Kuldeep Singh On Tue, Aug 21, 2012 at 12:10 AM, vinod rao vinod.ma...@gmail.com wrote: thanks Don. I could get the right result. Thanks for your help. Have a nice day. On Tue, Aug 21, 2012 at 12:09 AM, vinod rao vinod.ma...@gmail.comwrote: can i request you to put in the excel file. I am unable to get the relevelt result On Tue, Aug 21, 2012 at 12:02 AM, dguillett1 dguille...@gmail.comwrote: =INDEX($L$12:$O$26,SMALL(IF(($F$13=$L$12:$L$26),ROW($L$12:$L$26)-MIN(ROW($L$12:$L$26))+1,),ROW(A1)),4) An array formula that must be entered using ctrl+shift+enter Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* vinod rao vinod.ma...@gmail.com *Sent:* Monday, August 20, 2012 1:05 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query Hi, I need a formula plz. My data base is very huge. i cannot use autofilter. On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 dguille...@gmail.comwrote: Just use datafilterautofilter Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* vinod rao vinod.ma...@gmail.com *Sent:* Monday, August 20, 2012 12:35 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ MS Excel Vlookup query Hi Team, I want to put vlookup or any other foumula and get the second/third lookup data. See attached file for example. Thanks advance for any help. Regards Vin -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-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
$$Excel-Macros$$ Search Highlight name in list (1000 name list)
Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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. Customer Search CF.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Cell show blank but in it show formula
Thanks very much Vijayajith. On Fri, Aug 17, 2012 at 8:49 PM, vijayajith VA vijayajith...@gmail.comwrote: HI Prince,,, To avoid 0 s na please use below formula =IF(VLOOKUP(F4,B4:D9,2,0)=0,,VLOOKUP(F4,B4:D9,2,0)) On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey prince141...@gmail.comwrote: Please see the attachment regards prince On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote: -- 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$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF AVERAGEIFS★▂ ▃ ▅ ▆ █]
Hi Vijayendra Rao Can you send same sheet (If Ifs) Bocs I used Excel 2003 so it is difficult to understand. So Pls if possible Send me Sheet. Thanks Very Much Amar On Thu, Aug 16, 2012 at 4:39 PM, Vijayendra Rao vijayendrar...@gmail.comwrote: Hi, Please find attached file with example. Regards, Vijayendra 2012/8/16 Amresh Maurya amreshkushw...@gmail.com check below link. i hope it will help you. http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/ Reagrds Amresh On Thu, Aug 16, 2012 at 1:03 PM, amar takale amartak...@gmail.comwrote: Hi Amresh, Can you give example file.I also not understand what is different between. Thanks for help On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya amreshkushw...@gmail.com wrote: Hi , it works like sumif and sumifs.. we used it for find average value with criteria [image: Inline image 1] Regards Amresh On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: Hi Experts, What is the correct use of AVERAGEIF AVERAGEIFS. Kindly share more example with Excel Sheet. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.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 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$$ Search Highlight name in list (1000 name list)
Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.com wrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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. SCROLL BAR.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Search Highlight name in list (1000 name list)
Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.com wrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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$$ Search Highlight name in list (1000 name list)
Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.com wrote: Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.comwrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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
Re: $$Excel-Macros$$ Search Highlight name in list (1000 name list)
Dear Ameresh, Kindly tell me how we can put scroll in excel like you have done in attached worksheet... Thanks Regards, CA KSAGAR On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.com wrote: Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.comwrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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
Re: $$Excel-Macros$$ Search Highlight name in list (1000 name list)
Hi CA KSAGAR , GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET LOGIC.. Regards Amresh On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Ameresh, Kindly tell me how we can put scroll in excel like you have done in attached worksheet... Thanks Regards, CA KSAGAR On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.comwrote: Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya amreshkushw...@gmail.com wrote: Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.comwrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of
Re: $$Excel-Macros$$ Error! Pasting more than 15 digits
Hi Karan, See attached file. Regards, Kuldeep Singh On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh karan1...@gmail.com wrote: Dear All, I need your assistance in pasting below values in excel. I tried to paste but couldn't get the right result. When I'm pasting this digits it's showing like this :http://but%20couldn%27t%20get%20the%20result%20what%20I%20wanted 3.51971052214647E+32 Pls suggest something. 351971052214647655134425186115948 351971052214647655134425217331549 351971052214647655134425251419451 Karan Singh -- 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. Query..xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Error! Pasting more than 15 digits
Hi, Put one single quote and then paste the value. (it is applied only past value one by one only) If you want bulk paste: 1. make the format of the cell as 'text' 2. Past special - text. Regards Sara On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh karan1...@gmail.com wrote: Dear All, I need your assistance in pasting below values in excel. I tried to paste but couldn't get the right result. When I'm pasting this digits it's showing like this :http://but%20couldn%27t%20get%20the%20result%20what%20I%20wanted 3.51971052214647E+32 Pls suggest something. 351971052214647655134425186115948 351971052214647655134425217331549 351971052214647655134425251419451 Karan Singh -- 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$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF AVERAGEIFS★▂ ▃ ▅ ▆ █]
Hi Vijayendra It is not excel 2003 version formula On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao vijayendrar...@gmail.comwrote: 2012/8/21 amar takale amartak...@gmail.com Hi Vijayendra Rao Can you send same sheet (If Ifs) Bocs I used Excel 2003 so it is difficult to understand. So Pls if possible Send me Sheet. Thanks Very Much Amar On Thu, Aug 16, 2012 at 4:39 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Hi, Please find attached file with example. Regards, Vijayendra 2012/8/16 Amresh Maurya amreshkushw...@gmail.com check below link. i hope it will help you. http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/ Reagrds Amresh On Thu, Aug 16, 2012 at 1:03 PM, amar takale amartak...@gmail.comwrote: Hi Amresh, Can you give example file.I also not understand what is different between. Thanks for help On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya amreshkushw...@gmail.com wrote: Hi , it works like sumif and sumifs.. we used it for find average value with criteria [image: Inline image 1] Regards Amresh On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: Hi Experts, What is the correct use of AVERAGEIF AVERAGEIFS. Kindly share more example with Excel Sheet. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.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 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
Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet
There are many ways... Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rakesh Kumar Sharma Sent: Tuesday, August 21, 2012 6:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ Merging Two excel sheets on single sheet
Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ Merging Two excel sheets on single sheet
Yes. Have you tried looking? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Rakesh Kumar Sharma rakeshks@gmail.com To: excel-macros@googlegroups.com Sent: Tue, August 21, 2012 7:48:20 AM Subject: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF AVERAGEIFS★▂ ▃ ▅ ▆ █]
Dear Amar, You can use SUMPRODUCT Function in 2003 instead of countifs,Sumifs,Averageif and Averageifs. On Tue, Aug 21, 2012 at 4:55 PM, amar takale amartak...@gmail.com wrote: Hi Vijayendra It is not excel 2003 version formula On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao vijayendrar...@gmail.comwrote: 2012/8/21 amar takale amartak...@gmail.com Hi Vijayendra Rao Can you send same sheet (If Ifs) Bocs I used Excel 2003 so it is difficult to understand. So Pls if possible Send me Sheet. Thanks Very Much Amar On Thu, Aug 16, 2012 at 4:39 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Hi, Please find attached file with example. Regards, Vijayendra 2012/8/16 Amresh Maurya amreshkushw...@gmail.com check below link. i hope it will help you. http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/ Reagrds Amresh On Thu, Aug 16, 2012 at 1:03 PM, amar takale amartak...@gmail.comwrote: Hi Amresh, Can you give example file.I also not understand what is different between. Thanks for help On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya amreshkushw...@gmail.com wrote: Hi , it works like sumif and sumifs.. we used it for find average value with criteria [image: Inline image 1] Regards Amresh On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: Hi Experts, What is the correct use of AVERAGEIF AVERAGEIFS. Kindly share more example with Excel Sheet. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.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 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$$ Search Highlight name in list (1000 name list)
I would use a worksheet_change macro to do an autofilter for you. To show all select c5 and touch space bar Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range(b5:d5)) Is Nothing Then Exit Sub If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData tc = Target.Column - 1 Range(b6:d6).AutoFilter Field:=tc, Criteria1:==* Target * End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Tuesday, August 21, 2012 3:52 AM To: excel-macros@googlegroups.com ; NOORAIN ANSARI Subject: $$Excel-Macros$$ Search Highlight name in list (1000 name list) Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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.
$$Excel-Macros$$ conditional formatting
*Hi Smitha* * * *Pl try this...* * * *With regards, **Pravin Gunjal** * * * -- Forwarded message -- From: Smitha S R sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros$$ conditional formatting To: excel-macros@googlegroups.com The colour should be filled in the whole row, not only in the cell. The way suggested fill the colour in the cell only. -- 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. conditional formatting.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ conditional formatting
Dear Pravin, Could you please explain, how did you put the conditional formatting in all the cells together? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 21 August 2012 18:56 To: sperdwo...@gmail.com; excel-macros@googlegroups.com Subject: $$Excel-Macros$$ conditional formatting Hi Smitha Pl try this... With regards, Pravin Gunjal -- Forwarded message -- From: Smitha S R sperdwo...@gmail.commailto:sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros$$ conditional formatting To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com The colour should be filled in the whole row, not only in the cell. The way suggested fill the colour in the cell only. -- 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.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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$$ Merging Two excel sheets on single sheet
Dear Noorain, Plz find the sample file. I need to combine data on last sheet. in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid
Hello Experts,
I am sorry, but I am not getting right result for my query. May be I am
not able to explain what I am looking for
@ Don - I think there is some misunderstanding. PFA where I mentioned my
expected result.
I tried Using array - But unsuccessful.
My First array will be A1:A3 values{A,B,C}
second array B1:C1 Values(MH,GJ,KA)
My third array will be Number values
I want to print result in somewhere else,
as I already mentioned I tried myself but I think my knowledge and
understanding of VBA is not enough to solve this question.
Need your help.
Regards,
Amol j
On Monday, August 20, 2012 9:31:30 PM UTC+5:30, Don Guillett wrote:
Your first sample showed a blank col B. Try this
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 2).Resize(lr - 1)
Cells(2, i).Resize(lr).Copy Cells(dlr, 3)
Next i
Rows(2).Resize(lr - 1).Delete
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguil...@gmail.com javascript:
*From:* Amol J javascript:
*Sent:* Monday, August 20, 2012 10:20 AM
*To:* excel-...@googlegroups.com javascript:
*Subject:* Re: $$Excel-Macros$$ Need help on macro Re-organize data from
a 2 dimensional grid to a single dimensional grid
Hi Don,
Thanks for promt reply,
its not working for me. please check attachment. macro is working but
result is different than what I am looking for.
Please help me.
Thanks
Amol J
On Monday, August 20, 2012 7:13:48 PM UTC+5:30, Don Guillett wrote:
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 3 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 3).Resize(lr - 1)
Cells(2, i).Resize(lr).Copy Cells(dlr, 4)
Next i
Rows(2).Resize(lr - 1).Delete
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguil...@gmail.com
*From:* Amol J
*Sent:* Sunday, August 19, 2012 10:41 PM
*To:* excel-...@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help on macro Re-organize data from a 2
dimensional grid to a single dimensional grid
Hi Experts
I need macro to do the following thing,
a. Re-organize data from a 2 dimensional grid to a single dimensional
grid - see example below
source data:
Item Sales MH, GJ, KA
A 1 23
B 4 56
C 7 89
reformat to the following
Item STATE Sales
A MH 1
B MH 4
C MH 7
A GJ 2
B GJ 5
C GJ 8
A KA 3
B KA 6
C KA 9
Please help me on this problem.
Thanks,
Amol J
--
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-...@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros...@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
Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet
Move your destination sheet to be the FIRST SHEET and use this Sub combineem() For i = 2 To Sheets.Count Sheets(i).UsedRange.Copy Sheets(1).Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rakesh Kumar Sharma Sent: Tuesday, August 21, 2012 9:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Noorain, Plz find the sample file. I need to combine data on last sheet. in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http://noorainansari.com http://excelvbaclinic.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 mailto:excel-macros%2bunsubscr...@googlegroups.com. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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
Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet
hi, Try below Ashish code... Sub m() Dim i, j, k, s As Long s = Sheets.Count For i = 1 To s Sheets(i).Select 'change upper row here in this case it will start copying from second row j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Next i End Sub On Tue, Aug 21, 2012 at 7:57 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Noorain, Plz find the sample file. I need to combine data on last sheet. in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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
Re: $$Excel-Macros$$ conditional formatting
Dear Amit, Create a simple Conditional formating rule and Manage it for Whole rows. Hilary Screen shot is nicely describing it. On Tue, Aug 21, 2012 at 7:30 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Pravin, ** ** Could you please explain, how did you put the conditional formatting in all the cells together? ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal *Sent:* 21 August 2012 18:56 *To:* sperdwo...@gmail.com; excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ conditional formatting ** ** *Hi Smitha* ** ** *Pl try this...* * * *With regards, **Pravin Gunjal* ** ** -- Forwarded message -- From: *Smitha S R* sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros$$ conditional formatting To: excel-macros@googlegroups.com The colour should be filled in the whole row, not only in the cell. The way suggested fill the colour in the cell only. -- 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. -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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
Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 2).Resize(lr - 1)
Cells(2, i).Resize(lr).Copy Cells(dlr, 3)
Next i
'Rows(2).Resize(lr - 1).Delete
With ActiveSheet.UsedRange.Offset(lr)
.Copy Sheets(Re-mod).Range(a2)
.Clear
End With
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amol J
Sent: Tuesday, August 21, 2012 9:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2
dimensional grid to a single dimensional grid
Hello Experts,
I am sorry, but I am not getting right result for my query. May be I am not
able to explain what I am looking for
@ Don - I think there is some misunderstanding. PFA where I mentioned my
expected result.
I tried Using array - But unsuccessful.
My First array will be A1:A3 values{A,B,C}
second array B1:C1 Values(MH,GJ,KA)
My third array will be Number values
I want to print result in somewhere else,
as I already mentioned I tried myself but I think my knowledge and
understanding of VBA is not enough to solve this question.
Need your help.
Regards,
Amol j
On Monday, August 20, 2012 9:31:30 PM UTC+5:30, Don Guillett wrote:
Your first sample showed a blank col B. Try this
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 2).Resize(lr - 1)
Cells(2, i).Resize(lr).Copy Cells(dlr, 3)
Next i
Rows(2).Resize(lr - 1).Delete
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguil...@gmail.com
From: Amol J
Sent: Monday, August 20, 2012 10:20 AM
To: excel-...@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2
dimensional grid to a single dimensional grid
Hi Don,
Thanks for promt reply,
its not working for me. please check attachment. macro is working but result
is different than what I am looking for.
Please help me.
Thanks
Amol J
On Monday, August 20, 2012 7:13:48 PM UTC+5:30, Don Guillett wrote:
Sub rearranecolumnsSAS()
Dim lr As Long
Dim i As Long
Dim dlr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 3 To Cells(1, Columns.Count).End(xlToLeft).Column
dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1)
Cells(1, i).Copy Cells(dlr, 3).Resize(lr - 1)
Cells(2, i).Resize(lr).Copy Cells(dlr, 4)
Next i
Rows(2).Resize(lr - 1).Delete
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguil...@gmail.com
From: Amol J
Sent: Sunday, August 19, 2012 10:41 PM
To: excel-...@googlegroups.com
Subject: $$Excel-Macros$$ Need help on macro Re-organize data from a 2
dimensional grid to a single dimensional grid
Hi Experts
I need macro to do the following thing,
a. Re-organize data from a 2 dimensional grid to a single dimensional grid
- see example below
source data:
Item Sales MH, GJ, KA
A 1 23
B 4 56
C 7 89
reformat to the following
Item STATE Sales
A MH 1
B MH 4
C MH 7
A GJ 2
B GJ 5
C GJ 8
A KA 3
B KA 6
C KA 9
Please help me on this problem.
Thanks,
Amol J
--
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
$$Excel-Macros$$ Project Manager with Capacity Planning West Norristown PA
Send me your References @ s...@hmgamerica.com * Project Manager with Capacity Planning West Norristown PA 6 Months Plus* One of our Direct Client is looking for Project Manager with Capacity Planning experience The job description is as follows: It is desired that the capacity candidate know how to construct capacity models that reflect trend growth of current resources and project long term KPIs. The candidate must also know how to construct consolidation models taking many servers and consolidating them on to a fewer number of resources. These models will be constructed using BMC Best1 and Hyperformix. - System administration background - SQL server knowledge desired - Oracle understanding (Enterprise as well as RAC) - Business Objects user knowledge desired - Experience with BMC / patrol and Best1 (perform / Predict) - Knowledge of Hyperformix - Experience in large scale server consolidation projects - Able to utilize capacity planning tools to model changes in workloads, system configurations and model server - consolidations. - Understanding of EMC SAN environments. - Understanding of Virtual environments VMWARE as well as Power VM - Understanding of SAN and high performance EMC Arrays - Good oral and written communication skills Best Regards, Sam Martin E: sam.ultimateli...@gmail.com PH: 732-659-8219 -- 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$$ Project Manager with Capacity Planning West Norristown PA
Dear Mr. Rohit, Please don't Job posting It is against of Forum Rule. On Tue, Aug 21, 2012 at 9:06 PM, ROHIT KUMAR immy...@gmail.com wrote: Send me your Resumes @ s...@hmgamerica.com * Project Manager with Capacity Planning West Norristown PA 6 Months Plus* One of our Direct Client is looking for Project Manager with Capacity Planning experience The job description is as follows: It is desired that the capacity candidate know how to construct capacity models that reflect trend growth of current resources and project long term KPIs. The candidate must also know how to construct consolidation models taking many servers and consolidating them on to a fewer number of resources. These models will be constructed using BMC Best1 and Hyperformix. - System administration background - SQL server knowledge desired - Oracle understanding (Enterprise as well as RAC) - Business Objects user knowledge desired - Experience with BMC / patrol and Best1 (perform / Predict) - Knowledge of Hyperformix - Experience in large scale server consolidation projects - Able to utilize capacity planning tools to model changes in workloads, system configurations and model server - consolidations. - Understanding of EMC SAN environments. - Understanding of Virtual environments VMWARE as well as Power VM - Understanding of SAN and high performance EMC Arrays - Good oral and written communication skills Best Regards, Sam Martin E: sam.ultimateli...@gmail.com PH: 732-659-8219 -- -- 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$$ PowerPivot in excel 2007
Dear Amit, Please visit on below link, hope it will help to resolve your query. http://www.powerpivotpro.com/2010/12/powerpivot-for-excel-2007/ -- 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 Sun, Aug 19, 2012 at 9:12 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** Is it possible to add PowerPivot feature in Excel 2007? ** ** Best Regards, Amit ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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$$ Urgent Required Project manager Capacity Planning,Norristown PA
I thought this user was already banned. karan bhatia karan.bhatia07...@gmail.com wrote: *Please respond to ka...@hmgamerica.com * *Position: *Project manager Capacity Planning *Location:* Norristown PA *Duration:* 6 to 9 Months * Job Description* It is desired that the capacity candidate know how to constructcapacity models that reflect trend growth of current resources and project long term KPIs. The candidate must also know how to construct consolidation models taking many servers and consolidating them on to a fewer number of resources. These models will be constructed using BMC Best1 and Hyperformix. *Skills Required * * * · System administration background · SQL server knowledge desired · Oracle understanding (Enterprise as well as RAC) · Business Objects user knowledge desired · Experience with BMC / patrol and Best1 (perform / Predict) · Knowledge of Hyperformix · Experience in large scale server consolidation projects · Able to utilize capacity planning tools to model changes in · workloads, system configurations and model server - consolidations. · Understanding of EMC SAN environments. · Understanding of Virtual environments VMWARE as well as Power VM · Understanding of SAN and high performance EMC Arrays · Good oral and written communication skills -- Thanks Regards *Karan Bhatia HMG America LLC* PH: 732-645-2951 E:ka...@hmgamerica.com *http://www.hmgamerica.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$$ Java Developer
*Send me your resume@ sam.ultimateli...@gmail.com* * * *Position: *Java Developer** *Location:* Cleveland, Ohio *Duration:* : 6-12 months + * * *Skills Required* · Spring, · MVC · JQuery · Netbeans, · SVN, · Glassfish server (nice to have) -- 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$$ Sr Java Developer ,Cleveland, Ohio
Hi karan, Please follow forum rule #6 JOB posting are not allowed in this forum Sent from BlackBerry® on Airtel -Original Message- From: karan bhatia karan.bhatia07...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 01:37:50 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sr Java Developer ,Cleveland, Ohio *Please respond to ka...@hmgamerica.com * *Position: *Java Developer* * *Location:* Cleveland, Ohio *Duration:* : 6-12 months + * * *Skills Required * · Spring, · MVC · JQuery · Netbeans, · SVN, · Glassfish server (nice to have), -- Thanks Regards *Karan Bhatia HMG America LLC* PH: 732-645-2951 E:ka...@hmgamerica.com *http://www.hmgamerica.com/* -- You received this message because you are subscribed to the Google Groups USITJOBS group. To post to this group, send email to usitj...@googlegroups.com. To unsubscribe from this group, send email to usitjobs+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/usitjobs?hl=en. -- 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$$ Java Developer
Dear Ayush Please ban Sent from BlackBerry® on Airtel -Original Message- From: ROHIT KUMAR immy...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 01:49:48 To: ROHIT KUMARimmy...@gmail.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Java Developer *Send me your resume@ sam.ultimateli...@gmail.com* * * *Position: *Java Developer** *Location:* Cleveland, Ohio *Duration:* : 6-12 months + * * *Skills Required* · Spring, · MVC · JQuery · Netbeans, · SVN, · Glassfish server (nice to have) -- 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$$ Merging Two excel sheets on single sheet
it can be done with consolidation function venus On Aug 21, 2012 5:18 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ Merging Two excel sheets on single sheet
PFA Siraj From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Kumar Sharma Sent: Tuesday, August 21, 2012 6:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Noorain, Plz find the sample file. I need to combine data on last sheet. in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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 . -- With Regards, Noorain Ansari http:// http://www.noorainansari.com noorainansari.com http://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com excelvbaclinic.com http://www.excelvbaclinic.blogspot.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 mailto:excel-macros%2bunsubscr...@googlegroups.com . -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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
Re: $$Excel-Macros$$ Urgent Required Technical Project manager Norristown PA
Hi Karan, Please don't post any job mails. It's not job posting form, So concentrate on it. Regards, Kuldeep Singh On Tue, Aug 21, 2012 at 11:36 PM, karan bhatia karan.bhatia07...@gmail.comwrote: *Please respond to ka...@hmgamerica.com * *Position: *Project manager Capacity Planning *Location:* Norristown PA *Duration:* 6 to 9 Months * Job Description* It is desired that the capacity candidate know how to constructcapacity models that reflect trend growth of current resources and project long term KPIs. The candidate must also know how to construct consolidation models taking many servers and consolidating them on to a fewer number of resources. These models will be constructed using BMC Best1 and Hyperformix. *Skills Required * * * · System administration background · SQL server knowledge desired · Oracle understanding (Enterprise as well as RAC) · Business Objects user knowledge desired · Experience with BMC / patrol and Best1 (perform / Predict) · Knowledge of Hyperformix · Experience in large scale server consolidation projects · Able to utilize capacity planning tools to model changes in · workloads, system configurations and model server - consolidations. · Understanding of EMC SAN environments. · Understanding of Virtual environments VMWARE as well as Power VM · Understanding of SAN and high performance EMC Arrays · Good oral and written communication skills -- Thanks Regards *Karan Bhatia HMG America LLC* PH: 732-645-2951 E:ka...@hmgamerica.com *http://www.hmgamerica.com/* -- You received this message because you are subscribed to the Google Groups Remedy ARS group. To post to this group, send email to arsl...@googlegroups.com. To unsubscribe from this group, send email to arslist+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/arslist?hl=en. -- 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$$ Search Highlight name in list (1000 name list)
Dear Mr. Amar, Can you explain me in detail that will help me lot. I am not able understand the logic behind the attached excel THANKS REGARDS, CA KSAGAR On Tue, Aug 21, 2012 at 4:01 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi CA KSAGAR , GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET LOGIC.. Regards Amresh On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Ameresh, Kindly tell me how we can put scroll in excel like you have done in attached worksheet... Thanks Regards, CA KSAGAR On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.comwrote: Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya amreshkushw...@gmail.com wrote: Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.comwrote: Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name I search name then I scroll bar up down which cell highlight. I want to jump that cell directly with highlight.Is it possible? 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
Re: $$Excel-Macros$$ Error! Pasting more than 15 digits
Thanks Sara Kuldeep for the suggestion. I need to paste value in bulk Sara I fixed it from your method. Thanks Karan Singh On Tue, Aug 21, 2012 at 4:37 PM, Saravanan Anna sarvananar...@gmail.comwrote: Hi, Put one single quote and then paste the value. (it is applied only past value one by one only) If you want bulk paste: 1. make the format of the cell as 'text' 2. Past special - text. Regards Sara On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh karan1...@gmail.com wrote: Dear All, I need your assistance in pasting below values in excel. I tried to paste but couldn't get the right result. When I'm pasting this digits it's showing like this :http://but%20couldn%27t%20get%20the%20result%20what%20I%20wanted 3.51971052214647E+32 Pls suggest something. 351971052214647655134425186115948 351971052214647655134425217331549 351971052214647655134425251419451 Karan Singh -- 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.
