$$Excel-Macros$$ Problem.xlsx
Dear Experts, Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Op balance
Hi, Here with attached My data file i need help for Opening balance Closing balance copy to My Report Sheet, OPData sheet having Opening balance Closing balance , My report Report sheet having opeing balance and Closing balance which marked yelow colour Green colour, day wise it copy from Opdata sheet i need macro for this Chandru -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com MYdata.xlsm Description: Binary data
Re: $$Excel-Macros$$ Problem.xlsx
Dear Neeraj Try below one : =INDEX(D$2:D$13,MATCH(I2,C$2:C$13),MATCH(H2,B$2:B$13,0)) just change the date format by right click-format-date On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear Experts, ** ** Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Problem.xlsx
Dear Neeraj, Please use.. =LOOKUP(2,1/(($B$2:$B$13=H2)*($C$2:$C$13=I2)),$D$2:$D$13) See attached sheet. On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear Experts, ** ** Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Problem.xlsx
Dear Neeraj, You can also use.. =SUMPRODUCT(($B$2:$B$13=H2)*($C$2:$C$13=I2)*($D$2:$D$13)) On Fri, Feb 10, 2012 at 2:38 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Neeraj, Please use.. =LOOKUP(2,1/(($B$2:$B$13=H2)*($C$2:$C$13=I2)),$D$2:$D$13) See attached sheet. On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear Experts, ** ** Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Problem.xlsx
Press CSE =INDEX($D$2:$D$13,MATCH(1,($B$2:$B$13=H8)*($C$2:$C$13=I8),0)) On Fri, Feb 10, 2012 at 2:38 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Neeraj Try below one : =INDEX(D$2:D$13,MATCH(I2,C$2:C$13),MATCH(H2,B$2:B$13,0)) just change the date format by right click-format-date On Fri, Feb 10, 2012 at 2:09 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear Experts, ** ** Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Op balance
hi Noorain, can you help me on this Regards chandru On Fri, Feb 10, 2012 at 2:24 PM, chandra sekaran duraichan...@gmail.comwrote: Hi, Here with attached My data file i need help for Opening balance Closing balance copy to My Report Sheet, OPData sheet having Opening balance Closing balance , My report Report sheet having opeing balance and Closing balance which marked yelow colour Green colour, day wise it copy from Opdata sheet i need macro for this Chandru -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Highest no with colour
Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Highest no with colour
DO u need Highest one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Highest no with colour
Sorry . i need Column Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 . req data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 req Dat:- On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: DO u need Highest one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ formula for this
m waiting From: Lakshman Prasad lakshman...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: excelexpertsc...@yahoogroups.com excelexpertsc...@yahoogroups.com Sent: Friday, 10 February 2012 3:01 PM Subject: $$Excel-Macros$$ formula for this Dear Group member, Plz see the attached file, I have a workbook (sheet1) that have some raw date, I want to arrange as my requirement like sheet2. Is that any VBA code or formula for this. Regards LAKSHMAN-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Divide from lac =165221/10 (1.65221) From: Ashish Bhalara ashishbhalar...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 10 February 2012 5:34 PM Subject: $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Highest no with colour
U require by Row so go to Conditional formatting on Home tab with selecting one row then go to TOp/Bottom Rules and click on TOp 10 items ,give value of one and press ok On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote: Sorry . i need Column Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 . req data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 req Dat:- On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: DO u need Highest one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --
Re: $$Excel-Macros$$ Highest no with colour
Dear Veeru, Use it =A$2=MAX($A$2:$F$2) =A$3=MAX($A$3:$F$3) See attached sheet. On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote: Sorry . i need Column Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386. req data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 req Dat:- On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: DO u need Highest one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Highest no with colour
Dear Sir, I can't understand it,,, in my excel sheet i have 1200 columns data there,suggest any vba code for this highest no with colour On Fri, Feb 10, 2012 at 5:50 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Veeru, Use it =A$2=MAX($A$2:$F$2) =A$3=MAX($A$3:$F$3) See attached sheet. On Fri, Feb 10, 2012 at 5:07 PM, Veeru TOC veerub...@gmail.com wrote: Sorry . i need Column Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 . req data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 req Dat:- On Fri, Feb 10, 2012 at 5:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: DO u need Highest one among the column or row? and how 48 comes highest in E column ,kindly let us know On Fri, Feb 10, 2012 at 4:51 PM, Veeru TOC veerub...@gmail.com wrote: Dear Group How to find Highest no with colour How its possible ,any formula.. -- Normal data: A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 393 Req Data:- A B C D E F Total 10 18 25 26 *48* 70 197 25 48 96 48 91 78 386 *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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,
Re: $$Excel-Macros$$ split the value in two part
The splitting of data in to columns based on fixed lengths will not work if the name on the left has more characters than 30. So fixing the length will cause undesired result. You could use a few lines for the cleaning though Columns(b:c).Replace Chr(32), Columns(b:c).Replace Chr(160), Columns(b:c).Replace, Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 12:20 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Thank you for the quick reply. regards Sanjib On Fri, Feb 10, 2012 at 12:23 AM, dguillett1 dguille...@gmail.com wrote: Or, even simpler without loop by changing mine to Sub TTC_SAS_Improved() Columns(A).TextToColumns Destination:=Range(B1), _ DataType:=xlFixedWidth, FieldInfo:= _ Array(Array(0, 1), Array(30, 1)) Columns(b:c).AutoFit Columns(b:c).Replace Chr(32), Columns(c).HorizontalAlignment = xlRight End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* Sam Mathai Chacko samde...@gmail.com *Sent:* Thursday, February 09, 2012 11:09 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ split the value in two part The macro splits it in to three columns a probable solution would be Sub Spliter() Dim rng As Range Columns(A).TextToColumns Destination:=Range(B1), _ DataType:=2, OtherChar:= , _ FieldInfo:=Array(Array(0, 2), Array(31, 1)), _ TrailingMinusNumbers:=True With Range(B1:C Cells(Rows.Count, 1).End(xlUp).Row) For Each rng In .Cells rng.Value = Evaluate(=TRIM(SUBSTITUTE( rng.Address(0, 0) ,CHAR(160), ))) Next rng End With End Sub Regards, Sam Mathai Chacko On Thu, Feb 9, 2012 at 10:25 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Good Solution SAM Thanks.. On Thu, Feb 9, 2012 at 10:10 PM, Sam Mathai Chacko samde...@gmail.comwrote: Noorain, if you are using AB as your search criteria to split the cells, why do you need such a long formula Use Name =TRIM(SUBSTITUTE(SUBSTITUTE(A2,MID(A2,FIND(AB,A2),9),),CHAR(160),)) Reg.No =SUBSTITUTE(MID(A2,FIND(AB,A2),9),CHAR(160),) Regards, Sam Mathai Chacko On Thu, Feb 9, 2012 at 8:43 PM, dguillett1 dguille...@gmail.comwrote: Try this Sub TTC_SAS() Columns(A).TextToColumns Destination:=Range(B1), _ DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), _ Array(5, 1), Array(30, 1)) Columns(C:D).AutoFit Columns(D).HorizontalAlignment = xlRight End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* Shaik Waheed waheedb...@gmail.com *Sent:* Thursday, February 09, 2012 1:44 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ split the value in two part Hi Sanjib, In your sample data u can do this by clicking to 'Data' tab in ur excel sheet---Text To Colums--- Fixed width--Next--- Set the scale line as per ur requirement--- finish Do the necessary formatting as per ur requirement. Find the attached sheet for ur review. On Thu, Feb 9, 2012 at 12:49 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Sir / Madam, Please see the attached excel sheet. I like to split the name in one cell (i.e. in B) and registration in another cell (i.e in C) Please help me. Thank you in Advance Regards, Sanjib -- - -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Divide from lac =165221/10 (1.65221)** *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 10 February 2012 5:34 PM *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Op balance
With a formula. In the report sheet use match to find the date and then index ‘=INDEX(OPData!$A$1:$AH$8,8,MATCH(G$1,OPData!$3:$3)+2) This finds the closing debit grand total for 5 april Don Guillett SalesAid Software dguille...@gmail.com From: chandra sekaran Sent: Friday, February 10, 2012 2:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Op balance Hi, Here with attached My data file i need help for Opening balance Closing balance copy to My Report Sheet, OPData sheet having Opening balance Closing balance , My report Report sheet having opeing balance and Closing balance which marked yelow colour Green colour, day wise it copy from Opdata sheet i need macro for this Chandru -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Synchronization on same set of data on 2 charts
I don’t have 2000 but would think you would have to develop in 2000 and hope the later versions can use it. OR, UPGRADE. Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Friday, February 10, 2012 3:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Synchronization on same set of data on 2 charts Dear Noorain, I did it but results are shown like this. Are there other ways for Excel 2000 version? Because I use Excel 2000 at my office while Excel 2007 and 2010 at home. 2012/2/10 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Please see attached ScreenShot, Hope it will help to you. On Fri, Feb 10, 2012 at 2:27 PM, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear group, Synchronization on same set of data on 2 charts 1. In my file, 2 charts connecting same set of data show different x-axis. Can anyone point out what is my fault in the file? 2. Also, can anyone can provide a better solution for attaching some kind of control like a scroll bar so that it would look like a dynamic dashboard. Please see the attachment for details with appreciation, thanks a lot! -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code
Excel version_ How is color applied, manually___ or CF Don Guillett SalesAid Software dguille...@gmail.com From: Veeru TOC Sent: Friday, February 10, 2012 6:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Highest No with Colour, Need Vba Code -- Dear Team In my excel sheet i have below type of data i need Highest no with Colour , pls send VBA Code Normal data: A B C D E F Total 10 18 25 26 48 70 197 25 48 96 48 91 78 386 . req data:- A B C D E F Total 10 18 25 26 48 70 197 25 48 96 48 91 78 386 ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Insert a row and subtotal
Hello, does anyone know how to add subtotals once my code has run a sum for both the Par Value and a sumproduct for the coupon rate? I have a code that gathers the data i need but i can't figure out this last part. https://www.box.net/shared/0fknh9819pk9t8m7jxz9 Here is the file i'm trying to work with. Thanks in advance, Matt -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Synchronization on same set of data on 2 charts
@Noorain, Let me study the chart first. Thanks a lot! @Don, The fact is the excel version at my workplace is 2000, i have no choice. Thanks anyway~ 2012/2/10 dguillett1 dguille...@gmail.com I don’t have 2000 but would think you would have to develop in 2000 and hope the later versions can use it. OR, UPGRADE. Don Guillett SalesAid Software dguille...@gmail.com *From:* Darwin Chan darwin.chankaw...@gmail.com *Sent:* Friday, February 10, 2012 3:33 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Synchronization on same set of data on 2 charts Dear Noorain, I did it but results are shown like this. Are there other ways for Excel 2000 version? Because I use Excel 2000 at my office while Excel 2007 and 2010 at home. 2012/2/10 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Please see attached ScreenShot, Hope it will help to you. On Fri, Feb 10, 2012 at 2:27 PM, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear group, *Synchronization on same set of data on 2 charts* 1. In my file, 2 charts connecting same set of data show different x-axis. Can anyone point out what is my fault in the file? 2. Also, can anyone can provide a better solution for attaching some kind of control like a scroll bar so that it would look like a dynamic dashboard. Please see the attachment for details with appreciation, thanks a lot! -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members
Re: $$Excel-Macros$$ formula for this
Or, ‘== Option Explicit Sub findtotalsSAS() Dim c As Range Dim firstaddress As String With Sheets(sheet1).Range(f1:f150) Set c = .Find(LedgerTotal, LookIn:=xlValues) If Not c Is Nothing Then firstaddress = c.Address Do ‘MsgBox c.Offset(, 6) Sheets(sheet2).Cells(Rows.Count, b).End(xlUp)(2).Value = _ c.Offset(, 6).Value Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address firstaddress End If End With End Sub ‘== Don Guillett SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Friday, February 10, 2012 6:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ formula for this Try the attached On 10 February 2012 21:50, Lakshman Prasad lakshman...@yahoo.com wrote: m waiting From: Lakshman Prasad lakshman...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: excelexpertsc...@yahoogroups.com excelexpertsc...@yahoogroups.com Sent: Friday, 10 February 2012 3:01 PM Subject: $$Excel-Macros$$ formula for this Dear Group member, Plz see the attached file, I have a workbook (sheet1) that have some raw date, I want to arrange as my requirement like sheet2. Is that any VBA code or formula for this. Regards LAKSHMAN -- -- David Grugeon -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Insert a row and subtotal
Thanks Don, I did try that before but is it possible to get a sumproduct formula under the market value? Matt On Feb 10, 10:09 am, dguillett1 dguille...@gmail.com wrote: Why not let excel do the heavy lifting using subtotals. See attached in SalesAidSoftware module Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Monizri Sent: Friday, February 10, 2012 8:15 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Insert a row and subtotal Hello, does anyone know how to add subtotals once my code has run a sum for both the Par Value and a sumproduct for the coupon rate? I have a code that gathers the data i need but i can't figure out this last part. https://www.box.net/shared/0fknh9819pk9t8m7jxz9 Here is the file i'm trying to work with. Thanks in advance, Matt -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com 20121.xlsm 54KViewDownload -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Insert a row and subtotal
See changes where sumproduct formula is evaluated I am available for excel projects . Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Monizri Sent: Friday, February 10, 2012 9:21 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Insert a row and subtotal Thanks Don, I did try that before but is it possible to get a sumproduct formula under the market value? Matt On Feb 10, 10:09 am, dguillett1 dguille...@gmail.com wrote: Why not let excel do the heavy lifting using subtotals. See attached in SalesAidSoftware module Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Monizri Sent: Friday, February 10, 2012 8:15 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Insert a row and subtotal Hello, does anyone know how to add subtotals once my code has run a sum for both the Par Value and a sumproduct for the coupon rate? I have a code that gathers the data i need but i can't figure out this last part. https://www.box.net/shared/0fknh9819pk9t8m7jxz9 Here is the file i'm trying to work with. Thanks in advance, Matt -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com 20121.xlsm 54KViewDownload -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 20121.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Series and Justify in Excel 2010
Hi Group, Could anyone please share some tutorials for the Seriesand Justify features in the Fill dropdown of Excel 2010. Thanks in advance. Rohan. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Replacement for Application.CalculateFull
Hi, Can you please give any code or anything which will replace Application.CalculateFull. when i use above code this calculates all the Open workbooks whereas i want to calculate only the Activeworkbook. i have tried below code but its not reliable as it does not calculate EVERYTIME. Public Sub CalcActiveWBOnly() Dim wrksht As Worksheet Application.Calculation = xlManual For Each wrksht In ThisWorkbook.Sheets wrksht.Calculate Debug.Print wrksht.Name Next wrksht End Sub There is UDF lets say test which should get calculated after above code is executed but it doesnt happen everytime though the above code gets executed everytime. its very very urgent and very very IMP for me. please help me. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Difference between VBA and VSTO
Hi, Can somebody please tell me what is the difference between VSTO and VBA. I have heard VBA has left short life after Office 2010 is released. Can somebody please explain how much is the truth or what are the chances and etc, etc -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Replacement for Application.CalculateFull
try Application.Calculation = xlManual sheets.select for i=1 to sheets.count activesheet.calculate next i Don Guillett SalesAid Software dguille...@gmail.com From: hanumant shinde Sent: Friday, February 10, 2012 11:08 AM To: Excel Group Subject: $$Excel-Macros$$ Replacement for Application.CalculateFull Hi, Can you please give any code or anything which will replace Application.CalculateFull. when i use above code this calculates all the Open workbooks whereas i want to calculate only the Activeworkbook. i have tried below code but its not reliable as it does not calculate EVERYTIME. Public Sub CalcActiveWBOnly() Dim wrksht As Worksheet Application.Calculation = xlManual For Each wrksht In ThisWorkbook.Sheets wrksht.Calculate Debug.Print wrksht.Name Next wrksht End Sub There is UDF lets say test which should get calculated after above code is executed but it doesnt happen everytime though the above code gets executed everytime. its very very urgent and very very IMP for me. please help me. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ explosion maco needed pls
Hi Don, Yes, my english is not up to speed so I'll clarify. In delisted tab I'd like to input manualy code b5:b16 - correct then I'd like to hits for each of them - correct C5:C16 and D5:D16 not inportant - correct Thank you the greatest Don :) Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 6:53 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Let’s get a bit of clarification.. You want to list in delisted!b516 the codes. 3 shown now. Then you want all hits for each of the 3 codes. Do you want to further restrict by reference in c5:c16 or is that meaningless like the dates in d516 Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com wlEmoticon-nyahnyahwlEmoticon-openmouthedsmile
Re: $$Excel-Macros$$ explosion maco needed pls
yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ explosion maco needed pls
you are the greatest from the greatest :) thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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$$ explosion maco needed pls
Aw shucks. Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls you are the greatest from the greatest :) thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
$$Excel-Macros$$ Synchronizing two Pivot tables.
I have two pivot tables with the same underlying data set but show different views to the user. I need help synchronizing the 2 Pivot tables with one report filter. Thanks in advance for your Help ! -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet
Hello Sir, Is it possible while we entering the date in the sheet system alert us that the name or number or text already in the sheet but not limit the entry of the data, if yes let me know how can we do it and is it possible to imply the rule in few rows not in all the rows. thanks regards rajesh -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it
it is very useful thank you Thanks Best regards Abdel Rahman Gomaa Night Auditor B G Hotels And Resorts Calimera Habiba Beach Marsa Alam Email: income.habibama...@balbaagroup.com Web Site : www.balbaagroup.com Tel : 010-09799117 Tel : 065-3380105 - 110 Fax : 065-3380124 On 10 February 2012 08:35, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear Noorain, Thanks for your support!! 2012/2/7 NOORAIN ANSARI noorain.ans...@gmail.com Add-In Excel 2003 Version On Thu, Feb 2, 2012 at 5:24 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Darwin/ Bé Trần Văn, Recently it will available in Excel Version 2003. On Thu, Feb 2, 2012 at 5:18 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/2/2 Excel_Lover idforex...@gmail.com great, Thanks for sharing.. On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan darwin.chankaw...@gmail.com wrote: Noorain, Is there any version for Excel 97 - 2003? Thanks~ 2012/2/1 NOORAIN ANSARI noorain.ans...@gmail.com In Excel 2007 Version On Wed, Feb 1, 2012 at 2:21 PM, Abdulgani Shaikh itpabdulg...@gmail.com wrote: in which Excel version it will work ? On Wed, Feb 1, 2012 at 1:55 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Abdul, PFA -- Forwarded message -- From: ITP Abdulgani Shaikh itpabdulg...@gmail.com Date: Wed, Feb 1, 2012 at 11:28 AM Subject: Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it To: excel-macros@googlegroups.com I am unable to download the Add in, can you please email it to me. Regards On Mon, Jan 30, 2012 at 9:09 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Group, Find attached the Excel add-ins, which simply fantastic in our routine work. Just open the attachment in excel file and you can see there is an additional menu appears to your excel tab “My Menu” develop by one of our Group member Mr. Ashish Koul You can see almost all the functions we use are available in the menu http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html -- -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ 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
RE: $$Excel-Macros$$ Problem.xlsx
Please find the attached solved sheet Thanks, Nayeem From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Friday, February 10, 2012 1:39 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Problem.xlsx Dear Experts, Kindly see the attached sheet. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Problem.xlsx Description: Problem.xlsx
$$Excel-Macros$$ Load Excel Files
Team, I have master file having 10 sheets. 1st sheet having summarize data (populated using formulas) of other 9 sheets and these 9 sheets contains data from 6 different files (3 files having two tabs each) and this is daily process. Need VBA code through which I can load those files with single click so that I can get rid of copy and paste every time. I can have master file and other 9 files in same folder. Note: need to have entire sheet copy and paste in respective sheet in master file. Thanks! -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Add in for compare work sheets
Dear Excel Expert, I am a ardent follower of this group and I have seen that some one has posted in this forum a Add in to compare two worksheet. May I request the expert to repost the add in again. Thanking You, Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ formula for this
Thanx David From: David Grugeon grug...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 10 February 2012 6:28 PM Subject: Re: $$Excel-Macros$$ formula for this Try the attached On 10 February 2012 21:50, Lakshman Prasad lakshman...@yahoo.com wrote: m waiting From: Lakshman Prasad lakshman...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: excelexpertsc...@yahoogroups.com excelexpertsc...@yahoogroups.com Sent: Friday, 10 February 2012 3:01 PM Subject: $$Excel-Macros$$ formula for this Dear Group member, Plz see the attached file, I have a workbook (sheet1) that have some raw date, I want to arrange as my requirement like sheet2. Is that any VBA code or formula for this. Regards LAKSHMAN-- -- David Grugeon -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Load Excel Files
Hi ,, Please share your workbook.Thanks On Sat, Feb 11, 2012 at 2:15 AM, Mayank mayanksupadh...@gmail.com wrote: Team, I have master file having 10 sheets. 1st sheet having summarize data (populated using formulas) of other 9 sheets and these 9 sheets contains data from 6 different files (3 files having two tabs each) and this is daily process. Need VBA code through which I can load those files with single click so that I can get rid of copy and paste every time. I can have master file and other 9 files in same folder. Note: need to have entire sheet copy and paste in respective sheet in master file. Thanks! -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Thanks in advance
Hi Question asked in interview i have nearly 30 pivot tablein 30 sheets i need to enter data in master sheetat a time i need to refresh alll the pivot table... how to link the pivot table... Please help me.i dont have any workbook.. question asked in intervthanks in advance -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Load Excel Files
Hello Mayank, You can save an Excel Workspace that will load all your related spreadsheets together. Ø To create a Workspace: 1. Open all your spreadsheets 2. Arrange the windows as you like (the arrangement will be saved, too) 3. Save the Workspace: a. in Excel 2007/2010, Go to RIBBONVIEWWindowSave Workspace b. in Excel 2003 and prior, go to FILESave Workspace Ø To open your files together in the future, go to FILEOpen and select your Workspace file. For a little more info, see: · http://office.microsoft.com/en-us/excel-help/save-workbooks-in-an-arranged-w orkspace-HP010250051.aspx · http://office.microsoft.com/en-us/excel-help/save-workbooks-in-an-arranged-w orkspace-HP005202374.aspx?CTT=1 ·http://www.fmsinc.com/free/NewTips/Office/excel.asp ·http://www.ozgrid.com/Excel/save-as-workspace.htm Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mayank Sent: Friday, February 10, 2012 12:46 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Load Excel Files Team, I have master file having 10 sheets. 1st sheet having summarize data (populated using formulas) of other 9 sheets and these 9 sheets contains data from 6 different files (3 files having two tabs each) and this is daily process. Need VBA code through which I can load those files with single click so that I can get rid of copy and paste every time. I can have master file and other 9 files in same folder. Note: need to have entire sheet copy and paste in respective sheet in master file. Thanks! -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Thanks in advance
*If source data is same for all pivots, refresh anyone of the pivot. other pivots too get refreshed.* On Sat, Feb 11, 2012 at 9:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hi Question asked in interview i have nearly 30 pivot tablein 30 sheets i need to enter data in master sheetat a time i need to refresh alll the pivot table... how to link the pivot table... Please help me.i dont have any workbook.. question asked in intervthanks in advance -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ explosion maco needed pls
thanks Mate From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 8:07 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Aw shucks. Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls you are the greatest from the greatest :) thanks Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again the greatest Don Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, b).End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range(a1:e lr) .AutoFilter Field:=1, Criteria1:=Cells(i, b) .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in delisted tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the outcome tab I'l like to have explosion mentioned above product (as you can see in outcome tab) one by one. It won't be a problem to do it on excel function but bom explosion report has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel-- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not
Re: $$Excel-Macros$$ Thanks in advance
HI Maries They told me to write a program.. to refresh all the pivot tables at a time. i need a code to refresh all the pivottables. Thanks On Sat, Feb 11, 2012 at 11:59 AM, Maries talk2mar...@gmail.com wrote: *If source data is same for all pivots, refresh anyone of the pivot. other pivots too get refreshed.* On Sat, Feb 11, 2012 at 9:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hi Question asked in interview i have nearly 30 pivot tablein 30 sheets i need to enter data in master sheetat a time i need to refresh alll the pivot table... how to link the pivot table... Please help me.i dont have any workbook.. question asked in intervthanks in advance -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com