Re: $$Excel-Macros$$ Urgent help needed please
Try Sumif Kantilal Badale On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65 -0.66 -0.80 -11.26 I don't seem to get it, I am sorry if it sounds very trivial, but any help will be appreciated, Thanks alot -- 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 Sumif.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent help needed please
Hi, Try below formula with Ctrl+Shift+Enter. =SUM(IF(A1:A160,A1:A16,0)) Find the attached file. Regards, MARIES. On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: = -- 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 SUM.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent help needed please
Hi Arpita, You can also use.. SUMPRODUCT((A1:A160)*(A1:A16)) On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65 -0.66 -0.80 -11.26 I don't seem to get it, I am sorry if it sounds very trivial, but any help will be appreciated, Thanks alot -- 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$$ Urgent help needed on Slow Excel Performance
Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry® from Vodafone Thanks Regards. Kiran -Original Message- From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Wed, 14 Dec 2011 00:25:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance The link did not help Dear Masters, please help me to improve performance of this sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 13 December 2011 22:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance http://tinyurl.com/7yt37xy https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US http://tinyurl.com/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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.commailto:excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply
RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Correct...it will work. The issue is, from this sheet I have linked 5 other sheet a file. So if I changed delete the sheet copy paste them to other sheet, I will lose all the formula. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: 14 December 2011 13:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry(r) from Vodafone Thanks Regards. Kiran From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Wed, 14 Dec 2011 00:25:49 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance The link did not help Dear Masters, please help me to improve performance of this sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 13 December 2011 22:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance http://tinyurl.com/7yt37xy https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US http://tinyurl.com/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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.commailto:excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 Disclaimer: This message and its attachments contain confidential information and may also contain
Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Hi Amit, This situation, I have to give suggestion. you have to write VBA script for below mention point. 1) In Sheet 1, wherever formulas are there you have to write macro 2) create new sheet, Copy data from sheet 1 and paste it to new sheet. I hope your formulas in sheet 1 still there, and all sheet are interlinked. Regards, Sunil On 12/14/11, Amit Desai (MERU) amit.de...@merucabs.com wrote: Correct...it will work. The issue is, from this sheet I have linked 5 other sheet a file. So if I changed delete the sheet copy paste them to other sheet, I will lose all the formula. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: 14 December 2011 13:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry(r) from Vodafone Thanks Regards. Kiran From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Wed, 14 Dec 2011 00:25:49 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance The link did not help Dear Masters, please help me to improve performance of this sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 13 December 2011 22:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance http://tinyurl.com/7yt37xy https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US http://tinyurl.com/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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.commailto:excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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
RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Can you please provide code for that? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sunil jagtap Sent: 14 December 2011 18:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, This situation, I have to give suggestion. you have to write VBA script for below mention point. 1) In Sheet 1, wherever formulas are there you have to write macro 2) create new sheet, Copy data from sheet 1 and paste it to new sheet. I hope your formulas in sheet 1 still there, and all sheet are interlinked. Regards, Sunil On 12/14/11, Amit Desai (MERU) amit.de...@merucabs.com wrote: Correct...it will work. The issue is, from this sheet I have linked 5 other sheet a file. So if I changed delete the sheet copy paste them to other sheet, I will lose all the formula. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: 14 December 2011 13:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry(r) from Vodafone Thanks Regards. Kiran From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Wed, 14 Dec 2011 00:25:49 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance The link did not help Dear Masters, please help me to improve performance of this sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 13 December 2011 22:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance http://tinyurl.com/7yt37xy https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793 906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fms dn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc =1033id=254354mkt=en-US http://tinyurl.com/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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.commailto:excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
http://tinyurl.com/7yt37xy https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US http://tinyurl.com/8749ypq === Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, December 13, 2011 9:51 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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$$ Urgent help needed on Slow Excel Performance
dear all, how can i learn macro. please suggest me. Thanks Regards Jitendra Singh On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 dguille...@gmail.com wrote: *http://tinyurl.com/7yt37xy* https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US ** *http://tinyurl.com/8749ypq* === Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Tuesday, December 13, 2011 9:51 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, *Amit Desai* -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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$$ Urgent help needed on Slow Excel Performance
Dear Jitender, I would suggest you to go ahead and record macro and then watch and relate these codes by your steps, which you had taken and start understanding VBA. You can also refer to the Group's learning material and find below excel macro ebook.. http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Dec 13, 2011 at 10:34 PM, Jitendra singh jeete2...@gmail.comwrote: dear all, how can i learn macro. please suggest me. Thanks Regards Jitendra Singh On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 dguille...@gmail.com wrote: *http://tinyurl.com/7yt37xy* https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US ** *http://tinyurl.com/8749ypq* === Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Tuesday, December 13, 2011 9:51 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file! Regards, *Amit Desai* -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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
Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Dear Noorain, Thanks. Regards Jitendra Singh On Tue, Dec 13, 2011 at 11:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jitender, I would suggest you to go ahead and record macro and then watch and relate these codes by your steps, which you had taken and start understanding VBA. You can also refer to the Group's learning material and find below excel macro ebook.. http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Dec 13, 2011 at 10:34 PM, Jitendra singh jeete2...@gmail.comwrote: dear all, how can i learn macro. please suggest me. Thanks Regards Jitendra Singh On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 dguille...@gmail.comwrote: *http://tinyurl.com/7yt37xy* https://login.live.com/login.srf?wa=wsignin1.0rpsnv=11checkda=1ct=1323793906rver=6.0.5276.0wp=MCLBIwlcxt=msdn%24msdn%24msdnwreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspxlc=1033id=254354mkt=en-US ** *http://tinyurl.com/8749ypq* === Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Tuesday, December 13, 2011 9:51 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance Dear Friends, I have attached one excel sheet. If you make any changes it is taking very long time. Could you please check suggest how to speed up its performance. It should not take more than few seconds to do any editing in this file!*** * Regards, *Amit Desai* -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question 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$$ Urgent help needed
Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdating = False Sheets.Add before:=Sheets(1) With ActiveSheet .Name = Master Sheet For i = 2 To Sheets.Count dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets(i).UsedRange.Copy .Cells(dlr, 1) .Cells(dlr, h) = Sheets(i).Name .Cells(dlr, H).Interior.Color = vbCyan Next i .Columns.AutoFit .Rows(1).Delete End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Thursday, October 27, 2011 5:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index = wrk.Worksheets.Count Then Exit For End If 'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value Next sht 'Fit the columns in Master worksheet trg.Columns.AutoFit 'Screen updating should be activated Application.ScreenUpdating = True End Sub Anil Bhange Assistant Manager Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai – 400 001, India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent help needed
I agree with Don. The first thing I do is delete all requests that do not describe the problem in the subject line. Posting Tips: Subjects like Urgent Help Needed convey no valueable information. the problem isn't urgent for ME, and if the poster didn't need help, he/she wouldn't be posting. Next, I consider myself an expert in many facets of Excel and VBA, but I have very little experience in Pivot Tables. Therefore, I skip questions outside of my areas of expertise and let someone who knows what they're talking about answer those questions. So, Subjects that sound interesting, challenging, or within my areas of expertise, I'll open and look at. If the author didn't feel like wasting his time writing a descriptive subject line, I don't feel obligated to waste my time trying to figure out what he needs help with. I receive HUNDREDS of emails every day... I get to choose which ones to open... just my opinion... Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, October 27, 2011 9:56:09 AM Subject: Re: $$Excel-Macros$$ Urgent help needed Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdating = False Sheets.Add before:=Sheets(1) With ActiveSheet .Name = Master Sheet For i = 2 To Sheets.Count dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets(i).UsedRange.Copy .Cells(dlr, 1) .Cells(dlr, h) = Sheets(i).Name .Cells(dlr, H).Interior.Color = vbCyan Next i .Columns.AutoFit .Rows(1).Delete End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Thursday, October 27, 2011 5:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index = wrk.Worksheets.Count Then Exit For End If 'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value Next sht 'Fit the columns in Master worksheet trg.Columns.AutoFit 'Screen updating should be activated Application.ScreenUpdating = True End Sub Anil Bhange Assistant Manager Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai – 400 001, India 'Desk : + 91 22 6659 2320 | IP Phone : 51 2320 |Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com
Re: $$Excel-Macros$$ Urgent help needed
Seconding Don and Paul on that. Another point that comes to the table is the lack of proper Subject Titles that clearly and concisely describes the problem/objective. I know that this is hinted in the forum rules, but do we not need to moderate this? Regards, Sam On Thu, Oct 27, 2011 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote: I agree with Don. The first thing I do is delete all requests that do not describe the problem in the subject line. Posting Tips: Subjects like Urgent Help Needed convey no valueable information. the problem isn't urgent for ME, and if the poster didn't need help, he/she wouldn't be posting. Next, I consider myself an expert in many facets of Excel and VBA, but I have very little experience in Pivot Tables. Therefore, I skip questions outside of my areas of expertise and let someone who knows what they're talking about answer those questions. So, Subjects that sound interesting, challenging, or within my areas of expertise, I'll open and look at. If the author didn't feel like wasting his time writing a descriptive subject line, I don't feel obligated to waste my time trying to figure out what he needs help with. I receive HUNDREDS of emails every day... I get to choose which ones to open... just my opinion... *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, October 27, 2011 9:56:09 AM *Subject:* Re: $$Excel-Macros$$ Urgent help needed Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdating = False Sheets.Add before:=Sheets(1) With ActiveSheet .Name = Master Sheet For i = 2 To Sheets.Count dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets(i).UsedRange.Copy .Cells(dlr, 1) .Cells(dlr, h) = Sheets(i).Name .Cells(dlr, H).Interior.Color = vbCyan Next i .Columns.AutoFit .Rows(1).Delete End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* Anil Bhange anil.bha...@tatacommunications.com *Sent:* Thursday, October 27, 2011 5:24 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help needed Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index = wrk.Worksheets.Count Then Exit For End If 'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp
RE: $$Excel-Macros$$ Urgent help needed
Hi Noorain, Thanks for the help, but it is not working at my end due to different sheet name (I believe), can we make it flexible (as it need to run in any worksheet). Also i need my output as like below.. I am ok to repeat the heading of data And one more thing can macro ask me the range which need to select (single time) and sheets to be consolidate (as selection only once) Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursday, October 27, 2011 05:37 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed Dear Anil, Please try through below code and see attached sheet. Sub Consodilated_sheet_withsheetname() Dim i, j, k, s As Long Dim x, y, z As Long Application.ScreenUpdating = False x = Sheet1.Cells(1, Columns.Count).End(xlToLeft).Column s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Master Sheet For i = 1 To s Sheets(i).Select j = 2 k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(A65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste ActiveCell.Offset(0, x) = Sheets(i).Name ActiveCell.Offset(0, x).EntireRow.Interior.Color = vbCyan Next i Application.ScreenUpdating = True End Sub On Thu, Oct 27, 2011 at 3:54 PM, Anil Bhange anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com wrote: Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index = wrk.Worksheets.Count Then Exit For End If 'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value Next sht 'Fit the columns in Master worksheet trg.Columns.AutoFit 'Screen updating should be activated Application.ScreenUpdating = True End Sub Anil Bhange Assistant Manager Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai - 400 001, India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari http
RE: $$Excel-Macros$$ Urgent help needed... (apologies)
Thanks guys... For suggesting the same... will take care next time Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, October 27, 2011 08:45 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed Seconding Don and Paul on that. Another point that comes to the table is the lack of proper Subject Titles that clearly and concisely describes the problem/objective. I know that this is hinted in the forum rules, but do we not need to moderate this? Regards, Sam On Thu, Oct 27, 2011 at 7:39 PM, Paul Schreiner schreiner_p...@att.netmailto:schreiner_p...@att.net wrote: I agree with Don. The first thing I do is delete all requests that do not describe the problem in the subject line. Posting Tips: Subjects like Urgent Help Needed convey no valueable information. the problem isn't urgent for ME, and if the poster didn't need help, he/she wouldn't be posting. Next, I consider myself an expert in many facets of Excel and VBA, but I have very little experience in Pivot Tables. Therefore, I skip questions outside of my areas of expertise and let someone who knows what they're talking about answer those questions. So, Subjects that sound interesting, challenging, or within my areas of expertise, I'll open and look at. If the author didn't feel like wasting his time writing a descriptive subject line, I don't feel obligated to waste my time trying to figure out what he needs help with. I receive HUNDREDS of emails every day... I get to choose which ones to open... just my opinion... Paul - Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can. - John Wesley - From: dguillett1 dguille...@gmail.commailto:dguille...@gmail.com To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Sent: Thu, October 27, 2011 9:56:09 AM Subject: Re: $$Excel-Macros$$ Urgent help needed Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdating = False Sheets.Add before:=Sheets(1) With ActiveSheet .Name = Master Sheet For i = 2 To Sheets.Count dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets(i).UsedRange.Copy .Cells(dlr, 1) .Cells(dlr, h) = Sheets(i).Name .Cells(dlr, H).Interior.Color = vbCyan Next i .Columns.AutoFit .Rows(1).Delete End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.commailto:dguille...@gmail.com From: Anil Bhangemailto:anil.bha...@tatacommunications.com Sent: Thursday, October 27, 2011 5:24 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help needed Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index
Re: $$Excel-Macros$$ Urgent help needed
Thanks Sam , Paul and Don, I totally agree with you guys but it is not possible to moderate each message. As an immediate action, I have modified the message footer to add forum rules. Now every message will carry below text at bottom. I hope this helps. Let me know if it is helpful or any other action required. Thanks again, Ayush Jain - FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 On Thu, Oct 27, 2011 at 8:44 PM, Sam Mathai Chacko samde...@gmail.comwrote: Seconding Don and Paul on that. Another point that comes to the table is the lack of proper Subject Titles that clearly and concisely describes the problem/objective. I know that this is hinted in the forum rules, but do we not need to moderate this? Regards, Sam On Thu, Oct 27, 2011 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote: I agree with Don. The first thing I do is delete all requests that do not describe the problem in the subject line. Posting Tips: Subjects like Urgent Help Needed convey no valueable information. the problem isn't urgent for ME, and if the poster didn't need help, he/she wouldn't be posting. Next, I consider myself an expert in many facets of Excel and VBA, but I have very little experience in Pivot Tables. Therefore, I skip questions outside of my areas of expertise and let someone who knows what they're talking about answer those questions. So, Subjects that sound interesting, challenging, or within my areas of expertise, I'll open and look at. If the author didn't feel like wasting his time writing a descriptive subject line, I don't feel obligated to waste my time trying to figure out what he needs help with. I receive HUNDREDS of emails every day... I get to choose which ones to open... just my opinion... *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, October 27, 2011 9:56:09 AM *Subject:* Re: $$Excel-Macros$$ Urgent help needed Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdating = False Sheets.Add before:=Sheets(1) With ActiveSheet .Name = Master Sheet For i = 2 To Sheets.Count dlr = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets(i).UsedRange.Copy .Cells(dlr, 1) .Cells(dlr, h) = Sheets(i).Name .Cells(dlr, H).Interior.Color = vbCyan Next i .Columns.AutoFit .Rows(1).Delete End With Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* Anil Bhange anil.bha...@tatacommunications.com *Sent:* Thursday, October 27, 2011 5:24 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Urgent help needed Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets
Re: $$Excel-Macros$$ Urgent help needed
Did you try my solution?? Don Guillett SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Thursday, October 27, 2011 11:49 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed Hi Noorain, Thanks for the help, but it is not working at my end due to different sheet name (I believe), can we make it flexible (as it need to run in any worksheet). Also i need my output as like below.. I am ok to repeat the heading of data And one more thing can macro ask me the range which need to select (single time) and sheets to be consolidate (as selection only once) Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursday, October 27, 2011 05:37 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed Dear Anil, Please try through below code and see attached sheet. Sub Consodilated_sheet_withsheetname() Dim i, j, k, s As Long Dim x, y, z As Long Application.ScreenUpdating = False x = Sheet1.Cells(1, Columns.Count).End(xlToLeft).Column s = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Master Sheet For i = 1 To s Sheets(i).Select j = 2 k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(A65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste ActiveCell.Offset(0, x) = Sheets(i).Name ActiveCell.Offset(0, x).EntireRow.Interior.Color = vbCyan Next i Application.ScreenUpdating = True End Sub On Thu, Oct 27, 2011 at 3:54 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Expert, I have found one code which can consolidate the excel worksheets into one worksheet, but I wanted my worksheet name should also appear after consolidation in column. I am unable to make changes in this code, please help me urgently, Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = Master Then MsgBox There is a worksheet called as 'Master'. vbCrLf _ Please remove or rename this worksheet since 'Master' would be _ the name of the result worksheet of this process., vbOKOnly + vbExclamation, Error Exit Sub End If Next sht 'We don't want screen updating Application.ScreenUpdating = False 'Add new worksheet as the last worksheet Set trg = wrk.Worksheets.Add(After:=wrk.Worksheets(wrk.Worksheets.Count)) 'Rename the new worksheet trg.Name = Master 'Get column headers from the first worksheet 'Column count first Set sht = wrk.Worksheets(1) colCount = sht.Cells(1, 255).End(xlToLeft).Column 'Now retrieve headers, no copypaste needed With trg.Cells(1, 1).Resize(1, colCount) .Value = sht.Cells(1, 100).Resize(1, colCount).Value 'Set font as bold .Font.Bold = True End With 'We can start loop For Each sht In wrk.Worksheets 'If worksheet in loop is the last one, stop execution (it is Master worksheet) If sht.Index = wrk.Worksheets.Count Then Exit For End If 'Data range in worksheet - starts from second row as first rows are the header rows in all worksheets Set rng = sht.Range(sht.Cells(2, 1), sht.Cells(65536, 1).End(xlUp).Resize(, colCount)) 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value Next sht 'Fit the columns in Master worksheet trg.Columns.AutoFit 'Screen updating should be activated Application.ScreenUpdating = True End Sub Anil Bhange Assistant Manager Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai – 400 001, India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http
Re: $$Excel-Macros$$ urgent help needed.
Try this see if it helps On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee lee.sar...@gmail.com wrote: hello i need to combine multiple excel files(15) into one excel file. Each file has 2 sheets... R and S and data from both needs to consolidated into respective sheets. .. so i need a macro which can give one file with two sheets that consolidate data from all the files... All the files have same structure and columns. Also please let me know step by step on how to run the macro and do i have to run it from the first file Thanks much.. this is urgent -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel NEW merge from different workbooks.xlsm Description: Binary data
Re: $$Excel-Macros$$ Urgent Help needed-Dashboards
open this link http://chandoo.org/wp/excel-dashboards/ On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil avinash007pa...@gmail.comwrote: Hi Masters, can anybody please forward me excel dashboard designs i need dashboard designs with all automations and vba work like drop downs , charts, graphs a dashboard with full graphical and customization interface i'll be realy greatfull to you guys please forward me the designs, Regards, Avinash -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent Help needed-Dashboards
Hi Avinash, Try this: http://www.freeexceldashboards.com/exceldashboardtemplates.html Cheers, Andy On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil avinash007pa...@gmail.comwrote: Hi Masters, can anybody please forward me excel dashboard designs i need dashboard designs with all automations and vba work like drop downs , charts, graphs a dashboard with full graphical and customization interface i'll be realy greatfull to you guys please forward me the designs, Regards, Avinash -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Warm Regards, Aindril De Unified Learning Pvt Ltd. Ph: 9811300157 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent Help needed-Dashboards
Hi Avinash, Try below Links, http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/ http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/ http://www.contextures.com/excel-dashboards.html http://www.mrdashboard.com/download.html -- *Best Regards,* *Venkat* * * On Thu, Jul 21, 2011 at 5:49 PM, Aindril De aind...@gmail.com wrote: Hi Avinash, Try this: http://www.freeexceldashboards.com/exceldashboardtemplates.html Cheers, Andy On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil avinash007pa...@gmail.comwrote: Hi Masters, can anybody please forward me excel dashboard designs i need dashboard designs with all automations and vba work like drop downs , charts, graphs a dashboard with full graphical and customization interface i'll be realy greatfull to you guys please forward me the designs, Regards, Avinash -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Warm Regards, Aindril De Unified Learning Pvt Ltd. Ph: 9811300157 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent Help needed
Hi Ayoub, Can you please explain this: Of these columns some lack data if less than 8 of the above columns lack data word missed should appear Regards, Andy On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande akaka...@gmail.com wrote: Good afternoon I need some help on a project that is buzzing ma head attached is the excel file help is need on sheet 2 1) I need a formula to find the sum of the least 8 columns 2) The columns are D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2 3) Of these columns some lack data if less than 8 of the above columns lack data word missed should appear -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent Help needed
Hi, It looks like your calculations are not working as you are Displaying the numbers as text. For Example: The following Formula: = IF(sheet1!Q274,1,IF(sheet1!Q269,2,IF(sheet1!Q264,3,IF(sheet1!Q259,4,IF(sheet1!Q249,5,IF(sheet1!Q244,6,IF(sheet1!Q239,7,IF(sheet1!Q229,8,IF(sheet1!Q21,9,) Can be written as: = IF(sheet1!Q274,1,IF(sheet1!Q269,2,IF(sheet1!Q264,3,IF(sheet1!Q259,4,IF(sheet1!Q249,5,IF(sheet1!Q244,6,IF(sheet1!Q239,7,IF(sheet1!Q229,8,IF(sheet1!Q21,9,) 1 (text) changed to 1 (numeric) After you have modified your formulas, then in the final column you can use the formula: =IF(COUNTIF(A2:BL2,missed)8,Missed,SUM(D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2)) Copy down the formula to the last row of your range and it should give you the desired result. Regards, Andy On Tue, Nov 2, 2010 at 5:36 PM, Aindril De aind...@gmail.com wrote: Hi Ayoub, Can you please explain this: Of these columns some lack data if less than 8 of the above columns lack data word missed should appear Regards, Andy On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande akaka...@gmail.com wrote: Good afternoon I need some help on a project that is buzzing ma head attached is the excel file help is need on sheet 2 1) I need a formula to find the sum of the least 8 columns 2) The columns are D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2 3) Of these columns some lack data if less than 8 of the above columns lack data word missed should appear -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent Help needed
the columns in total are over 15 so if more than 8 columns have data in them I want to get a sum of th least 8, but if only 7 columns have data then the sum shoulld not be put in. coz what might happen is if some one attempted only 3 subjects it might compute his sum which i don't want. On 2 November 2010 15:06, Aindril De aind...@gmail.com wrote: Hi Ayoub, Can you please explain this: Of these columns some lack data if less than 8 of the above columns lack data word missed should appear Regards, Andy On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande akaka...@gmail.com wrote: Good afternoon I need some help on a project that is buzzing ma head attached is the excel file help is need on sheet 2 1) I need a formula to find the sum of the least 8 columns 2) The columns are D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2 3) Of these columns some lack data if less than 8 of the above columns lack data word missed should appear -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent Help needed
Thanx Aindril, I appreciate. Only that it's doing the reverse, it's finding sum for those who attempted less than 8 subjects. What I wanted is it finding sum if only one atempted either 8 or more subjects the sum found should be for the least 8 subjects of all the attempted e.g 1) If some one attempted 12 subjects it should find the sum for the least 8 subjects 2) If some one attmpted only 7 subjects it shoould insert the word missed some subjects 3) if some one attmped 8 subjects it should find the sum of those 8 subjects Tahnx very much On 2 November 2010 15:24, Aindril De aind...@gmail.com wrote: Hi, It looks like your calculations are not working as you are Displaying the numbers as text. For Example: The following Formula: = IF(sheet1!Q274,1,IF(sheet1!Q269,2,IF(sheet1!Q264,3,IF(sheet1!Q259,4,IF(sheet1!Q249,5,IF(sheet1!Q244,6,IF(sheet1!Q239,7,IF(sheet1!Q229,8,IF(sheet1!Q21,9,) Can be written as: = IF(sheet1!Q274,1,IF(sheet1!Q269,2,IF(sheet1!Q264,3,IF(sheet1!Q259,4,IF(sheet1!Q249,5,IF(sheet1!Q244,6,IF(sheet1!Q239,7,IF(sheet1!Q229,8,IF(sheet1!Q21,9,) 1 (text) changed to 1 (numeric) After you have modified your formulas, then in the final column you can use the formula: =IF(COUNTIF(A2:BL2,missed)8,Missed,SUM(D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2)) Copy down the formula to the last row of your range and it should give you the desired result. Regards, Andy On Tue, Nov 2, 2010 at 5:36 PM, Aindril De aind...@gmail.com wrote: Hi Ayoub, Can you please explain this: Of these columns some lack data if less than 8 of the above columns lack data word missed should appear Regards, Andy On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande akaka...@gmail.com wrote: Good afternoon I need some help on a project that is buzzing ma head attached is the excel file help is need on sheet 2 1) I need a formula to find the sum of the least 8 columns 2) The columns are D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2 3) Of these columns some lack data if less than 8 of the above columns lack data word missed should appear -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Hi Dilip,
Discription is nice one.
Cheers,
Gaurav Jain
On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Swapnil,
Below is a little explanation of the formula which I had used:-
Hope you will like it :)
SUMPRODUCT(--($A$2:$A$483=A2),--(D2$D$2:$D$483))+1
Above formula will also work if you enter like below:-
SUMPRODUCT(-($A$2:$A$483=A2),-(D2$D$2:$D$483))+1
But ideally you should use -- (two times minus sign), which results in
mathematical funda i.e., - x - = +
So if you evaluate the function SUMPRODUCT(($A$2:$A$483=A2)), you will
see that there are two TRUEs you are getting and by applying only one
minus (-) sign in the formula SUMPRODUCT(-($A$2:$A$483=A2), you will
get -2 and if you apply two minus sign in the formula
SUMPRODUCT(--($A$2:$A$483=A2), you will +2 or 2 ( positive numbers
have + sign as default)
Let me start step by step:-
SumProduct is kind of Array functionality, here it considers the range
wherein data in column A is equal to A2 which is Class1 and then
corresponding to it considers the range where the data in Column D is
greater then D2 234.
So if you consider data only related with Class 1 (filter the data on
Class 1 in column A), you will see that there is no data row which is
greater than 234 and there is one data row which is greater than 9.
Now if you add 1 to both these results i.e., adding 1 to None (1+0 =
1) and adding 1 to 1 (1+1=2), you will get the desired Ranking and
this is why I have added 1 at the end of each formula.
This is the main reason why I love SumProduct function :)
Alternatively, you can also use below array formula with sum
functionality which can deliver same results:-
{=SUM(IF(($A$2:$A$483=A2)*(D2$D$2:$D$483),1,0))+1}
Now, I leave this to you to learn and understand :)
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Swapnil Palande swapnilp1...@gmail.com wrote:
Hi Dilip,
This is excellent solution. But I am not able to understand it. Can you
explain it.
Regards,
Swapnil.
On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com
wrote:
Thanks Dave...!!!
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your requirements. Please let me
know
if
it solves your problem else get back with your queries.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com
wrote:
Hi,
In attached file I need ranking based on 'Points' column but we have
to
consider Coulmn 'A' i.e.) class.
Please help me...
Thanks in advance.
Regards,
M4S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about
the learning and support from the group.Let friends and co-workers
know
they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Thx Gaurav,
best regards,
Dilipandey
On 6/29/10, GAURAV JAIN jaingaura...@gmail.com wrote:
Hi Dilip,
Discription is nice one.
Cheers,
Gaurav Jain
On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Swapnil,
Below is a little explanation of the formula which I had used:-
Hope you will like it :)
SUMPRODUCT(--($A$2:$A$483=A2),--(D2$D$2:$D$483))+1
Above formula will also work if you enter like below:-
SUMPRODUCT(-($A$2:$A$483=A2),-(D2$D$2:$D$483))+1
But ideally you should use -- (two times minus sign), which results in
mathematical funda i.e., - x - = +
So if you evaluate the function SUMPRODUCT(($A$2:$A$483=A2)), you will
see that there are two TRUEs you are getting and by applying only one
minus (-) sign in the formula SUMPRODUCT(-($A$2:$A$483=A2), you will
get -2 and if you apply two minus sign in the formula
SUMPRODUCT(--($A$2:$A$483=A2), you will +2 or 2 ( positive numbers
have + sign as default)
Let me start step by step:-
SumProduct is kind of Array functionality, here it considers the range
wherein data in column A is equal to A2 which is Class1 and then
corresponding to it considers the range where the data in Column D is
greater then D2 234.
So if you consider data only related with Class 1 (filter the data on
Class 1 in column A), you will see that there is no data row which is
greater than 234 and there is one data row which is greater than 9.
Now if you add 1 to both these results i.e., adding 1 to None (1+0 =
1) and adding 1 to 1 (1+1=2), you will get the desired Ranking and
this is why I have added 1 at the end of each formula.
This is the main reason why I love SumProduct function :)
Alternatively, you can also use below array formula with sum
functionality which can deliver same results:-
{=SUM(IF(($A$2:$A$483=A2)*(D2$D$2:$D$483),1,0))+1}
Now, I leave this to you to learn and understand :)
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Swapnil Palande swapnilp1...@gmail.com wrote:
Hi Dilip,
This is excellent solution. But I am not able to understand it. Can you
explain it.
Regards,
Swapnil.
On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com
wrote:
Thanks Dave...!!!
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using
macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your requirements. Please let me
know
if
it solves your problem else get back with your queries.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com
wrote:
Hi,
In attached file I need ranking based on 'Points' column but we have
to
consider Coulmn 'A' i.e.) class.
Please help me...
Thanks in advance.
Regards,
M4S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about
the learning and support from the group.Let friends and co-workers
know
they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Thanks Dave...!!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi Dilip,Excellent solution!Regards - Dave Date: Fri, 25 Jun 2010 16:48:57 +0530 Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: mathan4s...@gmail.com Hi Mathan, Attached file has been solved per your requirements. Please let me know if it solves your problem else get back with your queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com wrote: Hi, In attached file I need ranking based on 'Points' column but we have to consider Coulmn 'A' i.e.) class. Please help me... Thanks in advance. Regards, M4S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Hi Dilip, This is excellent solution. But I am not able to understand it. Can you explain it. Regards, Swapnil. On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Dave...!!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi Dilip,Excellent solution!Regards - Dave Date: Fri, 25 Jun 2010 16:48:57 +0530 Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: mathan4s...@gmail.com Hi Mathan, Attached file has been solved per your requirements. Please let me know if it solves your problem else get back with your queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com wrote: Hi, In attached file I need ranking based on 'Points' column but we have to consider Coulmn 'A' i.e.) class. Please help me... Thanks in advance. Regards, M4S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Hi Swapnil,
Below is a little explanation of the formula which I had used:-
Hope you will like it :)
SUMPRODUCT(--($A$2:$A$483=A2),--(D2$D$2:$D$483))+1
Above formula will also work if you enter like below:-
SUMPRODUCT(-($A$2:$A$483=A2),-(D2$D$2:$D$483))+1
But ideally you should use -- (two times minus sign), which results in
mathematical funda i.e., - x - = +
So if you evaluate the function SUMPRODUCT(($A$2:$A$483=A2)), you will
see that there are two TRUEs you are getting and by applying only one
minus (-) sign in the formula SUMPRODUCT(-($A$2:$A$483=A2), you will
get -2 and if you apply two minus sign in the formula
SUMPRODUCT(--($A$2:$A$483=A2), you will +2 or 2 ( positive numbers
have + sign as default)
Let me start step by step:-
SumProduct is kind of Array functionality, here it considers the range
wherein data in column A is equal to A2 which is Class1 and then
corresponding to it considers the range where the data in Column D is
greater then D2 234.
So if you consider data only related with Class 1 (filter the data on
Class 1 in column A), you will see that there is no data row which is
greater than 234 and there is one data row which is greater than 9.
Now if you add 1 to both these results i.e., adding 1 to None (1+0 =
1) and adding 1 to 1 (1+1=2), you will get the desired Ranking and
this is why I have added 1 at the end of each formula.
This is the main reason why I love SumProduct function :)
Alternatively, you can also use below array formula with sum
functionality which can deliver same results:-
{=SUM(IF(($A$2:$A$483=A2)*(D2$D$2:$D$483),1,0))+1}
Now, I leave this to you to learn and understand :)
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Swapnil Palande swapnilp1...@gmail.com wrote:
Hi Dilip,
This is excellent solution. But I am not able to understand it. Can you
explain it.
Regards,
Swapnil.
On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com wrote:
Thanks Dave...!!!
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your requirements. Please let me know
if
it solves your problem else get back with your queries.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com wrote:
Hi,
In attached file I need ranking based on 'Points' column but we have to
consider Coulmn 'A' i.e.) class.
Please help me...
Thanks in advance.
Regards,
M4S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about
the learning and support from the group.Let friends and co-workers know
they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about
the learning and support from the group.Let friends and co-workers know
they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
_
View photos of singles in your area! Looking for a hot date?
http://clk.atdmt.com
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
Thanks a lotSimply great!!! On Fri, Jun 25, 2010 at 6:12 PM, Dilip Pandey dilipan...@gmail.com wrote: Hey Aindril thanks for your encouraging words... :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jun 25, 2010 at 5:38 PM, Aindril De aind...@gmail.com wrote: Hi Dilip, This is an excellent solution you have provided.. Hats off to you for keeping it so simple.. Cheers, Andy On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mathan, Attached file has been solved per your requirements. Please let me know if it solves your problem else get back with your queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com wrote: Hi, In attached file I need *ranking *based on 'Points' column but we have to consider Coulmn 'A' i.e.) class. Please help me... Thanks in advance. Regards, M4S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and
Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
You are welcome Mathan...!! :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jun 25, 2010 at 6:44 PM, Mathan mathan4s...@gmail.com wrote: Thanks a lotSimply great!!! On Fri, Jun 25, 2010 at 6:12 PM, Dilip Pandey dilipan...@gmail.comwrote: Hey Aindril thanks for your encouraging words... :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jun 25, 2010 at 5:38 PM, Aindril De aind...@gmail.com wrote: Hi Dilip, This is an excellent solution you have provided.. Hats off to you for keeping it so simple.. Cheers, Andy On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mathan, Attached file has been solved per your requirements. Please let me know if it solves your problem else get back with your queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.comwrote: Hi, In attached file I need *ranking *based on 'Points' column but we have to consider Coulmn 'A' i.e.) class. Please help me... Thanks in advance. Regards, M4S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at
RE: $$Excel-Macros$$ Urgent Help needed regarding using macro
Hi Dilip,Excellent solution!Regards - Dave Date: Fri, 25 Jun 2010 16:48:57 +0530 Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: mathan4s...@gmail.com Hi Mathan, Attached file has been solved per your requirements. Please let me know if it solves your problem else get back with your queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Jun 24, 2010 at 9:14 PM, Mathan mathan4s...@gmail.com wrote: Hi, In attached file I need ranking based on 'Points' column but we have to consider Coulmn 'A' i.e.) class. Please help me... Thanks in advance. Regards, M4S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent Help Needed
hi sheetal! why dont u copy the entire sheet.. and paste it on another (unprotected sheet).. a bit silly suggestion.. just chk if it works for u.. u wont atleast loose the working.. Regards, Anubhav On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia sheetallakho...@gmail.com wrote: Hi Friends, Is there anyway to remove the password from the attached excel file. My colleague who created this sheet has forgot the password and we need to make changes in this sheet very urgently. It would be great if any of you can crack the password for me or let me know how to do it. Any help on this would be greatly appreciated. Thanks and Regards, Sheetal Lakhotia -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent Help Needed
Thanks Vinod and Dave for ur help. I appreciate all ur effortshowever...this still does not allow me to write new macro or make changes in the macros in this excel file. it still asks for a VBA password for same. Plz see if u guys can crack that password for me or let me knw how to do this. On Nov 23, 6:24 pm, vinod nayak vinodvna...@gmail.com wrote: Hi, Find attached file without the password. With Regards, Vinod Nayak On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia sheetallakho...@gmail.com wrote: Hi Friends, Is there anyway to remove the password from the attached excel file. My colleague who created this sheet has forgot the password and we need to make changes in this sheet very urgently. It would be great if any of you can crack the password for me or let me know how to do it. Any help on this would be greatly appreciated. Thanks and Regards, Sheetal Lakhotia -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials athttp://www.excel-macros.blogspot.com 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Time Utilization Report Generator.xls 274KViewDownload -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Urgent Help Needed
Hi, If you can open the file in Read-only mode, then do so, make the changes you want, then Save As whatever name you want. Then just delete the original. Regards - Dave Date: Fri, 20 Nov 2009 17:59:46 -0800 Subject: $$Excel-Macros$$ Urgent Help Needed From: sheetallakho...@gmail.com To: excel-macros@googlegroups.com Hi Friends, Is there anyway to remove or crack the VBA password from the an excel file. As soon as u double click to open the file. It gives a message that Enter password for write access or open read only. My colleague who created this sheet has forgot the password and we need to make changes in this sheet very urgently. It would be great if any of you can let me know how to do it. Any help on this would be greatly appreciated. Thanks and Regards, Sheetal Lakhotia -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Looking for a date? View photos of singles in your area! http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
