$$Excel-Macros$$ formula issue
Dear Sir I have downloaded a file from the net but unable to understand the logic in column Q AND R as the file is read only only so can anyone say me how that delay had been calculated and interest is calculated... thanks in advance regards LKM -- 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/d/optout.
$$Excel-Macros$$ Regarding copy of BORDER LINE
Dear Brothers I am facing problem in the matter of Format borders as i have excel sheet containing many rows and columns and i have to give border each column manually so its takes a lot of time. is there any way by which we can copy only border format in other columns as i have tried paste special but that takes format words and no. also and i only want to copy the border line.In the attached sheet i have format the column H and need same border in other columns without changing the format of words and nos. . Thanks in advance Regards L.K.Modi -- 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. BORDER COPY.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Sum on the basis of colour formula
Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- 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. SUM SHEET.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Sum on the basis of colour formula
Dear All I need formula for this particular query so please provide me any any formula instead of macro Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- 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. -- 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. SUM SHEET.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Sum on the basis of colour formula
Brother, There is any formula based on the conditional formating or sumif based in which we can recognise about the colour so i want to know that brother -- Forwarded message -- From: Prince prince141...@gmail.com Date: Thu, Apr 11, 2013 at 5:13 PM Subject: $$Excel-Macros$$ Re: Sum on the basis of colour formula To: excel-macros@googlegroups.com Hi Modi, We cant recognize colours in formula so only solution for the same is macro regards Prince On Thursday, April 11, 2013 3:20:36 PM UTC+5:30, L.K.Modi wrote: Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- 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. -- 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.
$$Excel-Macros$$ due date formula
Dear all can any one suggest any formula so that due date get automatically seven of next month . means if the date is 5-10-12 then due date should be 7-11-12 Regards L.K.Modi -- 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. New Microsoft Office Excel Worksheet (5).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Need Excel Formula for Color Count
Dear Brother, What is this xlsm file as this formula is not working in my excel sheet. On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear ikhan, Pl find attached herewith. Warm Regards, Gawli Anil On Tue, Feb 19, 2013 at 11:47 AM, Imran khan ikha...@gmail.com wrote: Hi, Can anyone help me count cell by color? I have attached sheet which i need to count all green color. regards, Imran Khan -- 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, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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. -- 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.
$$Excel-Macros$$ Formula for Loan amount
Dear All I want to Know about the formula to calculate the installment amount: If loan amount is : 10/- Years: 3Years Rate of Interest : 14.50% P.A. Mode of Insallment :Monthly. 1)What will be the installment amount . Pls suggest by formula 2) If we Know the installment amount and rate of interst is not known to us then how can we calculate the Interest rate.? 3) If we Know both about the Rate and Insallment then how can i prepare the loan chart for years to know the total interest. Kindly help me. -- 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.
Fwd: $$Excel-Macros$$ Formula for Loan amount
Brother I want to know about the formula with the data i had provided so pls give exact solution. -- Forwarded message -- From: pankaj sangotra psangotr...@gmail.com Date: Tue, Feb 19, 2013 at 11:50 AM Subject: Re: $$Excel-Macros$$ Formula for Loan amount To: excel-macros@googlegroups.com Hello Bro.. if u are using Excel 2007 it is bulid template named Loan Amortization.. To get this template : Go to Home page : New: Installed template and u will get what you are looking for .. Hope this is helpfull to U.. Enjoy ur day.. Thanks Pankaj Sangotra On Tue, Feb 19, 2013 at 6:09 AM, L.K. Modi ca.mod...@gmail.com wrote: Dear All I want to Know about the formula to calculate the installment amount: If loan amount is : 10/- Years: 3Years Rate of Interest : 14.50% P.A. Mode of Insallment :Monthly. 1)What will be the installment amount . Pls suggest by formula 2) If we Know the installment amount and rate of interst is not known to us then how can we calculate the Interest rate.? 3) If we Know both about the Rate and Insallment then how can i prepare the loan chart for years to know the total interest. Kindly help me. -- 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. -- 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. -- 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.
$$Excel-Macros$$ size of mail
Dear all as i m uploading file containing size of 25 mb at gmail to send but its shows error so suggest how can we short the size of a folder. -- 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$$ size of mail
sir thats a long song dedicated to someone. is this possible with yahoo mail. On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, Gmail is not supported file size 25 MB. This facility only yahoo mail only. Option is attach large file. but this file only One month valid only. Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear all as i m uploading file containing size of 25 mb at gmail to send but its shows error so suggest how can we short the size of a folder. -- 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$$ size of mail
sir thats a song file.. On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: how can we understand what file u r attaching dude... just elaborate and explain... On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi ca.mod...@gmail.com wrote: sir thats a long song dedicated to someone. is this possible with yahoo mail. On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, Gmail is not supported file size 25 MB. This facility only yahoo mail only. Option is attach large file. but this file only One month valid only. Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear all as i m uploading file containing size of 25 mb at gmail to send but its shows error so suggest how can we short the size of a folder. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
Re: $$Excel-Macros$$ Split text in cell
Dear All, Its good to see this resolution but can anyone explain this in simple way Regards Modi On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 dguille...@gmail.com wrote: Option Explicit Sub getmiddleSAS() Dim c As Range Dim fs As Long Dim ls As Long For Each c In Range(a2:a10) c = Application.Trim(c) fs = InStr(c, ) ls = InStrRev(c, ) c.Offset(, 1) = Mid(c, fs, ls - fs) Next c Columns(b).AutoFit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* NRao Mynampati ml.narasimha...@gmail.com *Sent:* Wednesday, March 21, 2012 4:00 AM *To:* excel-macros@googlegroups.com *Cc:* Dilip Pandey dilipan...@gmail.com *Subject:* $$Excel-Macros$$ Split text in cell Hi Team, How to remove a words left text and right text of reference Please refer attachment. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ how can i download files from group
Dear Sir, Earlier i was able to download file from the excel group. I want to download some useful files from there . can any one send me that link. Regards LKModi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Regarding Excel formulas and addins
Dear Members I want to know about the new advanced excel formulas and addins. Please send me some useful links or files by which i can know about that by downloading all that.Specially if those links also having finance related funcion or addins that will great for me also. Thanking you Regards LKModi -- -- 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$$ help regarding date formula
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS REGARDS LKMODI On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi ca.mod...@gmail.com wrote: Dear Members, Me attaching a sheet which relates to Excise duty payment.The result should be 5 of the next of the month of Invoice.We are currently doing it manually. But is there any formula by which we can do that fast and in less time. Hope you wil surely help me. Regards LKModi -- -- 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$$ Help regarding bank statment
Dear Members, Thanks for your valuable support. I have an querry in which i have to check interest calculation for banks. Me attaching a sheet in which column A have date that is in different format. and in column B the balance as on the respective dates. As the bank charges interest on the closing balance for particular dates. So there are many balances as on the same date. What i need first that the date should be in format of dd-mmm-yy and secondly like there are many balances of 1st june so i need only the closing balance of 1st june and so on. it means last line that is in 1st june this i have to do for all dates. can anyone help me as this is more time taking without proper direction. Thanks in advance Regards LKModi -- -- 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 test sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Sum based on conditional formatting
Dear Members I have a query regarding conditional formating: 1. I have a sheet in which some cells containg amounts out of those some cells are coloured. Is there any way to coloured only those coloured cells. One way i have by filter on the basis of colour but everytime to use that is hectic so can we use any formula on that. I am attaching herewith that sheet for ur reference. Thanks in advance regards LKModi -- -- 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 CONDITIONAL FORMATING.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Regarding LME and Commodoties Updation
Dear Members, with reference to the above dear member i want a excel sheet. Earlier i have downloaded a sheet that updates automatically bse and nse prices. Similary is there any way by which when i would run macro the LME prices and Commodities Prices update automatically. May be its a challenging job because i have earlier asked ther query but no reply was there. But group having have people with master mind. Hope they wil solve this querry at earliest. Thanking You Regards LKModi -- -- 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$$ EXCEL FILE CONTAINING IP ADDRESS
Dear Group Members I need an excel file in wihch by running macro we can see our IP ADDRESS. Please provide me that file by which we can know the IP address of our System Regards LKModi -- -- 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$$ work books name in a folder
Dear GroupMembers, I want to list the file name that are in closed folder .Means any way by which i can get the files or workboooks name that are in a particular folder. Thanks in advance Regards LKModi -- -- 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$$ work books name in a folder
thanks a lot setiyowati.devi the files is working and its very good regrds LKModi On Fri, Jul 1, 2011 at 4:59 AM, STDEV(i) setiyowati.d...@gmail.com wrote: please check the attached file, and see if it helps '- Sub ListFilesNameOfSpecifiedFolder() '-- ' siti Vi / Excel FileName List of a folder ' ext: *.xl?? ' jakarta, 21 april 2008 '-- Dim fBrowser As BrowseInfo Dim PathDirNm As String Dim szTitle As String Dim lpIDList As Long Dim FSO As Object Dim FOL As Object Dim MyFileAs Object Dim r As Integer 'select a folder via BrowseInfo)-- szTitle = ©tv: Please Select a Folder... With fBrowser .hWndOwner = Application.Hwnd .lpszTitle = lstrcat(szTitle, ) .ulFlags = BI_RetuOnlyFSDir + BI_NoGoBelowDomain End With lpIDList = SHBrowseForFolder(fBrowser) If (lpIDList) Then PathDirNm = Space(Max_Path) SHGetPathFromIDList lpIDList, PathDirNm PathDirNm = Left(PathDirNm, InStr(PathDirNm, vbNullChar) - 1) Range(D2) = PathDirNm ' for info only in sheet End If ' fileName list to sheet-- On Error GoTo Akhir Set FSO = CreateObject(Scripting.FileSystemObject) Set FOL = FSO.GetFolder(PathDirNm).Files Range(D6) = . Range(C5).CurrentRegion.Offset(1, 0).ClearContents ' - loop thru all file in files collection For Each MyFile In FOL If LCase(Right(MyFile.Name, 4)) Like *xl* Then r = r + 1 Range(B6).Cells(r, 1) = r ' - get the name and write to cell Range(B6).Cells(r, 2) = MyFile.Name Range(B6).Cells(r, 4) = MyFile.Size / 1024 End If Next Akhir: End Sub '-- On Thu, Jun 30, 2011 at 3:10 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear GroupMembers, I want to list the file name that are in closed folder .Means any way by which i can get the files or workboooks name that are in a particular folder. Thanks in advance Regards LKModi -- -- 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$$ How to send mail with excel
this add in is not working On Wed, Mar 30, 2011 at 10:42 AM, ashish koul koul.ash...@gmail.com wrote: try this addin see if it helps http://www.rondebruin.nl/mail/add-in.htm On Tue, Mar 29, 2011 at 8:02 PM, shariq khan shariqcoo...@gmail.comwrote: Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and some are on CC. I also need to add the below table in the body of the mail looks like the below example _ Hi, Please find the attached score if the candidates *Name* *Marks1* *Marks2* *sum* *SK* *75* *75* *150* *RL* *25* *25* *50* *NM* *85* *85* *170* *HL* *25* *25* *50* Please let me know if you have any concerns Thanks Shariq _ And we have dynamic marks after the logic of the code and filter criteria. also i need to send an excel sheet as an attachment(saved on some other location) Please help me. Thanks, -- -- 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
$$Excel-Macros$$ insert a blank row
Dear all can any one help me in inserting black rows after line no.5 like 5 then blank row then 6 and then again blank row and again regards LKModi -- -- 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$$ Fwd: insert a blank row
Dear Sir I dont know much about macros hence pls send in the given file On Wed, Dec 8, 2010 at 1:58 PM, ashish koul koul.ash...@gmail.com wrote: try this see if it helps Sub rowinsertcola() Dim i, j, k, z, h As Long j = 1 z = 1 Range(a65356).Select Selection.End(xlUp).Select k = ActiveCell.Row For i = 5 To k + z Step 1 If (i Mod j = 0) Then ActiveSheet.Cells(i + z, 1).Select Selection.EntireRow.Insert z = z + 1 End If Next i End Sub On Wed, Dec 8, 2010 at 1:34 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear all can any one help me in inserting black rows after line no.5 like 5 then blank row then 6 and then again blank row and again regards LKModi -- -- 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
$$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR
IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR. PLEASE SUGGEST ME. AWAITING FOR YOUR RESPONSE. REGARDS AMIT -- -- 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$$ Excel Utilities
pls send some new utility and asap and power utils are older more than 1 years if u can pls send some new utilities we all be greatful to you. thanks in advance Regards LKModi On Sat, Nov 13, 2010 at 3:44 PM, Vishal Angre vishal.k.an...@gmail.comwrote: use this addin for all excel version http://www.asap-utilities.com/download-asap-utilities.php for user help User Guide will show you what you can do with ASAP Utilities http://www2.asap-utilities.com/download/f/ASAP_Utilities_User_Guide.pdf Thanking You Vishal K. Angre -- -- 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$$ UPDATION OF LME (LONDON METAL EXCHANGE PRICES)
Dear All Earlier i had got an excel file in which bse prices are automatically updated like that way i need to track lme prices. can any one help on this . Regards LKModi -- -- 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$$ Radio button gets protected
Dear all As per your mail i am unable to find what is the radio buttons. as i m new to excel. can any one suggest the entire procedure regarding these radio buttons and use. Thanks in advance hope i wil get the reply fast. Regards LKModi On Sun, Jun 27, 2010 at 9:34 PM, ayush jain jainayus...@gmail.com wrote: Hi Niraj, I have protected the entire sheet keeping the required cells and radio buttons unprotected. Hope this helps. Attached is the sheet for your reference. Let us know if any further help is required. Thanks and Best regards, Ayush Jain On Sun, Jun 27, 2010 at 4:11 PM, KothariJewelry.com cont...@kotharijewelry.com wrote: Dear All, Thanks for the guidance till now. I am encountering this small problem over the radio buttons getting protected which i dont want to. 1. I want to hide all the formulas on the sheet which i am using so i used the protech sheet with hide option. 2. I want to provide only B14-B18 and E6 as an editable option so i am using protect sheet with lock option. But, now i am encountering problem over the selction of radio buttons also, since they are getting protected the user doesnt have any option to select the karat type which he wants to. Kindlly rectify the sheet mail me Thanks Niraj On Sat, Jun 26, 2010 at 9:28 PM, ayush jain jainayus...@gmail.comwrote: Hi Niraj, I have added three radio buttons in row 4 to select the karat type. The value of cell D5 will change as per the radio button selection. Do not delete the value of cell D5. I have also modified the formula in D18 to change value on the basis of selection. Please have a look at file and let us know if you need any further help. Best regards, Ayush Jain Group Manager. On Sat, Jun 26, 2010 at 6:55 PM, KothariJewelry.com cont...@kotharijewelry.com wrote: Dear All, I am herewith attaching a excel worksheet. Can someone help to me to provide a radio button or select option in the sheet which the customer selects and depending upon the option he selects the final pricing is displayed for gold coins, IF customer selects 24 karat = 1900, then D18=C14*B5 IF customer selects 22 karat = 1748, then D18=C14*D5 IF customer selects 18 karat = 1900, then D18=C14*F5 Kindly revert Thanks Niraj www.kotharijewelry.com On Thu, Jun 24, 2010 at 10:43 PM, Paul Schreiner schreiner_p...@att.net wrote: What you do is select all cells in the sheet (use the header cell in the top left) Right-click and select Format Cells On the Protection tab, make sure locked is selected hit OK. Now go through and select the cells you want available for editing,right-clickFormat Cells. and REMOVE the checkbox from the Locked selection on the Protection tab. Now, for this to take affect, you need to protect the document. You don't NEED to set a password, but I would recommend it. (make it something you'll remember!) let me know if you need more assistance. P -- *From:* KothariJewelry.com cont...@kotharijewelry.com *To:* excel-macros@googlegroups.com *Sent:* Thu, June 24, 2010 9:49:27 AM *Subject:* $$Excel-Macros$$ Uneditable Cells Dear All, I want to prepare an excel calculator , in which some cells will have definite values which the customer can't change once they download it from our website, some cells should have the editable option where the customer can enter values according to his requirements. So can someone explain me how to make uneditable/editable cells in a single excel sheet. Regards Niraj -- -- 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
$$Excel-Macros$$ Radio button gets protected
Dear all As per your mail i am unable to find what is the radio buttons. as i m new to excel. can any one suggest the entire procedure regarding these radio buttons and use. pls ignore the mail if i have already sent the mail. I want to know the step by step procedure regarding these buttons Thanks in advance hope i wil get the reply fast. Regards LKModi On Sun, Jun 27, 2010 at 9:34 PM, ayush jain jainayus...@gmail.com wrote: Hi Niraj, I have protected the entire sheet keeping the required cells and radio buttons unprotected. Hope this helps. Attached is the sheet for your reference. Let us know if any further help is required. Thanks and Best regards, Ayush Jain On Sun, Jun 27, 2010 at 4:11 PM, KothariJewelry.com cont...@kotharijewelry.com wrote: Dear All, Thanks for the guidance till now. I am encountering this small problem over the radio buttons getting protected which i dont want to. 1. I want to hide all the formulas on the sheet which i am using so i used the protech sheet with hide option. 2. I want to provide only B14-B18 and E6 as an editable option so i am using protect sheet with lock option. But, now i am encountering problem over the selction of radio buttons also, since they are getting protected the user doesnt have any option to select the karat type which he wants to. Kindlly rectify the sheet mail me Thanks Niraj On Sat, Jun 26, 2010 at 9:28 PM, ayush jain jainayus...@gmail.comwrote: Hi Niraj, I have added three radio buttons in row 4 to select the karat type. The value of cell D5 will change as per the radio button selection. Do not delete the value of cell D5. I have also modified the formula in D18 to change value on the basis of selection. Please have a look at file and let us know if you need any further help. Best regards, Ayush Jain Group Manager. On Sat, Jun 26, 2010 at 6:55 PM, KothariJewelry.com cont...@kotharijewelry.com wrote: Dear All, I am herewith attaching a excel worksheet. Can someone help to me to provide a radio button or select option in the sheet which the customer selects and depending upon the option he selects the final pricing is displayed for gold coins, IF customer selects 24 karat = 1900, then D18=C14*B5 IF customer selects 22 karat = 1748, then D18=C14*D5 IF customer selects 18 karat = 1900, then D18=C14*F5 Kindly revert Thanks Niraj www.kotharijewelry.com On Thu, Jun 24, 2010 at 10:43 PM, Paul Schreiner schreiner_p...@att.net wrote: What you do is select all cells in the sheet (use the header cell in the top left) Right-click and select Format Cells On the Protection tab, make sure locked is selected hit OK. Now go through and select the cells you want available for editing,right-clickFormat Cells. and REMOVE the checkbox from the Locked selection on the Protection tab. Now, for this to take affect, you need to protect the document. You don't NEED to set a password, but I would recommend it. (make it something you'll remember!) let me know if you need more assistance. P -- *From:* KothariJewelry.com cont...@kotharijewelry.com *To:* excel-macros@googlegroups.com *Sent:* Thu, June 24, 2010 9:49:27 AM *Subject:* $$Excel-Macros$$ Uneditable Cells Dear All, I want to prepare an excel calculator , in which some cells will have definite values which the customer can't change once they download it from our website, some cells should have the editable option where the customer can enter values according to his requirements. So can someone explain me how to make uneditable/editable cells in a single excel sheet. Regards Niraj -- -- 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
Re: $$Excel-Macros$$ Index match multiple
Dear all Group Members I have joined this group for my development and i have learnt a lot from here. Really this is group is one of the best groups to learn for going ahead. I m an accounting person and i have to give my top management many type of reports like fund position,debtors,creditors,sales,purchase etc.on daily mis basis. Does any body have such format of reports in excel so that i can prepare reports more logically and efficiently in less time. I know that here are many big person have such reports pls help me and provide the formats of such reports containg linking and formulas. So that i can get a chance for my future. Hope all will help me.The example of reports are balance sheet ,profit and loss,debtors and creditors . i want to combine all this in a combine sheet . I want to also make these sheets traceable. means those persons who have accessed that sheeet and what changes they have made.Now i think u can understand what i need i need some great reports formats like connection sheet. etc. thanks in advance hope the group will help me as soon as possible. Regards LKModi -- -- 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$$ Re: popup on s sheet ?
Dear Sir May i know how u do this step by step.I am a great fan of this group. because in the sample sheet i m unable to know the process.Hope i will get answer shortly Regards LKModi On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Swapnil, Your post is an amsing one. Thanks Alfred, There are two things to the solution provided by Swapnil, 1) There is a label on the sheet1 2) There is data on the sheet which makes the graph If you go into design mode of excel and click over the data, you will be able to select a invisible Label, just move it at a side and change your data I hope this will solve your query Harry On Jun 7, 8:19 pm, Alfred WALLACE jos...@gmail.com wrote: Hi Swapnil (nice name !! where is it from ?) Your soluce works fine ! thx a lot ! I have à second question, do you think is it possible to affect the graphic to a shape ? I have this question because, with this solution, I can't modify the numbers of the graphic. So I think I need 2 areas, the first one, will be the real tabular numbers, and the second, juste an area to detect mouse movement over it. I'm so sorry because my english is horrible thanks again. José (from france) On 4 juin, 07:59, Swapnil Palande swapnilp1...@gmail.com wrote: Hi, It is possible to set visibility of chart. You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following changes in that code: Instead of ActiveSheet.Shapes(AutoShape 3).Visible = False use ActiveSheet.ChartObjects(Chart 1).Visible = False Attached is the excel for your reference. Regards, Swapnil. On Thu, Jun 3, 2010 at 8:39 PM, Alfred WALLACE jos...@gmail.com wrote: Thanks a lot KAMAL !!! your solution works fine, but, It would be possible to obtain the same result with a dynamic graph ? I'm testing that solution with de MouveMove event of a shape : like that :http://cjoint.com/data/fFrTGZSr2t.htm Do you think is it possible tu activate visibility (true or false) of an object graph ? thanks again for you help !! José from France. On 1 juin, 17:15, kamal shah kamal...@gmail.com wrote: Its Possible !!! Here is a solution what you are looking. Add a Picture to an Excel Comment 1. Right-click the cell which contains the comment. 2. Choose *Show/Hide Comments*, and clear any text from the comment. 3. Click on the border of the comment, to select it. 4. Choose *Format*|*Comment* 5. On the *Colors and Lines* tab, click the drop-down arrow for *Color*. 6. Click *Fill Effects* 7. On the picture tab, click *Select Picture* 8. Locate and select the picture 9. To keep the picture in proportion, add a check mark to *Lock Picture Aspect Ratio* 10. Click *Insert*, click OK, click OK Cheers KAMAL -- ------ 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 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 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 Hide and Display Chart using VBA.xls 37KAfficherTélécharger- Hide quoted text - - Show quoted text - -- -- 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 @
Re: $$Excel-Macros$$ Re: popup on s sheet ?
Dear Sir (Regarding Pop up on a sheet) May i know how u do this step by step.I am a great fan of this group. because in the sample sheet i m unable to know the process.Hope i will get answer shortly Regards LKModi On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Swapnil, Your post is an amsing one. Thanks Alfred, There are two things to the solution provided by Swapnil, 1) There is a label on the sheet1 2) There is data on the sheet which makes the graph If you go into design mode of excel and click over the data, you will be able to select a invisible Label, just move it at a side and change your data I hope this will solve your query Harry On Jun 7, 8:19 pm, Alfred WALLACE jos...@gmail.com wrote: Hi Swapnil (nice name !! where is it from ?) Your soluce works fine ! thx a lot ! I have à second question, do you think is it possible to affect the graphic to a shape ? I have this question because, with this solution, I can't modify the numbers of the graphic. So I think I need 2 areas, the first one, will be the real tabular numbers, and the second, juste an area to detect mouse movement over it. I'm so sorry because my english is horrible thanks again. José (from france) On 4 juin, 07:59, Swapnil Palande swapnilp1...@gmail.com wrote: Hi, It is possible to set visibility of chart. You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following changes in that code: Instead of ActiveSheet.Shapes(AutoShape 3).Visible = False use ActiveSheet.ChartObjects(Chart 1).Visible = False Attached is the excel for your reference. Regards, Swapnil. On Thu, Jun 3, 2010 at 8:39 PM, Alfred WALLACE jos...@gmail.com wrote: Thanks a lot KAMAL !!! your solution works fine, but, It would be possible to obtain the same result with a dynamic graph ? I'm testing that solution with de MouveMove event of a shape : like that :http://cjoint.com/data/fFrTGZSr2t.htm Do you think is it possible tu activate visibility (true or false) of an object graph ? thanks again for you help !! José from France. On 1 juin, 17:15, kamal shah kamal...@gmail.com wrote: Its Possible !!! Here is a solution what you are looking. Add a Picture to an Excel Comment 1. Right-click the cell which contains the comment. 2. Choose *Show/Hide Comments*, and clear any text from the comment. 3. Click on the border of the comment, to select it. 4. Choose *Format*|*Comment* 5. On the *Colors and Lines* tab, click the drop-down arrow for *Color*. 6. Click *Fill Effects* 7. On the picture tab, click *Select Picture* 8. Locate and select the picture 9. To keep the picture in proportion, add a check mark to *Lock Picture Aspect Ratio* 10. Click *Insert*, click OK, click OK Cheers KAMAL -- ------ 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 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 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 Hide and Display Chart using VBA.xls 37KAfficherTélécharger- Hide quoted text - - Show quoted text - -- -- 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 :
Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)
sorry did not get select the funcion and presss tab can u expalin this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Select the function and press tab. Thanks Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael mich...@michaelkwak.net wrote: I posted a picture of what I'm trying to discover: http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI Does anyone know of a shortcut to select from the drop down of suggested terms when creating a formula? (i.e. what would I need to press on my keyboard to finish populating the chain named range into my formula without typing out the thing?) Currently, I know you need to double click with your mouse to accomplish this; however, it's cumbersome when updating complex array formulas. Thanks so much for yoour help in advance! Michael -- -- 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 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 -- -- 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 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 -- -- 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 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
Re: $$Excel-Macros$$ Pivot Problem
Dear all group Members, I am also a member of your very good group. I am very pleased to be in this group becasue i have learned a lot of excel from here. i would like to mention that in these days there is no mail i had received that contains attachment file from where i can understand the problem and solution so please i request that do not use personal mails and use group id and post all querries and solution here only so that persons like me those are new to excel can understand the problem and solution. Actually i am new to excel and learning the excel this group helped me a lot to understand new features. please send all problem and their solution with the attachment file I will be very thankful to the group Thanks Regards LKModi On Mon, Apr 12, 2010 at 7:11 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data which on application of a filter gives me NP and Sales amount for different types (Huge, Big, Medium, Small) of branches. *Required:* Now what I want to do is to apply two different filters on two different columns which fall under the same Pivot table. Is it possible, or am I asking too much from excel. I know I can construct a seperate table for both NP and sales, but the issue is I am trying to automate the process and if I make seperate account heads for seperate files, well, I will be ending up making atleast 50 Pivot tables in a file which has already crossed 200 MB. *In Short:* *HELP* ** Thanks.. -- -- 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 -- -- 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$$ Pivot Problem
Dear all group Members, I am also a member of your very good group. I am very pleased to be in this group becasue i have learned a lot of excel from here. i would like to mention that in these days there is no mail i had received that contains attachment file from where i can understand the problem and solution so please i request that do not use personal mails and use group id and post all querries and solution here only so that persons like me those are new to excel can understand the problem and solution. Actually i am new to excel and learning the excel this group helped me a lot to understand new features. please send all problems and their solutions in the attachement file that should also be in excel. so that we can understand the problem and solutions I will be very thankful to the group Thanks Regards LKModi On Mon, Apr 12, 2010 at 7:11 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data which on application of a filter gives me NP and Sales amount for different types (Huge, Big, Medium, Small) of branches. *Required:* Now what I want to do is to apply two different filters on two different columns which fall under the same Pivot table. Is it possible, or am I asking too much from excel. I know I can construct a seperate table for both NP and sales, but the issue is I am trying to automate the process and if I make seperate account heads for seperate files, well, I will be ending up making atleast 50 Pivot tables in a file which has already crossed 200 MB. *In Short:* *HELP* ** Thanks.. -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Need Passward Cracker
may i know what is the use of this password cracker Actually me new to this group. Pls dont take otherwise this group is very good and i have learned many things from here that i thought can not be possible. Thanks for ur much good support thanks to all member of group Regards LKModi On Fri, Apr 9, 2010 at 10:33 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear Open this add ins and then your protected workbook. Follow the instruction. Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:09 AM, Jai jaihumtu...@gmail.com wrote: Dear All, Can you Give me VBA Passward Cracker, -- Thanks For Mail. -- -- 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 -- 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, reply using 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 http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Network days with a tweak
Dear Aindril As i m seeing this mail there is no link at all in your mail. Is there any way to calculate networking days Regards LKModi On Wed, Apr 7, 2010 at 2:20 PM, Aindril De aind...@gmail.com wrote: Hi Roopesh, The process given in the link below will be a good start. Regards, Aindril On Wed, Apr 7, 2010 at 12:29 PM, RK roopesh.ka...@gmail.com wrote: Hi Champs, I am looking for a formula or an add in that works like networkdays, the only difference being that I want saturday to be included as a working day, rest everything to remain same as Networkdays. Regards, Roopesh Kapur -- -- 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. -- -- 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 -- -- 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
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards LKmodi On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- 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 -- 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, reply using 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 http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- 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 -- 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, reply using 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 http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String
Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi 9309243685 On 3/30/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear All, Attached is the macro to extracting the numeric value from alphanumeric string. -- 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 http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String
Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi 9309243685 On 3/30/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Dear All, Attached is the macro to extracting the numeric value from alphanumeric string. -- 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 http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.