Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs
Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs - used to count the range by checking multiple conditions. On Jul 29, 2013 8:28 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear seniors, How can we use sum sumifs , countif countifs. and what is the diffrence between. pls explain with formula and example. pls help me. thanks Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- -- Thanks Regards, *Rajasekhar.P* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ autofilter issue
Rekha, Just try this code instead of or change it to And With ThisWorkbook.Worksheets(Bex File) Set rng = .Range(A1).CurrentRegion rng.AutoFilter 15, *Chief Technology Office*, xlAnd, *Desktop Platform* rng.AutoFilter Field:=25, Criteria1:==*AF* Sheets(Bex File).Select Cells.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy On Sun, Jun 2, 2013 at 2:01 AM, rekha siri rekha.siri2...@gmail.com wrote: Hi Friends, i tried piece of code for auto filter criteria , i succeeded in condition for autofilter for which criteria is equal to... but does not equal to condition i am not getting proper result. Basically i want to place a condition that 15th column in Bex file sheet should be filter with custom filter does not equal to Chief Technology Office Desktop Platform and should equal to AF criteria in 25th column . below is the code please rectify me... With ThisWorkbook.Worksheets(Bex File) Set rng = .Range(A1).CurrentRegion rng.AutoFilter 15, *Chief Technology Office*, xlOr, *Desktop Platform* rng.AutoFilter Field:=25, Criteria1:==*AF* Sheets(Bex File).Select Cells.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- -- Thanks Regards, *Rajasekhar.P* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Advance filter issue
hi Experts, Need your help , as i could not club both sheets in new workbook. Thanks, Raj On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi friends, Please assist with Advance filter issue, i have created a macro which will be taking unique cost centers from LOAD DATA tab and copy the complete rows and paste it individual workbooks cost center wise. but now i have another tab beside LOAD DATA , i.e Detail tab. Now can any one help to perform same action like above.. Copy the A column unique costcenters and copy the details individual cost center wise. Both tabs which is generated from LOAD DATA and Detail Tab should be in placed in one workbook. Thanks i am attaching work book please assist in this concern. -- -- Thanks Regards, *Rajasekhar.P* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- -- Thanks Regards, *Rajasekhar.P* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Happy b'day Noorain Ansari
Happy birthday Noor have a delightful nd colourful moments a head. On Jan 2, 2013 12:25 AM, Umesh Soni soniume...@gmail.com wrote: Happy birthday Noorain.. May All u r wishes comes true have a great Year Ahead. Regards, Umesh Soni On Tue, Jan 1, 2013 at 7:43 PM, koul.ash...@gmail.com wrote: Happy b'day Noorain Ansari Regards Ashish Koul Sent on my BlackBerry® from Vodafone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ discussexcel formula quiz 1
done On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA vijayajith...@gmail.comwrote: done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal isk1...@gmail.com wrote: Done. On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain jainayus...@gmail.comwrote: Dear group, I have created a small formula quiz to test your formula knowledge. This quiz has 10 questions related to excel formulas only. Formula quiz http://goo.gl/DE4V3 Based on your participation and engagement, I will try to launch more such activities in the forum Click here to participate http://goo.gl/DE4V3 Only 50 people can participate, so hurry and participate. Many Thanks. Regards, Ayush Jain Group Manager -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- -- Thanks Regards, Rajasekhar.P -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5)
$$Excel-Macros$$ Accoount payable excel templates
Hi friends, Please share the excel template of accounts payable if any one of u is having. basically i am planning to build up a template on accounts payable data in excel for forecasting and analysis. and need your experts advise. Please do share if any of you are having such stuff. Thanks in Advance. -- -- Thanks Regards, Rajasekhar.P -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012
Congrats rajan for your threshold efforts.. On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff a...@lovetour.info wrote: I'm happy to see you recognized and honored for your continued great contribution Rajan. Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain *Sent:* Tuesday, October 02, 2012 8:34 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 ** ** Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Sep'12. He has posted 137 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution.* Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Marquee text in Powerpoint
Ashish, any idea in this regards as already you have created in excel. Thanks for your help in advance!! On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon da...@grugeon.com.au wrote: You might do better asking PowerPoint questions on a Powerpoint forum. As its name indicates this forum is about Excel Macros. On 4 August 2012 02:24, rekha siri rekha.siri2...@gmail.com wrote: Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power point dashboard presentation. is there any possibility to place the scrolling marquee kind of text as Headings of power point slides. which needs to be scrolling continously. Thanks, Rekha -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries and Suggestions @ excel-gro...@googglegroups.com Excelforum Blogspot a href= http://feedburner.google.com/fb/a/mailverify?uri=ExcelForumamp;loc=en_UShttp://feedburner.google.com/fb/a/mailverify?uri=ExcelForumloc=en_USSubscribe to excel forum by Email/a -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$
hi experts, Need your expert advise. please provide a vba code which copiesText frame box copied from excel and then pastes it to ppt slide in bottom. -- -- Thanks Regards, Rajasekhar.P -- 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$$ Need if formula
thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Follow *Rediff Deal ho jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals * to get exciting offers in your city everyday. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries
Re: $$Excel-Macros$$ Need if formula
i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta sharadgupta_2...@rediffmail.com wrote: On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- 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 Sharad Gupta 9799795367 http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Follow *Rediff Deal ho jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals * to get exciting offers in your city everyday. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- Thanks
$$Excel-Macros$$ Need help
Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the sub folders names and their respective sizes. Thanks for your help in advance. -- -- Thanks Regards, Rajasekhar.P -- -- 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$$ Need help
hi Paul, i am getting bug here, ub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R FolderName = D:\C-backup Sht = FolderList Set fso = CreateObject(Scripting.FileSystemObject) Sheets(Sht).Range(A2:Z65000).ClearContents this yellow highlighted one i am getting bug. Please can you help me in this concern. Thanks, Raj On Fri, Oct 14, 2011 at 8:51 PM, Paul Schreiner schreiner_p...@att.netwrote: This should do it. Sub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R FolderName = C:\temp\ Sht = FolderList Set fso = CreateObject(Scripting.FileSystemObject) Sheets(Sht).Range(A2:Z65000).ClearContents R = 1 If (fso.folderexists(FolderName)) Then Set fldr = fso.getfolder(FolderName) For Each sfldr In fldr.subfolders R = R + 1 Sheets(Sht).Cells(R, A).Value = sfldr.Name Sheets(Sht).Cells(R, B).Value = sfldr.Size Next End If MsgBox Done End Sub *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:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:18:13 AM *Subject:* Re: $$Excel-Macros$$ Need help Hi Paul, Thanks for your quick reply, Only the first sub folder names and their respective sizes. Thanks, Raj On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner schreiner_p...@att.netwrote: are you wanting all sub-folders within the folder? or do you want to progress down through all the nested sub-folders? *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:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:11:22 AM *Subject:* $$Excel-Macros$$ Need help Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the sub folders names and their respective sizes. Thanks for your help in advance. -- -- Thanks Regards, Rajasekhar.P -- -- 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 -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries and Suggestions @ excel-gro...@googglegroups.com Excelforum Blogspot a href= http://feedburner.google.com/fb/a/mailverify?uri=ExcelForumamp;loc=en_UShttp://feedburner.google.com/fb/a/mailverify?uri=ExcelForumloc=en_USSubscribe to excel forum by Email/a -- -- 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$$ Need help
thanks alot Paul its working. On Fri, Oct 14, 2011 at 9:09 PM, Paul Schreiner schreiner_p...@att.netwrote: do you HAVE a sheet called FolderList ?? If not, replace FolderList with the name of the sheet that you want to use to display the sizes! *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:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:31:34 AM *Subject:* Re: $$Excel-Macros$$ Need help hi Paul, i am getting bug here, ub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R FolderName = D:\C-backup Sht = FolderList Set fso = CreateObject(Scripting.FileSystemObject) Sheets(Sht).Range(A2:Z65000).ClearContents this yellow highlighted one i am getting bug. Please can you help me in this concern. Thanks, Raj On Fri, Oct 14, 2011 at 8:51 PM, Paul Schreiner schreiner_p...@att.netwrote: This should do it. Sub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R FolderName = C:\temp\ Sht = FolderList Set fso = CreateObject(Scripting.FileSystemObject) Sheets(Sht).Range(A2:Z65000).ClearContents R = 1 If (fso.folderexists(FolderName)) Then Set fldr = fso.getfolder(FolderName) For Each sfldr In fldr.subfolders R = R + 1 Sheets(Sht).Cells(R, A).Value = sfldr.Name Sheets(Sht).Cells(R, B).Value = sfldr.Size Next End If MsgBox Done End Sub *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:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:18:13 AM *Subject:* Re: $$Excel-Macros$$ Need help Hi Paul, Thanks for your quick reply, Only the first sub folder names and their respective sizes. Thanks, Raj On Fri, Oct 14, 2011 at 8:45 PM, Paul Schreiner schreiner_p...@att.netwrote: are you wanting all sub-folders within the folder? or do you want to progress down through all the nested sub-folders? *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:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:11:22 AM *Subject:* $$Excel-Macros$$ Need help Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the sub folders names and their respective sizes. Thanks for your help in advance. -- -- Thanks Regards, Rajasekhar.P -- -- 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 -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https
Re: $$Excel-Macros$$ Speech Recognition software for excel
Thanks for sharing this mahesh and rajan On Wed, Aug 31, 2011 at 11:36 PM, rajan verma rajanverma1...@gmail.comwrote: Hi, I just use this Sub speak() Application.Speech.speak Hellow EveryOne, Look I M speaking End Sub On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab mahes...@gmail.com wrote: Hi does any one aware of Speech Recognition software for excel, below are some link i found on net anyone using Dragon NaturallySpeaking - Speech recognition software ? http://dragon-naturallyspeaking.lastdownload.com/download.html http://www.youtube.com/watch?v=OsqU31EcUS8feature=related Thanks Mahesh -- -- 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 Rajan verma +91 9158998701 -- -- 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 -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries and Suggestions @ excel-gro...@googglegroups.com Excelforum Blogspot a href= http://feedburner.google.com/fb/a/mailverify?uri=ExcelForumamp;loc=en_UShttp://feedburner.google.com/fb/a/mailverify?uri=ExcelForumloc=en_USSubscribe to excel forum by Email/a -- -- 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$$ to find particular column and insert one column and perform Vlookup using vba
Thanks a ton to one all really helped me alot in this concern. On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab mahes...@gmail.com wrote: Hi For Vlookup you can use static Name range which is predetermined RANGE =SBUMapping!$A$1:$D$789 OR dynamic Name range range which resize dynamically RANGE =OFFSET(SBUMapping!$A$1,0,0,COUNTA(SBUMapping!$A:$A),COUNTA(SBUMapping!$1:$1)) Thanks Mahesh On Mon, Jul 18, 2011 at 11:05 PM, Mahesh parab mahes...@gmail.com wrote: Hi Prathima Assuming your Data 1,2 3 columns contain data Try : Sub test() Dim LR As Long Sheets(Summary).Select Set Found = Sheets(Summary).Rows(1).Find(what:=Data 1, LookIn:=xlValues, lookat:=xlWhole) LR = Cells(Rows.Count, Found.Column).End(xlUp).Row Found.Offset(, 1).EntireColumn.Insert Cells(1, Found.Column + 1).Value = SBU Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula = Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)), Range(RANGE), 2, False) Set Found = Sheets(Summary).Rows(1).Find(what:=Data2, LookIn:=xlValues, lookat:=xlWhole) LR = Cells(Rows.Count, Found.Column).End(xlUp).Row Found.Offset(, 1).EntireColumn.Insert Cells(1, Found.Column + 1).Value = Region Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula = Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)), Range(RANGE), 3, False) Set Found = Sheets(Summary).Rows(1).Find(what:=Data3, LookIn:=xlValues, lookat:=xlWhole) LR = Cells(Rows.Count, Found.Column).End(xlUp).Row Found.Offset(, 1).EntireColumn.Insert Cells(1, Found.Column + 1).Value = Division Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula = Application.VLookup(Range(Cells(2, Found.Column), Cells(LR, Found.Column)), Range(RANGE), 4, False) End Sub Thanks Mahesh On Sun, Jul 17, 2011 at 12:02 PM, Prathima R prathima@gmail.comwrote: hi experts, Please help me in this concern. i need to perform vlookup function using VBA i have attached sample work book for referance From the attached workbook i need update summary sheet using the company code as base from SBU Mapping sheet. i need to insert one column after Data1 , Data2, Data3 Columns and pull the SBU,DIVISION, REGION Please provide the vba code code to find the data1 column and then insert one column after it.then i need to pull data using vlookup. like wise i will be updating for all rest. Thanks, Prathima. -- -- 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 -- -- 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
$$Excel-Macros$$ Fwd: FW: Leave planner tracker1.xlsx
hi, I will be preparing the leaveplanner tracker report frequently . i will colour the specific day when i am absent on particular day.finallyon the end of the month i will count the different colours and place the number. Please provide the formula or vba macro to perform this activity. thanks, Raj -- -- 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 Leave planner tracker1.xlsx Description: Binary data
Re: $$Excel-Macros$$ Nos. of Sundays between two days
thanks alot its awesome On Wed, Feb 16, 2011 at 8:48 PM, ashish koul koul.ash...@gmail.com wrote: j1 start date j2 end date monday =I F(TEXT(J1,)Monday,NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1) saturday = INT(((J2-J1)-NETWORKDAYS(J1,J2))/2) On Wed, Feb 16, 2011 at 7:10 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: hi ashish, Can you please help to find out how many mondays and saturdays are present for the same above query. 01/16/2011 to 02/16/20111 Thanks, Raj On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan nalini.pradha...@gmail.comwrote: Thank you very much for the prompt reply Sir. - Original Message - *From:* ashish koul koul.ash...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, February 14, 2011 8:17 PM *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days start date in a1 and end date in a2 no of sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1 On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan nalini.pradha...@gmail.comwrote: Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 and 31/01/2011. Thanks Regards. -- -- 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/ *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 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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$$ Nos. of Sundays between two days
hi ashish, Can you please help to find out how many mondays and saturdays are present for the same above query. 01/16/2011 to 02/16/20111 Thanks, Raj On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan nalini.pradha...@gmail.comwrote: Thank you very much for the prompt reply Sir. - Original Message - *From:* ashish koul koul.ash...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, February 14, 2011 8:17 PM *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days start date in a1 and end date in a2 no of sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1 On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan nalini.pradha...@gmail.comwrote: Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 and 31/01/2011. Thanks Regards. -- -- 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/ *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 -- -- 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$$ data in horizontal row
hi please use this simple procedure Excel Text to Column Command The Text to Column command allows you to break text in one column into several columns. For example, if you have LastName, FirstName in a column, you can break the text into two columns—one containing LastName and the other containing FirstName. 1. Insert as many columns to the left of the column to be split as needed. 2. Select the cells to be separated. 3. Pull down the Data menu and choose Text to Columns 4. Choose Delimited and click on Next 5. Choose the Delimiter that is used in the column, such as comma and click on Next 6. To set the column data format, click on the column and then click on the format desired under column data format (this is optional). Repeat this for each column and click on Finish. Excel Transpose Command Use the transpose feature to switch data from vertical to horizontal. 1. Select the cells to switch 2. Click on the Copy tool 3. Click where you want the data to be transposed to 4. Pull down the Edit menu and choose Paste Special 5. Click on Transpose and click on OK Thanks, Raj On Tue, Feb 15, 2011 at 1:37 AM, Hems coolh...@gmail.com wrote: Hi Guys, Pls check attached excel sheet. I have data in across 2 columns which i want move in one row through macro, is it possible? actually the data is extracted from access database so if its poss through macro then i can process in access rather trolling it through excel. appreciate your efforts and thanks in advance. -- Kind Regards, Hems -- -- 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
$$Excel-Macros$$ ashish koul koul.ash...@gmail.com,
Hi, I have an excel sheet and I want to filter for BLANKS in multiple columns and provide comment of the other column. Can some one help me writing a macro/add-on? expand » Here each time the columns will not be the same, so it would be good if the macro asks for the range and perform the activity. And second criteria are next column if I specify the path is should populate with the value as No for the entire BLANKS and Yes for the non blanks one. Example file attached for reference, where in my range will be from open price i.e from column AG to AZ and in next column i.e BA I should have comment as No for BLANKS and Yes for NON BLANKS. Thanks and have a nice weekend...!!! Regards, Raj -- -- 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
$$Excel-Macros$$ Fwd: Excel 2003 vs 2007
Hi Friends, I just wanted to share this differences between Excel 2003 and 2007. Number of Rows and Columns One of the main developments in Excel 2007 is that it allows more columns and rows. For many users this may not be an issue - after all, the 65,536 rows and 256 columns provided by Excel 2003 allows you to handle a large amount of data. However, it isn't so unusual for users to want to handle HUGE amounts of data! Therefore Excel 2007's ability to handle 1,048,576 rows and 16,384 columns of data is a great advantage for some users. Conditional Formatting Another major improvement in Excel 2007 is Conditional formatting. I have frequently been asked, by colleagues using Excel 2003, about applying more than 3 conditional formats. Up until recently, I have always had to explain that this is a limitation of Excel 2003, but now, in Excel 2007, a user can specify as many conditions as they like, each with a different format. [image: Data Bars Color Scales Icon Sets Examples in Excel 2007] Conditional formatting in Excel 2007 can even be made to work for cells that satisfy more than one condition. For example, if you specify cells having values ≤ 10 to have bold text and cells having values ≥ 10 to have red text, you will find that text in cells containing values exactly equal to 10 will be formatted as bold AND red. Also, Excel 2007 offers additional types of conditional formatting. If your bosses (like mine) like to see figures illustrated with pretty charts and lots of colour, they will love the spreadsheets you produce with Excel's new Data Bars, Color Scales Icon Sets! These features apply colour or symbols to a range of cells, depending upon each cell's value in relation to the rest of the cells in the selected range. As an example, the image on the right shows conditional formatting Data Bars, Color Scales Icon Sets, applied to 3 columns, each containing the numbers 1 - 10. As a final bonus, Excel 2007 also now enables conditional formatting to be used with pivot tables. At first, the interface to Excel 2007 conditional formatting can appear to be a bit complicated, but the time spent familiarising yourself with this functionality is well worth the investment! Filtering and Sorting by Colour In Excel 2003, Filtering and Sorting could be performed by cell values only. However, in Excel 2007, you can now filter and sort by colour. This can be either the font colour or the cell background colour. Function Nesting Limitations In my opinion, one of the most useful improvements in Excel 2007 is the level of nesting that can be performed. Excel 2003 only allows 7 levels of nesting of functions, while Excel 2007 allows up to 64. Surely, even the most dedicated Excel user cannot possibly need more nesting levels than that! Resizeable Formula Bar [image: Extended Formula Bar in Excel 2007] In Excel 2003, if a cell contained a long formula or text string, when the cell was selected, the view of the formula bar would block some of your spreadsheet. This was slightly inconvenient. However, Microsoft have addressed this problem in Excel 2007, by introducing a resizeable formula bar, which extends in line with your cell contents. This is shown in the image above. New Functions Excel 2007 contains a number of new built-in functions to help you to make your spreadsheet slicker and more efficient. These include the IFERROR Function, the SUMIFS function, and the new statistical AVERAGEIF, AVERAGEIFS, and COUNTIFS functions. Increased Memory and Faster Calculations My work has frequently been slowed down, when applying functions to large datasets in Excel 2003. I have often pasted a formula down every row of a spreadsheet, and then had to sit back and wait for Excel to calculate the formula results. However, this has improved in in Excel 2007, as memory management has been increased from 1 gigabyte to 2 gigabytes and complex calculations are now faster. Charting There have been some issues with the updating of charts in Excel 2007, which is slower than in Excel 2003. Also, the recording of macros involving charts sometimes doesn't work! For me personally, this isn't a great issue. However, if you frequently perform chart updates, or like to record macros involving charts, you should test drive Excel 2007 before committing to it. A free trial can be downloaded from the Microsoft Office Online website *(opens in a new window)*. New User Interface The main user interface has been restructured in Excel 2007, into what Microsoft describe as a results-oriented interface. However, if you have been using Excel 2003 for several years, and know exactly where to find the tools functionality that you regularly use, there will almost certainly be a certain amount of frustration to begin with. My advice is ... Persevere! ... it really is worth the effort! Like anything, once you get used to it, negotiating the new user interface will become second nature to you! Thanks, Raj --
$$Excel-Macros$$ Fwd: need help
Hi , In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -- 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 query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Fwd: need help
Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -Thanks, Raj -- -- 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 query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Fwd: need help
Please find the attached sheet i could able to build formula for single line item But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice which is shown on top left hand corner. IRS Publications activity has two line items then it should come as against the J102 which is IRS Publications it should through up the description and date in this manner pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 -- -Thanks, Raj -- -- 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 query with formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Congratts dilip On Tue, Jan 4, 2011 at 12:34 AM, Vinod N nvino...@gmail.com wrote: Congratulations!! Dilipji... On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- 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 -- Thanks and Regards Vinod Narayanan http://cavinod.blogspot.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/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$$ Top poster of the Month- Dec'10 : Ashish Koul
Congratulations Ashish, we wish you flamboyant future. On Sat, Jan 1, 2011 at 4:40 PM, ashish koul koul.ash...@gmail.com wrote: welcome ayush, happy new year to you and everyone in the group... On Sat, Jan 1, 2011 at 1:37 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very happy to announce that Ashish Koul is the top poster for the month of Dec'10. He has topped with 37 posts this month. Ashish, Congratulations and Many Many Thanks for your great contribution. I really appreciate your willingness to help others and your excellent knowledge of excel. Keep it up. Thanks a tonne on behalf of whole group. Keep posting ! Best regards, Ayush Jain Microsoft MVP -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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/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$$ How to extract characters from right
hi Kalyan, Use substitute function. Please find the attached solution hope it helps you. Thanks, Raj On Fri, Nov 26, 2010 at 10:55 AM, Kal xcel kalx...@gmail.com wrote: Dear Experts, I am facing a problem to extract characters from right of string. Please help. Thanks in advance. Kalyan -- -- 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 How to extract characters from right(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup
Hi Muralidhar, did u check the attached pivot solution let me know if it is not apt then i will do v-lookup fucntion as u sent. Thanks, Raj On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e emuralidha...@gmail.comwrote: Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. -- Forwarded message -- From: muralidhar e emuralidha...@gmail.com Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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 -- -- 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$$ Vlookup
Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e emuralidha...@gmail.comwrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- 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 Solved key.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help Required
hello rakesh, Only for this attached sheet do you have query or Prior chain mails as well, then i think u can just use this formula for the attached sheet replacing date =A2+30 By adding 30days u are getting the answer...Please let me know if this resolves your query or not. Thanks, Raj On Thu, Nov 11, 2010 at 10:48 AM, Rakesh Sharma rksharma...@gmail.comwrote: Dear All, Can i replace the date as per my requirement. if yes plz suggest me how it possible. Thanks in advance plz do the needful ASAP. -- Regards Rakesh Sharma -- -- 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 Copy of help req.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Conditional Formatting
Conditional Formatting You can use something called Conditional Formatting in your spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on the grade. Here's the spreadsheet we'll be working on. [image: The Student Grades Spreadsheet] - Open up your Student Exam spreadsheet (You did complete it, didn't you?) - Highlight the cells with Overall Grades, which should be cells B11 to I11 The Overall Averages range from 44 to 85. We'll colour each grade, depending on a scale. A different colour will apply to the following grades: - 50 and below - 51 to 60 - 61 to 70 - 71 to 80 - 81 and above So five different bands, and a colour for each. To set the Conditional Formatting in Excel 2007, do the following: - With your Overall Averages highlighted, click on the Home menu at the top of Excel - Locate the *Styles* panel, and the *Conditional Formatting* item: [image: The Styles Panel in Excel 2007] The Conditional Formatting menu gives you various options. The easiest one is the Colour Scales option. Select one of these and Excel will colour the cell backgrounds for you: [image: Color Scales in Excel 2007] That's not quite what we're looking for, though. We'd like to choose our own values. So click on *More Rules*, from the *Colour Scales* submenu. You'll see the following rather complex dialogue box: [image: New Formatting Rule dialogue box] The one we want is the second option, *Format only cells that contain*. This will allow us to set up our values. When you click this option, the dialogue box changes to this: The part we're interested in is the bottom part, under the heading *Edit the Rule Description*. It says *Cell Value* and *Between*, in the drop down boxes. These are the ones we want. We only need to type a value for the two boxes that are currently blank in the image above. We can then click the * Format* button to choose a colour. So type 0 in the first box and 50 in the second one: Then click the *Format* button. You'll get another dialogue box popping up. This is just the Format Cells one though. You've met this before. Click on the Fill tab and choose a colour. Click OK and you should see something like this under Edit the Rule Description: The Preview is showing the colour we picked. So we've said, *If* the Cell Value is between 0 and 50 *then* colour the cell Red. Click OK on this dialogue box to get back to Excel. You should find that one of the cells has turned red. To format the rest of the cells, click on Conditional Formatting on the Styles panel again. From the menu, click on *Manage Rules*: You'll get yet another complex dialogue box popping up! This one: Our first rule is already there - Cell Value Between. The only thing we're doing here is adding New Rules, similar to the one we've just set up. Click the *New Rule* button then. You'll see the exact same dialogue boxes you used to set up the first rule. Set a new colour for the next scores - 51 to 60. Choose a colour, and keep clicking OK until you get back to the Rules Manager dialogue box. It should now look something like this one: We now have to colours in our range. Do the rest of the scores, choosing a colour for each. The scores are these, remember: - 50 and below - 51 to 60 - 61 to 70 - 71 to 80 - 81 and above When you've done them all, your dialogue box should have five colours: The colours above are entirely arbitrary, and you don't have to select the same ones we did. The point is to have a different colour for each range of scores. But click OK when you're done. Your Overall Averages will then look something like this: Formatting your spreadsheet in this way allows you to see at a glance relevant information. In the spreadsheet above, it's obvious who's failing - just look for the red cells! -- -- 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$$ Help: Using SUMIF(S) Function
hi, Check this website hope you will find the resolution http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html Thanks, Raj On Tue, Nov 9, 2010 at 11:19 PM, janet dickson janetdicks...@gmail.comwrote: Hello Excel Gurus, I encountered a challenge on using SUMIF FUNCTION. Help me on summing total amount in different months into different cells. See attached fine for details. -- -- 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$$ Please help
Thanks dilip . On Wed, Oct 13, 2010 at 5:51 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Rajasekhar, I believe you are using Excel 2007, this is what I have figured out after seeing your example of Pivots. I would suggest you to record macro with all the steps which you are doing manually and then try editing those codes as per your automation needs. Alternatively, if you break down your manual steps in smaller steps, then I can give a try on this. See doing it all from scratch is slightly time consuming and now-a-days I am little occupied and unable to devote that much time. :( Best Regards, DILIPandey On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: -- Forwarded message -- From: rajasekhar praharaju rajasekhar.prahar...@gmail.com Date: Tue, Oct 12, 2010 at 5:49 PM Subject: Re: $$Excel-Macros$$ Please help To: Dilip Pandey dilipan...@gmail.com, excel-macros@googlegroups.com hi Dilip, firstly i will be copying the pivot table from task distribution sheet. Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA 15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250 this part from task distribution sheet and click on extension bar (+) to get the individual line items for all. then place the name which is listed on the top of the batch against their respective lineitems . like this . Row Labels Sum of # of no hits DEEPTI 45 3 1 4 2 6 1 8 1 9 1 11 1 12 1 15 2 292 1 300 2 301 1 302 2 304 2 305 1 418 10 561 2 562 1 573 3 574 5 735 1 742 4 LAKSHMI 35 288 6 394 5 420 2 422 6 429 1 564 2 565 7 569 1 737 5 NIKHIL 46 289 3 293 6 306 1 396 6 397 3 424 4 425 4 427 3 566 4 571 4 576 4 739 4 PUSHPA 15 287 10 295 5 RAVI 7 285 4 286 3 SAI 35 296 4 297 3 298 1 398 6 399 3 423 5 568 1 572 5 578 5 740 2 VENKAT 46 284 13 290 2 308 2 309 2 311 1 416 4 421 5 563 8 570 3 736 6 ARVIND 21 16 3 283 3 299 2 307 1 395 3 419 1 428 5 430 1 741 2 Grand Total 250 here the first column is Batch # and second column is their number of hits. Please find the word file attached i will assign names as follows. After this ill do v-lookup in the sheet where the data is pasted . comparing the task distribution sheet orginal with Task distribution sheet. 1) ill take batch number from task distribution orginal sheet which is in column c as Lookup value. and table array as the data pasted in new sheet earlier.(pivot table data which is pasted using paste special and then assigned names to it) and Purpose of this vlook is to know get the pending batches billers names. those batches which are left in task distribution sheet that batches as well as their names should appear. Please advise is it possible. it could be very much helpful. Thanks, Raj On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Rakasekhar. I am not able to understand your problem actually... :( How you are assigning the names against tasks ? I believe creating a pivot table and then using Show Pages option you can assign the tasks to different individuals. Please explain further if you need some other solution. Best Regards, DILIPandey On 10/9/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily activity is to do vlookup and firstly i will copy the pivot table from task distribution sheet orginal and paste special in one new excel sheet then compare it with another sheet which is task distribution sheet. 1) Prepare vlookup to find the batches which are pending . once i perform vlookup it will display the names against the batches. which are pending . Please advise is this possible through vba. Thanks for your help in advance., Raj -- -- 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
Re: $$Excel-Macros$$ Please help
hi Dilip, firstly i will be copying the pivot table from task distribution sheet. Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA 15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250 this part from task distribution sheet and click on extension bar (+) to get the individual line items for all. then place the name which is listed on the top of the batch against their respective lineitems . like this . Row Labels Sum of # of no hits DEEPTI 45 3 1 4 2 6 1 8 1 9 1 11 1 12 1 15 2 292 1 300 2 301 1 302 2 304 2 305 1 418 10 561 2 562 1 573 3 574 5 735 1 742 4 LAKSHMI 35 288 6 394 5 420 2 422 6 429 1 564 2 565 7 569 1 737 5 NIKHIL 46 289 3 293 6 306 1 396 6 397 3 424 4 425 4 427 3 566 4 571 4 576 4 739 4 PUSHPA 15 287 10 295 5 RAVI 7 285 4 286 3 SAI 35 296 4 297 3 298 1 398 6 399 3 423 5 568 1 572 5 578 5 740 2 VENKAT 46 284 13 290 2 308 2 309 2 311 1 416 4 421 5 563 8 570 3 736 6 ARVIND 21 16 3 283 3 299 2 307 1 395 3 419 1 428 5 430 1 741 2 Grand Total 250 here the first column is Batch # and second column is their number of hits. After this ill do vlookup in the sheet where the data is pasted . comparing the task distribution sheet orginal with Task distribution sheet. 1) ill take batch number from task distribution orginal sheet which is in column c as Lookup value. and table array as the data pasted in new sheet earlier.(pivot table data which is pasted using paste special and then assigned names to it) and Purpose of this vlook is to know get the pending batches billers names. those batches which are left in task distribution sheet that batches as well as their names should appear. Please advise is it possible. it could be very much helpful. Thanks, Raj On Tue, Oct 12, 2010 at 4:37 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Rakasekhar. I am not able to understand your problem actually... :( How you are assigning the names against tasks ? I believe creating a pivot table and then using Show Pages option you can assign the tasks to different individuals. Please explain further if you need some other solution. Best Regards, DILIPandey On 10/9/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily activity is to do vlookup and firstly i will copy the pivot table from task distribution sheet orginal and paste special in one new excel sheet then compare it with another sheet which is task distribution sheet. 1) Prepare vlookup to find the batches which are pending . once i perform vlookup it will display the names against the batches. which are pending . Please advise is this possible through vba. Thanks for your help in advance., Raj -- -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips
Re: $$Excel-Macros$$ Please help
could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily activity is to do vlookup and firstly i will copy the pivot table from task distribution sheet orginal and paste special in one new excel sheet then compare it with another sheet which is task distribution sheet. 1) Prepare vlookup to find the batches which are pending . once i perform vlookup it will display the names against the batches. which are pending . Please advise is this possible through vba. Thanks for your help in advance., Raj -- -- 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 -- -- 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$$ Add-In
hello friend, Go to top left hand corner of excel click on office button-- excel options--- then select the add ins by double clicking on it. then click on manage option --- go Thanks, Raj On Thu, Oct 7, 2010 at 10:55 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Hi Experts, I want to know Add-in in excel. How this option is working or how can i know about this option much more. Give me any idea or tips. awaiting your replay Regards sajid memon -- -- 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$$ Hi Experts, Urgent
hi Pankaj, Can you please tell what formula you are looking for. Could you please express your query in brief. Thanks, Raj On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I have sorting Name list A-Z in different different coloums ,,, with the help of formulas ,,,attached excelsheet Ex. Aaman Banaran Canmanra Damanran AryanBhuvanCamelDavid *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.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/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$$ Ayush Jain – Microsoft MVP 20 10
hearty congratulations ayush, you really deserve it Infact you are good encyclopedia for us. Have a flamboyant future and delightful moments for ur future endeavors. Regards, Raj On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am proud to announce that I am awarded Microsoft Most Valuable Professional MVP on October 01, 2010 for providing technical expertise in Excel technical communities for past one year. http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx This is a prestigious award from Microsoft given every Quarter to the people who share their deep knowledge, real-world experience, and impartial, objective feedback to help people enhance the way they use technology. My deep thanks to each group member for all your support and contribution to this group. Best regards, Ayush Jain Microsoft MVP -- -- 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
$$Excel-Macros$$ Need Help
Hi friends, Dear Adorable group... please share if any one of us are having excel addin's . Moreover i am having query regarding the excel addin's. Can any one suggest how to create the excel addins i just tried creating this addins . but could not use properly. Thanks for your help in advance. Regards, Raj -- -- 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$$ help needed
Hi Santosh, Send Your sample excel work book attachment for review. i can help you in this concern, i recently got good solution in regards to this concern. my id is rajasekhar.prahar...@gmail.com copy even the group as well. Thanks Regards, Raj On Sun, Sep 12, 2010 at 6:50 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello All, I have a folder in which every person maintains his data in the same format and at the end of the day the data needs to be collected into a new file or an existing file. This collection is done in a manual way can any one help me in collating the data from all the files via vba. The sheet name is Loop and the data is from coloum A to K , rows vary as per data. Regards Santosh santoshkumar.subu...@gmail.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 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
$$Excel-Macros$$ help needed
Hi Santosh, Send Your sample excel work book attachment for review. i can help you in this concern, i recently got good solution in regards to this concern. my id is rajasekhar.prahar...@gmail.com copy even the group as well. Thanks Regards, Raj On Sun, Sep 12, 2010 at 6:50 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello All, I have a folder in which every person maintains his data in the same format and at the end of the day the data needs to be collected into a new file or an existing file. This collection is done in a manual way can any one help me in collating the data from all the files via vba. The sheet name is Loop and the data is from coloum A to K , rows vary as per data. Regards Santosh santoshkumar.subu...@gmail.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 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
$$Excel-Macros$$ Re: pivot data
Hi Ashish, firstly i would like to thank for your prompt reply and assistance. it is very delightful to have such adorable group with such a good guides and query resolvers Thanks for all your help once again. Friends we should thank one and all who created this Groups which is really a good learning campaign to one and all. let us continue to bridge excel queries and learnings which helps us in enriching our potentials simultaneously in turn help others. Regards, Raj On Mon, Aug 30, 2010 at 6:06 AM, ashish koul koul.ash...@gmail.com wrote: On Mon, Aug 30, 2010 at 6:17 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: -- -- 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$$ I have a problem for following worksheet
hello, Pankaj attached is the solution for your query, the formula u depicted or used in that cell is accurate where as all you need to do is to give a space as shown below 9:00 AM Give space like this for both intime and out time then as per attached sheet u will have error free result. Incase of any queries, let me know. Thanks, Raj On Mon, Aug 30, 2010 at 7:03 AM, Pankaj Kumar rajputpanka...@gmail.comwrote: Dear all, When i use the forumulla it shows value pls find attached sheep -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.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 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 Solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book
Hi All, Please assist in this concern i wanted to prepare excel macro where in i can consolidate different excel workbooks data into one excel workbook. so please send me if it is possible through vba macros.if any one of the group is having the script or macro for performing this activity please send to this mail id. rajasekhar.prahar...@gmail.com Regards, Raj -- -- 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
$$Excel-Macros$$ Need advise
Hi All, Myself rajasekher just require your valuable suggestion in this concern, please advise the excel formular where in i can use and the words for the value specified in excel. for example if the value in excel is 80 (numerical) ... i need this 80(numerical) towords as eighty, i mean to convert from figures to words please advise the formula as soon as possible . Thanks for help in advance. Regards, Rajasekhar 9966353510 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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 To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach.
On Fri, Mar 26, 2010 at 1:26 PM, amitabhbo...@hotmail.com wrote: Hi I have this book but will have to find the cd. I will try and send it this weekend Thanks Amitabh -- -Original Message- From: anandydr anand...@gmail.com Date: Thu, 25 Mar 2010 21:19:13 To: MS EXCEL AND VBA MACROSexcel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach. I've got a few ebooks on VBA with MS Excel though not the specific book you mention. If you can use ebooks I can mail them to you. Anand On Mar 24, 12:59 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear Nani Check This Link Outhttp:// www.angelfire.com/biz7/julian_s/julian/julians_macros.htm this link provide the basic vba concept with code. For the book you mension,i have to look it out. Hope it Will Help Happy To Help :) Shyam On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Lovers. Could any one have this book Excel 2007 Power Programming with VBA by John Walkenbach. If not this book, can any one provide me material to learn basic VBA on Excel. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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 To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach.
hi friends, i do have certain vba books will send you shortly. Regards, Raj On Fri, Mar 26, 2010 at 2:37 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: On Fri, Mar 26, 2010 at 1:26 PM, amitabhbo...@hotmail.com wrote: Hi I have this book but will have to find the cd. I will try and send it this weekend Thanks Amitabh -- -Original Message- From: anandydr anand...@gmail.com Date: Thu, 25 Mar 2010 21:19:13 To: MS EXCEL AND VBA MACROSexcel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach. I've got a few ebooks on VBA with MS Excel though not the specific book you mention. If you can use ebooks I can mail them to you. Anand On Mar 24, 12:59 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear Nani Check This Link Outhttp:// www.angelfire.com/biz7/julian_s/julian/julians_macros.htm this link provide the basic vba concept with code. For the book you mension,i have to look it out. Hope it Will Help Happy To Help :) Shyam On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Lovers. Could any one have this book Excel 2007 Power Programming with VBA by John Walkenbach. If not this book, can any one provide me material to learn basic VBA on Excel. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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 To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 subscribers worldwide
$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case
hi all please advise the how to find the row or coloum coloured cell . using excell formula i need to find the cell which is in colour. cell colour should be known . please help me out in this concern Thanks in advance. Raj 9966353510 On 6/26/09, Saravanan Anna sarvananar...@gmail.com wrote: Try =proper() command Regards Saravanan A R On Wed, Jun 24, 2009 at 1:40 PM, Subu mail_to_s...@yahoo.com wrote: Dear List members and XL Gurus I have an XL sheet with a column that looks something like Name_One nAme_two NAME_THREE name_four name_fIVe name SIX name sevEN ...and so on I wish to get them all with the first Character in upper case and the rest all in lower case I.e. something like Name_one Name_two Name_three Name_four Name_five Name six Name seven Thanks in advance Best regards Subu --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---