Re: $$Excel-Macros$$ $$Excel Macros$$ Need to automate some data
hi selva raj Source Sheet format is incomplete, missing date column can you add more data to your sample file *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may contain confidential, proprietary or legally privileged information intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents either partly or completely. Before opening any attachments please check them for viruses and defects." On Sun, Jun 24, 2018 at 9:27 AM, selva raj wrote: > Dear team, > > I have attached my source excel sheet. > > My workbook has the two sheet. One is Sourcesheet and another one is > Result sheet. > > Requirements. > > 1. Need to copy and paste the value from source sheet to Result sheet once > i clicked the command button like attached sheet using VBA iteration > > 2. And each employee data should be automatically updated date-wise once i > clicked the command button. > > Please help on this. > > Regards, > Selvaraj M > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Exclude #N/A & Sumif excel formula
HI atul check this solution *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may contain confidential, proprietary or legally privileged information intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents either partly or completely. Before opening any attachments please check them for viruses and defects." On Sat, Apr 28, 2018 at 2:16 PM, amar takale wrote: > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. ankur solution aSumif.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ No. Of sundays between dates
Chandru please check this solution *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may contain confidential, proprietary or legally privileged information intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents either partly or completely. Before opening any attachments please check them for viruses and defects." On Tue, Apr 3, 2018 at 11:48 PM, AK wrote: > Chandru, > > Please refer the sheet. > > Regards, > Sarvesh > > On Tue, Apr 3, 2018 at 7:46 PM, chandrashekarb.xls < > chandrashekarb@gmail.com> wrote: > >> Hello, >> >> How to know no. Of sundays between dates? >> >> Regards, >> Chandru >> >> >> >> Sent from my Samsung Galaxy smartphone. >> >> -- >> 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 https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Regards, > > AK > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. ankur Sol Sunday Count.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Excel Formula - Help needed
hi Kaushik use this one =IF(C3>=VLOOKUP(D3,$F$13:$G$16,2,0),"yes","no") excel sheet is attached for your reference *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may contain confidential, proprietary or legally privileged information intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents either partly or completely. Before opening any attachments please check them for viruses and defects." On Sat, May 26, 2018 at 2:00 PM, Rabindra Thapa wrote: > hope this attached fulfill your requirement. > > *Regards,* > > > > *For quick responds click here for Message * > > On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA > wrote: > >> Hi All, >> >> Attached is the excel file which I am referring for help. >> >> Background: Daily basis there are some transactions getting created and >> are either approved or pending or rejected. For the one's which are pending >> we want to build a tracker which once data is dumped it will show whether >> follow up needed or not basis some criteria. >> >> Details:- >> 1. The criteria is as below:- >> If cell in Column D has "Mr A" then after 3 business days followup need >> to be done, if "Mr B" then after 2 days follow up need to be done, if "Mr >> C" there then after 1 day follow up need to be done, if "Mr D" then 2 days >> after which follow up need to be done >> 2. Column C contains formula which shows from current date how many days >> the transaction is sitting for approval. Problem here is it is taking into >> account all days but I want only business days which should exclude >> weekends ie. Saturday and Sunday >> 3. I want formula to give the same result as shown in Column E. >> >> Please do the needful. >> >> Regards, >> Kaushik Savla >> >> >> >> >> -- >> 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 https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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.
Re: $$Excel-Macros$$ Excel Table to HTML table
On Sep 9, 2016 8:46 AM, "Devendra Sahay" wrote: > Hi Experts, > > Am working for company in which i have to convert an excel table in HTML > table format & as am not from the technical background then I have to > struggle with existing templates to modify them as per new requirement. > I found a code on google, which is giving as desired output but I want few > modifications in that OR someone can fix the shared code with predefined > HTML parameters. > > Scenario. > > I have mentioned the header in excel sheet, which may vary as per user & > language. and the table which i have shared in column A would be the > respective Parameter & Column B would the detail but in column B, there > could be multiple rows for the same parameter. If the respective row is > greater that 1 then it will appear on webpage as shared snapshot. > Then rest of things will run as similar process, code will check > respective header & the value in table then it will count the rows for that > parameter. > > Code should run only for selected range not the entire sheet. > > Guys, If any one can help me on this code, would be much appreciated > > @paul, You are the one guy, who can do anything with excel. Am waiting for > your suggestions on this concern. > > -- > > With Regards !!! > Devendra > > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/
Re: $$Excel-Macros$$ Very Urgent
hi, i need your help on one more thing ...i somehow seek trough and able to see vba project code but there is a click on refresh button. While i cannot see code behind that button. there are three xlam files which also have some passwords Please help me again..i know i am asking too much of favors.. Please help me out On Fri, Jun 20, 2014 at 9:29 AM, Ankur Gupta wrote: > ok thank so much for your prompt replies and readiness to help. I really > appreciate that. > > well i need to fetch data from an api call and then use some mathematical > functions to dynamically perform some operation son few columns fetched. > Can you send me something like this type as an example or something ? > > > On Fri, Jun 20, 2014 at 9:26 AM, Vaibhav Joshi wrote: > >> Dear Ankur >> >> In that case you will be required to take help of person who created this >> Macro or create macro on your own. >> >> We can assist you in developing new macro but not breaking it. >> >> Cheers!! >> On Jun 20, 2014 9:48 PM, "Ankur Gupta" wrote: >> >>> yes it is prompting me for password. I tried opening in notepad and >>> tried to find gpd n ol but it crashes the workbook. Please help me out? >>> >>> >>> On Fri, Jun 20, 2014 at 12:21 AM, Vaibhav Joshi wrote: >>> >>>> hi >>>> >>>> You can pres Alt + F11 to go in to VBE mode, then press Ctr + R to >>>> view project explorer on left side. >>>> >>>> Browse for your WB name (this will be like "VBA Project(workbook name)" >>>> and click on plus sign to expand it. If it is not protected then you will >>>> be able to see code, if it is protected then you will be prompted for PWD. >>>> >>>> Cheers!! >>>> >>>> >>>> On Fri, Jun 20, 2014 at 12:24 PM, Ankur Gupta >>>> wrote: >>>> >>>>> hi vaibhav, >>>>> >>>>> Could you please illustrate as in what you want to tell me? The >>>>> workbook is not protected but the button , i cant see the code even in >>>>> design mode. It remains clickable even after entering the design mode. Is >>>>> there any way i can check the code for macro written? Please advise me >>>>> better. I have very less idea about this. >>>>> Please help me >>>>> >>>>> >>>>> >>>>> On Thu, Jun 19, 2014 at 11:38 PM, Vaibhav Joshi wrote: >>>>> >>>>>> Hi >>>>>> >>>>>> Is macro module protected? if you can open WB then its not diff. to >>>>>> unprotect VBA module. >>>>>> >>>>>> You can google it around to know how to unprotect it. Pl note rule 3 >>>>>> "Don't post questions regarding breaking or bypassing any security >>>>>> measure." >>>>>> >>>>>> Cheers!! >>>>>> >>>>>> >>>>>> On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta >>>>>> wrote: >>>>>> >>>>>>> I am new to excel and absolutely a novice to vb. I have been given a >>>>>>> task to write macros code in vba in excel. The macro code is already >>>>>>> there >>>>>>> but nobody knows the password. So the button even in design mode doesnot >>>>>>> show view code. I just want to view to code behind. I cant pass the >>>>>>> sheet >>>>>>> as it can lead to violations on company side. Can anyone please help me. >>>>>>> Its really very very urgent and any sort of help will be great for me. I >>>>>>> have made the file unprotected but still i cannot view the code. Please >>>>>>> help me. >>>>>>> >>>>>>> Regards, >>>>>>> anky >>>>>>> >>>>>>> -- >>>>>>> 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 >>>>>>> Advi
Re: $$Excel-Macros$$ Very Urgent
ok thank so much for your prompt replies and readiness to help. I really appreciate that. well i need to fetch data from an api call and then use some mathematical functions to dynamically perform some operation son few columns fetched. Can you send me something like this type as an example or something ? On Fri, Jun 20, 2014 at 9:26 AM, Vaibhav Joshi wrote: > Dear Ankur > > In that case you will be required to take help of person who created this > Macro or create macro on your own. > > We can assist you in developing new macro but not breaking it. > > Cheers!! > On Jun 20, 2014 9:48 PM, "Ankur Gupta" wrote: > >> yes it is prompting me for password. I tried opening in notepad and tried >> to find gpd n ol but it crashes the workbook. Please help me out? >> >> >> On Fri, Jun 20, 2014 at 12:21 AM, Vaibhav Joshi wrote: >> >>> hi >>> >>> You can pres Alt + F11 to go in to VBE mode, then press Ctr + R to view >>> project explorer on left side. >>> >>> Browse for your WB name (this will be like "VBA Project(workbook name)" >>> and click on plus sign to expand it. If it is not protected then you will >>> be able to see code, if it is protected then you will be prompted for PWD. >>> >>> Cheers!! >>> >>> >>> On Fri, Jun 20, 2014 at 12:24 PM, Ankur Gupta wrote: >>> >>>> hi vaibhav, >>>> >>>> Could you please illustrate as in what you want to tell me? The >>>> workbook is not protected but the button , i cant see the code even in >>>> design mode. It remains clickable even after entering the design mode. Is >>>> there any way i can check the code for macro written? Please advise me >>>> better. I have very less idea about this. >>>> Please help me >>>> >>>> >>>> >>>> On Thu, Jun 19, 2014 at 11:38 PM, Vaibhav Joshi wrote: >>>> >>>>> Hi >>>>> >>>>> Is macro module protected? if you can open WB then its not diff. to >>>>> unprotect VBA module. >>>>> >>>>> You can google it around to know how to unprotect it. Pl note rule 3 >>>>> "Don't post questions regarding breaking or bypassing any security >>>>> measure." >>>>> >>>>> Cheers!! >>>>> >>>>> >>>>> On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta >>>>> wrote: >>>>> >>>>>> I am new to excel and absolutely a novice to vb. I have been given a >>>>>> task to write macros code in vba in excel. The macro code is already >>>>>> there >>>>>> but nobody knows the password. So the button even in design mode doesnot >>>>>> show view code. I just want to view to code behind. I cant pass the sheet >>>>>> as it can lead to violations on company side. Can anyone please help me. >>>>>> Its really very very urgent and any sort of help will be great for me. I >>>>>> have made the file unprotected but still i cannot view the code. Please >>>>>> help me. >>>>>> >>>>>> Regards, >>>>>> anky >>>>>> >>>>>> -- >>>>>> 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 s
Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code
hi Paul, the person who wrote the code has left the company and now i need the code behind in order to work further. I am not violating any policies dear. Please help me out if you could. please On Fri, Jun 20, 2014 at 4:17 AM, Paul Schreiner wrote: > Really? > > #1) He said: " I cant pass the sheet as it can lead to violations on > company side" > #2) I'm sorry, it's a violation of group policy #3: > > * 3) Don't post questions regarding breaking or bypassing any security > measure* > > The reason is that we do not want to assist someone stealing another's > work. > Evidently, the author wanted to ensure others didn't have access to their > code. > > If you really wish to break their password protection, a simple Google > search for: > "excel vba password recovery" > results in 234,000 matches. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Anil Gawli > *To:* "excel-macros@googlegroups.com" ; > anky...@gmail.com > *Sent:* Friday, June 20, 2014 1:11 AM > *Subject:* Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view > the code > > Dear Ankur, > > Pl share the workbook with us. > > Warm Regards, > Gawli Anil. > > On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta wrote: > > I am new to excel and absolutely a novice to vb. I have been given a > task to > > write macros code in vba in excel. The macro code is already there but > > nobody knows the password. So the button even in design mode doesnot show > > view code. I just want to view to code behind. I cant pass the sheet as > it > > can lead to violations on company side. Can anyone please help me. Its > > really very very urgent and any sort of help will be great for me. I have > > made the file unprotected but still i cannot view the code. Please help > me. > > > > Regards, > > anky > > > > -- > > 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. > > > -- > 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
Re: $$Excel-Macros$$ Very Urgent
yes it is prompting me for password. I tried opening in notepad and tried to find gpd n ol but it crashes the workbook. Please help me out? On Fri, Jun 20, 2014 at 12:21 AM, Vaibhav Joshi wrote: > hi > > You can pres Alt + F11 to go in to VBE mode, then press Ctr + R to view > project explorer on left side. > > Browse for your WB name (this will be like "VBA Project(workbook name)" > and click on plus sign to expand it. If it is not protected then you will > be able to see code, if it is protected then you will be prompted for PWD. > > Cheers!! > > > On Fri, Jun 20, 2014 at 12:24 PM, Ankur Gupta wrote: > >> hi vaibhav, >> >> Could you please illustrate as in what you want to tell me? The workbook >> is not protected but the button , i cant see the code even in design mode. >> It remains clickable even after entering the design mode. Is there any way >> i can check the code for macro written? Please advise me better. I have >> very less idea about this. >> Please help me >> >> >> >> On Thu, Jun 19, 2014 at 11:38 PM, Vaibhav Joshi wrote: >> >>> Hi >>> >>> Is macro module protected? if you can open WB then its not diff. to >>> unprotect VBA module. >>> >>> You can google it around to know how to unprotect it. Pl note rule 3 >>> "Don't post questions regarding breaking or bypassing any security measure." >>> >>> Cheers!! >>> >>> >>> On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta wrote: >>> >>>> I am new to excel and absolutely a novice to vb. I have been given a >>>> task to write macros code in vba in excel. The macro code is already there >>>> but nobody knows the password. So the button even in design mode doesnot >>>> show view code. I just want to view to code behind. I cant pass the sheet >>>> as it can lead to violations on company side. Can anyone please help me. >>>> Its really very very urgent and any sort of help will be great for me. I >>>> have made the file unprotected but still i cannot view the code. Please >>>> help me. >>>> >>>> Regards, >>>> anky >>>> >>>> -- >>>> 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. >>>> >>> >>> -- >>> 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. >
Re: $$Excel-Macros$$ Very Urgent
hi vaibhav, Could you please illustrate as in what you want to tell me? The workbook is not protected but the button , i cant see the code even in design mode. It remains clickable even after entering the design mode. Is there any way i can check the code for macro written? Please advise me better. I have very less idea about this. Please help me On Thu, Jun 19, 2014 at 11:38 PM, Vaibhav Joshi wrote: > Hi > > Is macro module protected? if you can open WB then its not diff. to > unprotect VBA module. > > You can google it around to know how to unprotect it. Pl note rule 3 > "Don't post questions regarding breaking or bypassing any security measure." > > Cheers!! > > > On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta wrote: > >> I am new to excel and absolutely a novice to vb. I have been given a task >> to write macros code in vba in excel. The macro code is already there but >> nobody knows the password. So the button even in design mode doesnot show >> view code. I just want to view to code behind. I cant pass the sheet as it >> can lead to violations on company side. Can anyone please help me. Its >> really very very urgent and any sort of help will be great for me. I have >> made the file unprotected but still i cannot view the code. Please help me. >> >> Regards, >> anky >> >> -- >> 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. >> > > -- > 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 a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/hzdFkKcEQe4/unsubscribe. > To unsubscribe from this group and all its topics, 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. > -- Thanks & Regards Ankur Gupta -- 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 by
$$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it can lead to violations on company side. Can anyone please help me. Its really very very urgent and any sort of help will be great for me. I have made the file unprotected but still i cannot view the code. Please help me. Regards, anky -- 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$$ Very Urgent
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it can lead to violations on company side. Can anyone please help me. Its really very very urgent and any sort of help will be great for me. I have made the file unprotected but still i cannot view the code. Please help me. Regards, anky -- 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.
Re: $$Excel-Macros$$ plz add me to the group thanks
On Feb 13, 2014 12:49 AM, "sudhansu mohan" wrote: > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ PDF attachment in Excel Cell
Hi Anil, VBA code is password protected. Also, I am interested to know, how this is possible, can you briefly explain, how you did the same. Thanks ! Warm Regards Ankur Aggarwal Analyst From: अनिल नारायण गवली To: excel-macros@googlegroups.com; ankur9_aggarwa...@yahoo.co.in Sent: Tuesday, 26 February 2013 11:52 AM Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell Dear Ankur, Whr u find password protected. the workbook which i have provided is not protected. My be the url of the first cell of that icon will be not available, because the url is from my desktop that's why. Warm Regards, Gawli Anil. On Tue, Feb 26, 2013 at 11:47 AM, ANKUR AGGARWAL wrote: How is it working ?, Also the code is password protected, can you please share the password ? > >Warm Regards >Ankur Aggarwal >91-8010614628 >Analyst >Mckinsey Knowledge Center >Mckinsey & Co. > > > > > From: अनिल नारायण गवली >To: excel-macros@googlegroups.com; amar takale >Sent: Tuesday, 26 February 2013 9:40 AM >Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell > > >Dear Amar, > >Yes it is possible with hyperlink > >just give the right url and save it. > >Pl see the attached sheet. > >Warm Regards, >Gawli Anil. > > >On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: > >listen for this one to attach the PDF Files u just need to hyperlink the file >from desktop or file thats it u got the solution when u click it opens the >file. >> >>Thanks, >>Anil >> >> >>On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: >> >>Hi dude, >>> >>> >>> >>> >>>On Mon, Feb 25, 2013 at 7:23 PM, amar takale wrote: >>> >>>Dear All Experts, >>>> >>>>Discuss to all about PDF attachment in Excel Cell >>>> >>>>Regards >>>>Amar >>>> >>>> >>>> >>>>-- >>>>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 M
Re: $$Excel-Macros$$ PDF attachment in Excel Cell
How is it working ?, Also the code is password protected, can you please share the password ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: अनिल नारायण गवली To: excel-macros@googlegroups.com; amar takale Sent: Tuesday, 26 February 2013 9:40 AM Subject: Re: $$Excel-Macros$$ PDF attachment in Excel Cell Dear Amar, Yes it is possible with hyperlink just give the right url and save it. Pl see the attached sheet. Warm Regards, Gawli Anil. On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: listen for this one to attach the PDF Files u just need to hyperlink the file from desktop or file thats it u got the solution when u click it opens the file. > >Thanks, >Anil > > >On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: > >Hi dude, >> >> >> >> >>On Mon, Feb 25, 2013 at 7:23 PM, amar takale wrote: >> >>Dear All Experts, >>> >>>Discuss to all about PDF attachment in Excel Cell >>> >>>Regards >>>Amar >>> >>> >>> >>>-- >>>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. > > > -- 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.
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Thanks a lot Mohan, Its working fine and its allowing person to sign in via yahoo and gmail. Can we send an email to someone by giving recipient ID through a macro ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: अनिल नारायण गवली To: excel-macros@googlegroups.com; mohan.pande...@gmail.com Sent: Friday, 4 January 2013 10:52 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Dear Mohan, Pls find attached its give u some egto work.. Regards, Gawli Anil On Fri, Jan 4, 2013 at 10:48 AM, amar takale wrote: Hi Mohan, > > >A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price & after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query > > >Appreciate the help > > >Let us know in case of any further assistance. > > >Thanks & Regards > >Amar > > > >On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL >wrote: > >Thanks for providing the link Mohan. >> >> >>But unfortunately its giving me an error, file is corrupted and cannot be >>saved. >> >> >>Warm Regards >>Ankur >> >> >> From: "mohan.pande...@gmail.com" >>To: excel-macros@googlegroups.com >>Sent: Friday, 4 January 2013 12:13 AM >> >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >> >>The link which I have sent you is my blog and I have done this for google >>login. At that time it was working. >>Sent from BlackBerry® on Airtel >> >> >>From: ANKUR AGGARWAL >>Sender: excel-macros@googlegroups.com >>Date: Fri, 4 Jan 2013 02:40:10 +0800 (SGT) >>To: excel-macros@googlegroups.com >>ReplyTo: excel-macros@googlegroups.com >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >>Thanks, so you meant that you have logged in to the account but hasn't sent >>any email. >> >> >>I have tried doing that, but after entering the details into my yahoo email >>id, its not allowing me to press enter, due to yahoo security. >> >> >>Can you shared your method ? >> >>Warm Regards >>Ankur Aggarwal >>91-8010614628 >>Analyst >>Mckinsey Knowledge Center >>Mckinsey & Co. >> >> >> >> >> From: "mohan.pande...@gmail.com" >>To: excel-macros@googlegroups.com >>Sent: Friday, 4 January 2013 12:06 AM >>Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using >>excel vba >> >> >> >>Yes I already did it. Need some time if you really want it but I have just >>log in the account not sure about sending email using vba. >>Sent from BlackBerry® on Airtel >> >> >>From: ANKUR AGGARWAL >>Sender: excel-macros@googlegroups.com >>Date: Fri, 4 Jan 2013 02:07:47 +0800 (SGT) >>To: Lalit Mohan Pandey; >>excel-macros@googlegroups.com >>ReplyTo: excel-macros@googlegroups.com >>Subject: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel >>vba >> >> >>Hi Lalit, >> >> >>Thanks for the reply. >> >> >>Below link is not working and the file they have provided is not functioning. >> >> >>Even I have googled a lot, and it seems due to security concerns, gmail or >>yahoo servers are not allowing to access there web sites using a macro. >> >> >>Please let me know if you have tried the same at ur end ? >> >>Regards >>Ankur >> >> >>From: Lalit Mohan Pandey >>To: excel-macros@googlegroups.com >>Cc: ANKUR AGGARWAL >>Sent: Thursday, 3 January 2013 7:31 PM >>Subject: Re: Login to gmail/yahoo and send email using excel vba >> >> >>Hi Ankur, >> >> >>You can find an example to login in gmail account using vba at below >>mentioned link:- >> >> >>http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ >> >> >> >>let us know for further assistance. >> >> >>Regards, >>Lalit Mohan >> &
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur From: "mohan.pande...@gmail.com" To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:13 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel ____ From: ANKUR AGGARWAL Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:40:10 +0800 (SGT) To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Thanks, so you meant that you have logged in to the account but hasn't sent any email. I have tried doing that, but after entering the details into my yahoo email id, its not allowing me to press enter, due to yahoo security. Can you shared your method ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: "mohan.pande...@gmail.com" To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:06 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Yes I already did it. Need some time if you really want it but I have just log in the account not sure about sending email using vba. Sent from BlackBerry® on Airtel ____ From: ANKUR AGGARWAL Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:07:47 +0800 (SGT) To: Lalit Mohan Pandey; excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Hi Lalit, Thanks for the reply. Below link is not working and the file they have provided is not functioning. Even I have googled a lot, and it seems due to security concerns, gmail or yahoo servers are not allowing to access there web sites using a macro. Please let me know if you have tried the same at ur end ? Regards Ankur From: Lalit Mohan Pandey To: excel-macros@googlegroups.com Cc: ANKUR AGGARWAL Sent: Thursday, 3 January 2013 7:31 PM Subject: Re: Login to gmail/yahoo and send email using excel vba Hi Ankur, You can find an example to login in gmail account using vba at below mentioned link:- http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ let us know for further assistance. Regards, Lalit Mohan On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur aggarwal wrote: Hi Team, > > >I wanted to run an excel macro which can automate yahoo/gmail process using >excel vba. Upon clicking of the button, it will send an email from a web >browser ( IE ) using yahoo/gmail to a given email id. > > >Can anybody please help in doing that ? I have written a macro which actually >opens IE and g mail web site, then I have created the HTML object and its >going to gmail website. But I am unable to proceed further (attach file and >send it to recipient ). > >Thanks in Advance ! > > >Warm Regards -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Thanks, so you meant that you have logged in to the account but hasn't sent any email. I have tried doing that, but after entering the details into my yahoo email id, its not allowing me to press enter, due to yahoo security. Can you shared your method ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: "mohan.pande...@gmail.com" To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:06 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Yes I already did it. Need some time if you really want it but I have just log in the account not sure about sending email using vba. Sent from BlackBerry® on Airtel ____ From: ANKUR AGGARWAL Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:07:47 +0800 (SGT) To: Lalit Mohan Pandey; excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Hi Lalit, Thanks for the reply. Below link is not working and the file they have provided is not functioning. Even I have googled a lot, and it seems due to security concerns, gmail or yahoo servers are not allowing to access there web sites using a macro. Please let me know if you have tried the same at ur end ? Regards Ankur From: Lalit Mohan Pandey To: excel-macros@googlegroups.com Cc: ANKUR AGGARWAL Sent: Thursday, 3 January 2013 7:31 PM Subject: Re: Login to gmail/yahoo and send email using excel vba Hi Ankur, You can find an example to login in gmail account using vba at below mentioned link:- http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ let us know for further assistance. Regards, Lalit Mohan On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur aggarwal wrote: Hi Team, > > >I wanted to run an excel macro which can automate yahoo/gmail process using >excel vba. Upon clicking of the button, it will send an email from a web >browser ( IE ) using yahoo/gmail to a given email id. > > >Can anybody please help in doing that ? I have written a macro which actually >opens IE and g mail web site, then I have created the HTML object and its >going to gmail website. But I am unable to proceed further (attach file and >send it to recipient ). > >Thanks in Advance ! > > >Warm Regards -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a
$$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Hi Lalit, Thanks for the reply. Below link is not working and the file they have provided is not functioning. Even I have googled a lot, and it seems due to security concerns, gmail or yahoo servers are not allowing to access there web sites using a macro. Please let me know if you have tried the same at ur end ? Regards Ankur From: Lalit Mohan Pandey To: excel-macros@googlegroups.com Cc: ANKUR AGGARWAL Sent: Thursday, 3 January 2013 7:31 PM Subject: Re: Login to gmail/yahoo and send email using excel vba Hi Ankur, You can find an example to login in gmail account using vba at below mentioned link:- http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ let us know for further assistance. Regards, Lalit Mohan On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur aggarwal wrote: Hi Team, > > >I wanted to run an excel macro which can automate yahoo/gmail process using >excel vba. Upon clicking of the button, it will send an email from a web >browser ( IE ) using yahoo/gmail to a given email id. > > >Can anybody please help in doing that ? I have written a macro which actually >opens IE and g mail web site, then I have created the HTML object and its >going to gmail website. But I am unable to proceed further (attach file and >send it to recipient ). > >Thanks in Advance ! > > >Warm Regards -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Login to gmail/yahoo and send email using excel vba
Hi Team, I wanted to run an excel macro which can automate yahoo/gmail process using excel vba. Upon clicking of the button, it will send an email from a web browser ( IE ) using yahoo/gmail to a given email id. Can anybody please help in doing that ? I have written a macro which actually opens IE and g mail web site, then I have created the HTML object and its going to gmail website. But I am unable to proceed further (attach file and send it to recipient ). Thanks in Advance ! Warm Regards -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Apologies for replying late, was stuck in between an important work. Yes I googled the same, what I understood from Microsoft people and the website, is that problem of organizational chart does exist in excel 2003 and same has been rectified in excel 2007 or later versions. Now, since our client doesn't have xcel 2007 and they don't want to embed any add- in, creation of dynamic organization chart is difficult to implement. I have shared the sample excel file "Example.xls along with a macro in one of my earlier mail. Thanks for the help so far. Much appreciated ! Warm Regards Ankur Aggarwal 91-8010614628 Analyst From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Wednesday, 7 November 2012 8:16 PM Subject: Re: $$Excel-Macros$$ Organization Chart can you send me your file? I need to know what type of object you're using for the Org Chart. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ____ From: ANKUR AGGARWAL To: "excel-macros@googlegroups.com" Cc: Paul Schreiner Sent: Wed, November 7, 2012 1:21:01 AM Subject: Re: $$Excel-Macros$$ Organization Chart Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node. Can you please recheck ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:10 PM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ____ From: ANKUR AGGARWAL To: "excel-macros@googlegroups.com" Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: ANKUR AGGARWAL To: "noorain.ans...@gmail.com" ; "excel-macros@googlegroups.com" Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/gr
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Thanks for the reply. Your method of double clicking and recording the macro works well for excel 2007, but its not working for excel 2003, reason being we not even getting the pop up for converting it into shape in 2003. What can be other alternative. Also I have googled but couldn't find any relevant info on the web. Warm Regards Ankur Aggarwal Analyst From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:21 PM Subject: Re: $$Excel-Macros$$ Organization Chart I also Googled "Excel vba Org Chart" and received 189,000 hits. Perhaps someone else has already done this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ____ From: ANKUR AGGARWAL To: "excel-macros@googlegroups.com" Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. ____ From: ANKUR AGGARWAL To: "noorain.ans...@gmail.com" ; "excel-macros@googlegroups.com" Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyr
Re: $$Excel-Macros$$ Organization Chart
Thanks for sharing the thread Rajan, but unfortunately code doesn't work in Excel 2003 and my client is using excel 2003. Do you have any alternative ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:49 PM Subject: RE: $$Excel-Macros$$ Organization Chart Please have a look here http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-applications-smart-art.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 06 November 2012 7:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Organization Chart I also Googled "Excel vba Org Chart" and received 189,000 hits. Perhaps someone else has already done this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From:Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, November 6, 2012 8:40:43 AM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From:ANKUR AGGARWAL To: "excel-macros@googlegroups.com" Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From:ANKUR AGGARWAL To: "noorain.ans...@gmail.com" ; "excel-macros@googlegroups.com" Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions rega
Re: $$Excel-Macros$$ Organization Chart
Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node. Can you please recheck ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tuesday, 6 November 2012 7:10 PM Subject: Re: $$Excel-Macros$$ Organization Chart I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values in the Org Chart. I don't know if that will give you the result you're looking for... ?? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ____ From: ANKUR AGGARWAL To: "excel-macros@googlegroups.com" Sent: Mon, November 5, 2012 9:43:37 PM Subject: Re: $$Excel-Macros$$ Organization Chart Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. ____ From: ANKUR AGGARWAL To: "noorain.ans...@gmail.com" ; "excel-macros@googlegroups.com" Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise,
Re: $$Excel-Macros$$ Organization Chart
Can somebody please help on the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: ANKUR AGGARWAL To: "noorain.ans...@gmail.com" ; "excel-macros@googlegroups.com" Sent: Monday, 5 November 2012 6:31 PM Subject: $$Excel-Macros$$ Organization Chart Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Organization Chart
Hi team, Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the sample excel file, in Sheet 1 there is an attached Organization chart which I am creating through VBA code., I want to fill each node of the chart dynamically through VBA, but the problem is I am not able to access nodes of the organization chart through code. Its taking whole organization chart as a shape and not able to access node of the organization chart. Can somebody please help me out. Its very urgent as I have to complete something by EOD. Thanks in advance. Warm Regards Ankur Aggarwal Analyst -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Example.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help to get the Formula
Thanks a lot Rajan and Ashish I really appreciate your knowledge and great help On 10/2/12, ashish koul wrote: > try the attachment change c38 as per ur last row > > > > On Tue, Oct 2, 2012 at 10:56 AM, Rajan_Verma > wrote: > >> >> Try this >> >> =IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N($C$1:$C$16<>"")*$F$1:$F$16)=F1,"Y >> es","No"),"") >> >> >> Regards >> Rajan verma >> +91 7838100659 [IM-Gtalk] >> >> -Original Message- >> From: excel-macros@googlegroups.com >> [mailto:excel-macros@googlegroups.com] >> On Behalf Of ankur kochar >> Sent: 02 October 2012 12:19 >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Help to get the Formula >> >> Hi All, >> >> I seek some help in to get the desired result via formula. >> >> My requirement is - I need result in column G in the yellow highlighted >> cell >> as Yes or No. If the sum of F2:F4 (lines can be more) match with the >> value >> in cell F1 total and that should be only in the case when the numbers in >> B1 >> to B4 are same and if there is any value in C2 to C4 which are either >> "E" >> or "F" or "A" . In that sense i need result in all the cells highlighted >> in >> yellow. >> >> Please find attached the file for reference. Let me know if the above >> information makes sense to get the desired result. >> >> I hope if someone can help me out with the formula. >> >> Thanks for all your help in advance. >> >> -- >> Regards, >> Ankur >> >> -- >> 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. >> >> >> > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* > > P Before printing, think abo
$$Excel-Macros$$ Help to get the Formula
Hi Vab, Thanks for your valuable input. But currently it works for the specific range of data selected. But i need to get the formula for 'n" number of lines and the range is not fixed for column "B" and column "C". I need the formula in column G in all the cell and the result should be true in the line where there is value in cell B and cell C,D&E are blank. I hope you understood my requirement and help me to get the formula in all the cells in column G. I have attached the file with more data. Please help me get the desired result. thanks for your help in advance. On 10/2/12, Vabz wrote: > Hi, > > PFA Files with formula.. > > You can adjust range accordingly in your main file, three condition tested > is also shown separately.. > > Cheers.. > > Rgds//Vabs > > > On Tuesday, October 2, 2012 12:19:37 AM UTC+5:30, ankur wrote: >> >> Hi All, >> >> I seek some help in to get the desired result via formula. >> >> My requirement is - I need result in column G in the yellow >> highlighted cell as Yes or No. If the sum of F2:F4 (lines can be more) >> match with the value in cell F1 total and that should be only in the >> case when the numbers in B1 to B4 are same and if there is any value >> in C2 to C4 which are either "E" or "F" or "A" . In that sense i need >> result in all the cells highlighted in yellow. >> >> Please find attached the file for reference. Let me know if the above >> information makes sense to get the desired result. >> >> I hope if someone can help me out with the formula. >> >> Thanks for all your help in advance. >> >> -- >> Regards, >> Ankur >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Regards, Ankur -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Help to get the Formula
Hi All, I seek some help in to get the desired result via formula. My requirement is - I need result in column G in the yellow highlighted cell as Yes or No. If the sum of F2:F4 (lines can be more) match with the value in cell F1 total and that should be only in the case when the numbers in B1 to B4 are same and if there is any value in C2 to C4 which are either "E" or "F" or "A" . In that sense i need result in all the cells highlighted in yellow. Please find attached the file for reference. Let me know if the above information makes sense to get the desired result. I hope if someone can help me out with the formula. Thanks for all your help in advance. -- Regards, Ankur -- 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. Need Formula.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ switch on anf off calculation
Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Unique Name Query
That was a very useful excel function. Thanks for sharing this. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Haseeb A To: excel-macros@googlegroups.com Sent: Tuesday, 10 July 2012 4:37 AM Subject: $$Excel-Macros$$ Re: Unique Name Query Hello Karan, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100<>"",IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),"") If you need Unique Names in Ascending Order, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(0,IF(A$2:A$100<>"",COUNTIF(A$2:A$100,"<"&A$2:A$100),"")-SUM(COUNTIF(A$2:A$100,C$1:C1)),0)),"") Note: You must have something for IF's false argument ie. "", any text or a Big number like 2^21, 9E+300 etc.. If you need Descending Order, change "<" to ">" These formulas will work even if you have blank cells in the range. See the sample file. Regards, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Totally agreed. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Divaker Pandey To: excel-macros@googlegroups.com Sent: Thursday, 28 June 2012 8:44 PM Subject: Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire) Hi Noorain, I think job related to excel vba mail should not be banned. 1. it will help to user to know what is in current demand in excel related job. 2. it will encourage to learn and solve more excels quiz. 3. in last each enhanced skill is used to get better job options. Regards. Divaker On Thu, Jun 28, 2012 at 7:29 PM, NOORAIN ANSARI wrote: Dear Jitu, > >As per Forum rule, Job related mail has been banned. >Brother take care in future. > > > >On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh wrote: > > >> >> >>-- Forwarded message -- >>From: RJT Compuquest >>Date: Thu, Jun 28, 2012 at 1:26 PM >>Subject: MIS executive opening with Aricent Technologies (Contact to Hire) >>To: jeete2...@gmail.com >> >> >> >>The sender of this email is registered with Naukri.com as RJT Compuquest >>Experience required for the Job: 2 - 3 years >>Job Location: Gurgaon >> >>Apply Now(Send your Naukri profile to express interest to the recruiter) >> >>Dear Candidate, >>Hello, >>> >>>Greetings of the Day!!! >>> >>>We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon >>>(Working on a payroll of RJT) >>> >>> >>>About Aricent(CLient): >>> >>>Our Client is a global innovation, technology and services company focused >>>exclusively on communications. Its unique engagement model blends strategy, >>>design, technology and engineering services, delivering exceptional value >>>across each phase of the product and service lifecycle. >>>Together with its global innovation arm frog design, offers 40 years" >>>experience in delivering innovation and technology breakthroughs that have >>>transformed entire industries. With more than 800 clients, 9500 employees in >>>19 countries,more than 100 industry awards. It is uniquely positioned to >>>help organizations conceive and commercialize innovative solutions. >>> >>>Please fill this below details: >>> >>>Currrent CTC: >>>Expected CTC: >>>Notice Period: >>>DOB: >>> >>> >>>Roles & Responsbilities: >>> >>>Expertise in MS-Excel, MS-Power Point, MS-Word & MS- Access Good analytical >>>& management skills Ability to relate various data sources for >>>comparing/contrasting Ability to interpret requirements & be self driven >>>Preparing & presenting appropriate reports as & when required Maintain data >>>pertaining to all departments - O&M, Finance & Accounts, HR & Admin, Sales & >>>Service, Education Handling different projects assignment as & when required >>> >>>Qualification: Any Graduate >>> >>>Location: Gurgaon >>> >>>Please forward your updated resume and also refer your friend or colleague >>>who are interested to change. >>> >>>Awaiting your prompt reply. >>> >>>Thanks & Regards >>>Sonia Gupta >>Is this job relevant to you? Yes No >>Your feedback would help us in sending you the most relevant job >>opportunities >>Disclaimer: >>The sender of this email is registered with naukri.com as RJT Compuquest >>(gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR, GURGAON, Haryana - >>122001) using Naukri.com services. The responsibility of checking the >>authenticity of offers/correspondence lies with you. >> >>If you consider the content of this email inappropriate or spam, you may: >> 1. Report abuse by forwarding this email to: complia...@naukri.com >> 2. You can also Block this Company from searching your resume in the >> database. >>Advisory: Please do not pay any money to anyone who promises to find you a >>job. This could be in the form of a registration fee, or document processing >>fee or visa charges or any other pretext. The money could be asked for >>upfront or it could be asked after trust has been built after some >>correspondence has been exchanged. Also please note that in case you get a >>job offer or a letter of intent without having been through an interview >>process it is probably a scam and you should contact complia...@naukri
Re: $$Excel-Macros$$ need help on maximum value and thier name
Noorain, Don't u think, its a too complex formula for the simple problem ? We can directly use large and small function to calculate order and index + match unction to calculate the name. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Monday, 25 June 2012 1:29 PM Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name Hi Sunita, Please you can also use.. Through Vlookup =VLOOKUP(LARGE($B$2:$B$15,1),CHOOSE({1,2},$B$2:$B$15,$A$2:$A$15),2,0) Through Lookup =LOOKUP(2,1/((LARGE($B$2:$B$15,1)=$B$2:$B$15)),$A$2:$A$15) Through Indirect =INDIRECT("A"&MATCH(LARGE($B$1:$B$15,1),$B$1:$B$15,0)) See attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 25, 2012 at 1:03 PM, सुनिता पौडेल wrote: Thanx :) > > > >On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed wrote: > >Hi Sunita, >> >>In my case, I have used filters since it becomes more easier >> >> >>On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल wrote: >> >>did you filtre the column? >>>thank you >>> >>> >>>On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed wrote: >>> >>>PFA >>>> >>>> >>>> >>>>On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote: >>>> >>>>Dear all, >>>>> >>>>>It has always been previlege to query on this group whenever needed and >>>>>thanks from heart. >>>>> >>>>>I need one help regarding finding out maximum number and their name in one >>>>>cell ? >>>>> >>>>>Have a wonderful day !! >>>>> >>>>>Thank you!! >>>>>Sunita >>>>> >>>>>P.S: in case if file not attached(having probs) >>>>> >>>>>name amount >>>>> Bijay Barma 11640 >>>>> Binod Barma 10983 >>>>> Manoj Barma 10983 >>>>> Jitendra Barma 16215 >>>>> Birbal Sunar 15207 >>>>> Dinesh Rokaya 28742 >>>>>Nisha Basnet 10041 >>>>>Daman Raj Aidi 11356 >>>>>Nara Rawat 32130 >>>>>Surya Buda 10001 >>>>>Binita Bam 9699 >>>>>RajKumar Rawat 29512 >>>>>Shiva Thapa 28393 >>>>>Rajesh Singh 10365 >>>>>Can we find maximum number and their name in one cell or different? >>>>>Can we find 2nd maximum number and their name/ >>>>>Likewise from greates to least number? >>>>> >>>>> -- >>>>>-- >>>>>FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>>>will not get quick attention or may not be answered. >>>>> >>>>>2) Don't post a question in the thread of another member. >>>>> >>>>>3) Don't post questions regarding breaking or bypassing any security >>>>>measure. >>>>> >>>>>4) Acknowledge the responses you receive, good or bad. >>>>> >>>>>5) Cross-promotion of, or links to, forums competitive to this forum in >>>>>signatures are prohibited. >>>>> >>>>>NOTE : Don't ever post personal or confidential data in a workbook. Forum >>>>>owners and members are not responsible for any loss. >>>>> >>>>>-- >>>>>To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>>To unsubscribe, send a blank email to >>>>>excel-macros+unsubscr...@googlegroups.com >>>>> >>>>> >>>>> >>>>-- >>>>-- 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 t
$$Excel-Macros$$ Interesteing Problem : - Morefunc Addin - Why it could not be embedded like in Excel 2003?
Hi all, Good Morning. There is an exciting challenge ahead of me. Has any one worked on Morefunc Addin ? Mconcat fn is used as an add - in in excel 2003. There is a Big 200 MB Model, where in one of the worksheets, Mconcat fn ( utility of the add-in) is used. This add-in can easily be embedded in excel 2003, means when we are transferring the file from one system to another, u don't explicitly need to install add in again go the system. But issue is when we are moving this model from 2003 to 2010 version. We can't embed the same and each time we need to explicitly install the add - in into every system. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved. Need particulaly help in 2 things :- 1. There is an issue of it being able to be embedded into Excel 2003 but not in excel 2007/ 2010 which cannot be solved according to me. Still if someone knows the trick, please let me know. 2. If anyone has used Mconcat function. ? What does it do and whats the way around, can we replace mconcat function using the addi-n by complex excel formula ? Please help ! Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Sure Rajan. Cell B5 contains the NPV value which can also be calculated using the formula in cell B6. It's like we know the NPV value, we wanted to back calculate Discount rate which is used in calculating the NPV value. Now, this can be easily done manually through a simple goal seek. But problem is, since NPV value ( cell B5 ) keeps on changing again and again, one has to manually do goal seek again and again or write a macro which will change set value in goal seek to cell B5. But now the client doesn't want us to use the macro. Can excel formula do the same ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 7:38 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula Can you explain how b5 is related to the formula in b6? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 6:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Hi Rajan, formula is in B6, B5 is the set value, we need to predict B4. We will get the refreshed value in cell B5. ( Means this value is coming again and again fro the DB ). Please let me know if iteration will help. ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From:Rajan_Verma To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 5:55 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula I think it can be done by enabling iteration in formula .. what result you want in b6 or what condition you want to apply in calculation? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 2:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From:NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From:NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, "A").End(xlUp).Row sh.Range("I" & i).GoalSeek Goal:=sh.Range("A" & i).Value, ChangingCell:=sh.Range("E" & i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- 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'
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Hi Rajan, formula is in B6, B5 is the set value, we need to predict B4. We will get the refreshed value in cell B5. ( Means this value is coming again and again fro the DB ). Please let me know if iteration will help. ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 5:55 PM Subject: RE: $$Excel-Macros$$ Automating a goal seek using an excel formula I think it can be done by enabling iteration in formula .. what result you want in b6 or what condition you want to apply in calculation? Regards Rajan verma +91 7838100659 [IM-Gtalk] From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANKUR AGGARWAL Sent: 21 June 2012 2:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From:NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From:NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, "A").End(xlUp).Row sh.Range("I" & i).GoalSeek Goal:=sh.Range("A" & i).Value, ChangingCell:=sh.Range("E" & i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- 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
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Let me redefine the problem, We are getting NPV values from some data base. Based on NPV value, we have to automate a process which will back calculate the discount rate using NPV formula in excel. In excel, goal seek will serve the purpose, but since you will refresh NPV values, one has to manually perform goal seek each time. One solution is that we need to have a button to suffice the required need but we do not want macro, we need an excel formula, can any formula is possible which wil be dynamic enough to do so. To my knowledge it's not possible. But I wants expert comment. Please let me know asap. Its very urgent. Warm Regards Ankur Aggarwal From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 1:39 PM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Can you share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL wrote: Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? > >Warm Regards >Ankur Aggarwal >91-8010614628 >Analyst >Mckinsey Knowledge Center >Mckinsey & Co. > > > > > From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Thursday, 21 June 2012 11:13 AM >Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula > > > >Dear Ankur, > >Please try it.. > >Sub Dynamic_Goalsheek() >Dim i As Long >Dim sh As Worksheet >Set sh = ThisWorkbook.Sheets(1) >For i = 2 To sh.Cells(Rows.Count, "A").End(xlUp).Row >sh.Range("I" & i).GoalSeek Goal:=sh.Range("A" & i).Value, ChangingCell:=sh.Range("E" & i) >Next i >End Sub > >See attached sheet hope it will help to you >else >share a sample workbook with group. > > >-- >Thanks & regards, >Noorain Ansari >www.noorainansari.com >www.excelmacroworld.blogspot.com > >On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL > wrote: > >Experts, is it at all possible to automate goal seek function using an excel >formula without a macro. Set value in goal seek function will get refreshed >every day, we don't want to manually apply goal seek each time neither wanna >use the macro to automate that. >> >> >>Can it be done using any dynamic excel formula ? >> >> >> >> >>Warm RegardsAnkur Aggarwal >>Analyst >> >> -- >>-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com > > > > > > >-- >-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com > > > -- >-- 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 n
Re: $$Excel-Macros$$ Automating a goal seek using an excel formula
Thanks Noorain for the reply but I need a dynamic excel formula to do the same. I have the macro but we wanted to have a dynamic excel formula. Is it possible? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, 21 June 2012 11:13 AM Subject: Re: $$Excel-Macros$$ Automating a goal seek using an excel formula Dear Ankur, Please try it.. Sub Dynamic_Goalsheek() Dim i As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For i = 2 To sh.Cells(Rows.Count, "A").End(xlUp).Row sh.Range("I" & i).GoalSeek Goal:=sh.Range("A" & i).Value, ChangingCell:=sh.Range("E" & i) Next i End Sub See attached sheet hope it will help to you else share a sample workbook with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 8:59 AM, ANKUR AGGARWAL wrote: Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. > > >Can it be done using any dynamic excel formula ? > > > > >Warm RegardsAnkur Aggarwal >Analyst > > -- >-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Automating a goal seek using an excel formula
Experts, is it at all possible to automate goal seek function using an excel formula without a macro. Set value in goal seek function will get refreshed every day, we don't want to manually apply goal seek each time neither wanna use the macro to automate that. Can it be done using any dynamic excel formula ? Warm Regards Ankur Aggarwal Analyst -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Introduce Yourself !!
Hi All, This is Ankur Aggarwal, working as an analyst in Mckinsey Knowledge Center from 2 years. I am looking forward to the group and the learning, will also try to answer the queries if anybody has on excel, assess, predicative modelling. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Nagendra Modupalli To: excel-macros@googlegroups.com Sent: Wednesday, 20 June 2012 9:53 AM Subject: Re: $$Excel-Macros$$ Introduce Yourself !! Dear All, My self Nagendra M and 28 years old. am basically from Andhra Pradesh.Working in Bangalore as a Finance Analyst fast 7years. I like very much Excel and this group as well...Thanks you so much knowledge sharing and helping other's Thanks&Regards Nagendra.M "Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Seems Like comments but Not
yes, datavalidation-input message Regards: CMA Ankur Pandey On Fri, Jun 15, 2012 at 4:13 PM, Anil Gawli wrote: > Yes that is created by data validation > Ahmed is Right. > Regards, > Gawli Anil > > On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest wrote: > >> Dear Deba, >> >> That's INput message defined using Data Validation. For your information >> click in the cell where the message is coming up go to Data tab and >> select Data Validation and in Data Validation Check for Input message. Hope >> you shbould understand. >> >> Moreover, it's one of the way to guide the end user what is to be entered >> or how the data is to be entered in a speicific sheet. >> >> Hope this above explanation help. >> >> Thanks, >> >> >> >> On Fri, Jun 15, 2012 at 1:29 PM, Deba Ranjan wrote: >> >>> Dear Experts, >>> >>> I show in the attached file, If we click in B2 cell to B5 cell, >>> then some comments appears, actually I have notice that it is not a >>> comments, Can you Please suggest what actually is ? >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> -- >>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use >>> concise, accurate thread titles. Poor thread titles, like Please Help, >>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>> get quick attention or may not be answered. 2) Don't post a question in the >>> thread of another member. 3) Don't post questions regarding breaking or >>> bypassing any security measure. 4) Acknowledge the responses you receive, >>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this >>> forum in signatures are prohibited. NOTE : Don't ever post personal or >>> confidential data in a workbook. Forum owners and members are not >>> responsible for any loss. >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com To >>> unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> -- >> Ahmed Bawazir >> *احمد باوزير* >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe
Re: $$Excel-Macros$$ Date
hi chandra Sorry for late reply Please find the attached file for the solution,as i suggested you earlier Regards: CMA Ankur Pandey On Fri, Jun 15, 2012 at 8:36 PM, Rajan_Verma wrote: > Hi, > > ** ** > > I think I am not getting you . > > Can you please explain how you want to get day on behalf of Hours?? > > ** ** > > Because the days is also calculating in the last formula based on give > Dates and Times. > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 15 June 2012 8:25 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Date > > ** ** > > Hello Rajan, > > > > Thanks for the formula. Could you please provide days as well which is in > Column C based on Hours. > > > > Thanks in advance. > > > > Regards, > > > > Chandra Shekar B > > On Fri, Jun 15, 2012 at 4:22 PM, Rajan_Verma > wrote: > > > > > > HI > > > > Try this > > > > *=DAY(B2-A2) & " Day " & HOUR(B2-A2) & " Hour " & MINUTE(B2-A2) & " > Minute " & SECOND(B2-A2) & " Second"* > > > > > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 15 June 2012 6:06 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Date > > > > Hello, > > > > Any help regarding this. > > > > Thanks in advance. > > > > Regards, > > > > Chandra Shekar B > > -- Forwarded message -- > From: *Chandra Shekar* > Date: Tue, Jun 12, 2012 at 3:45 PM > Subject: $$Excel-Macros$$ Date > To: excel-macros@googlegroups.com > > Hello, > > > > Can you please help me with attached excel. > > > > Thanks in advance. > > > > Regards, > > > > Chandra Shekar B > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > 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 Ne
Re: $$Excel-Macros$$ vlookup -please help on the attachment
hi Smitha i hope this is your requirement PFA Regards: CMA Ankur Pandey On Mon, Jun 18, 2012 at 11:28 AM, Smitha S R wrote: > Hi, > > PFA my vlookup table. If I select the nature of expenses, corresponding > expenses main head should come from the second worksheet anemd data2. > But the main head coming in the first work sheet is wrong. Please help on > this. > > Regards > Smitha > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Vlookup Solution by Ankur.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro for column size reduction
use this macro Sub gg() Selection.ColumnWidth = 5 End Sub you can change column width as per your need On 6/17/12, Ahmed Honest wrote: > Dear Amit, > > May be I'm not sure whether you are familiar with this Or this is what you > are looking for i.e for making all columns adjust according to the Raw Data > in a sheet you do this >> Ctrl + A to select entire sheet and after this > Alt + O + C + A. > > Hope this helps. > > > > > On Sun, Jun 17, 2012 at 12:08 PM, Amit Desai (MERU) > > wrote: > >> Dear Friends, >> >> ** ** >> >> Does anyone have a macro to reduce column size all together? >> >> ** ** >> >> Best Regards, >> >> Amit >> >> ** ** >> >> -- >> Disclaimer: This message and its attachments contain confidential >> information and may also contain legally privileged information. This >> message is intended solely for the named addressee. If you are not the >> addressee indicated in this message (or authorized to receive for >> addressee), you may not copy or deliver any part of this message or its >> attachments to anyone or use any part of this message or its attachments. >> Rather, you should permanently delete this message and its attachments >> (and >> all copies) from your system and kindly notify the sender by reply >> e-mail. >> Any content of this message and its attachments that does not relate to >> the >> official business of Meru Cab Company Pvt. Ltd. must be taken not to have >> been sent or endorsed by any of them. Email communications are not >> private >> and no warranty is made that e-mail communications are timely, secure or >> free from computer virus or other defect. >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Ahmed Bawazir > *احمد باوزير* > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Regards: CMA Ankur Pandey -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Date
Dear Chandra, Try this one DATEDIF(A2,B2,"d") for Formula1(Days) TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss) CONCATENATE(C2," Days ",HOUR(D2)," Hr ",MINUTE(D2)," Mins ",SECOND(D2)," Sec") for Formula3 Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI wrote: > Dear Chandra, > > Please see attached sheet. > > > On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello, >> >> Can you please help me with attached excel. >> >> Thanks in advance. >> >> Regards, >> >> Chandra Shekar B >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Excel Function details collection required
Hi Divakar You can Download file from here http://www.xlfdic.com/ It will explain you most of the functions with examples and syntax Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 1:54 PM, Divaker Pandey wrote: > Hi Members, > > I have required syntax and details of each excel function. > > Please provide me. > > thanks in advance. > > Divaker > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Date format change by running the macro
*HI ASHISH **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know* how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference * Sub chgDateFormat() ActiveCell.Offset(0, 1).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))" ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range("A1:A500") ActiveCell.Range("A1:A1").Select End Sub * Regards: CMA Ankur Pandey Visit My Site <http://cmaankur.wordpress.com/> On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara wrote: > Dear sir, > > I have data in which date written in 20120412 format and i want to make > macro to which transfer the format to 12-Apr-2012 by running the macro on > selection range. Please help me in my below code. > > Sub Macro1() > Dim selct As Range > selct = Range.Select > Range = WorksheetFunction.TEXT(TEXT(selct, "-00-00"), "DD-MMM-") > End Sub > > Thanks & regards. > > Ashish Bhalara > 9624111822 > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Date Format.xlsm Description: Binary data
Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....
*@ Noorain Sir... only one word...Awesome. * Regards: CMA Ankur Pandey Visit My Site <http://cmaankur.wordpress.com/> On Mon, Jun 11, 2012 at 11:01 PM, NOORAIN ANSARI wrote: > Dear Ankur, > > Excellent Job.. > > I have improved it, see attached sheet.. > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jun 11, 2012 at 10:25 PM, ankur wrote: > >> *hi Munner >> Solution given by Rajan and Noorain Sir had solved your problem,but due >> to curiosity i try to modify the solution of Noorain sir by adding >> option to highlight any day ,option given by input box >> take one look, i request other members to suggest me ,how it can be >> improve >> i don't have knowledge of VBA ,its just an effort >> >> Note : Choose no. in input box : 1 for sunday , 2 for monday and so on >> >> >> Thanks* >> >> Regards: >> CMA Ankur Pandey >> >> Visit My Site <http://cmaankur.wordpress.com/> >> >> >> >> >> On Mon, Jun 11, 2012 at 9:08 PM, NOORAIN ANSARI > > wrote: >> >>> Dear Muneer, >>> >>> See the attachment. >>> >>> >>> On Mon, Jun 11, 2012 at 8:12 PM, Mohammed Muneer wrote: >>> >>>> Sorry I forgot to attaché the file… >>>> >>>> ** ** >>>> >>>> ** ** >>>> >>>> Regards, >>>> >>>> Muneer, >>>> >>>> CC… >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>>> >>>> -- Forwarded message -- >>>> From: "Mohammed Muneer" >>>> To: >>>> Cc: >>>> Date: Mon, 11 Jun 2012 17:39:58 +0300 >>>> Subject: Highlighting the Text based on the Week day. >>>> >>>> Dear Friends, >>>> >>>> ** ** >>>> >>>> If the day in col - A is Friday the Text in col - B should get >>>> highlighted - please help me I need a VBA code in this to solve. >>>> >>>> ** ** >>>> >>>> My file carry large no.of this kind of data in my excel sheet. That’s >>>> the reason I need to approach this method. >>>> >>>> ** ** >>>> >>>> If necessary please do it little urgent….. >>>> >>>> ** ** >>>> >>>> ** ** >>>> >>>> Regards, >>>> >>>> Muneer, >>>> >>>> CC…. >>>> >>>> >>> >>> >>> >>> >>> >>> -- >>> 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
Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....
*hi Munner Solution given by Rajan and Noorain Sir had solved your problem,but due to curiosity i try to modify the solution of Noorain sir by adding option to highlight any day ,option given by input box take one look, i request other members to suggest me ,how it can be improve i don't have knowledge of VBA ,its just an effort Note : Choose no. in input box : 1 for sunday , 2 for monday and so on Thanks* Regards: CMA Ankur Pandey Visit My Site <http://cmaankur.wordpress.com/> On Mon, Jun 11, 2012 at 9:08 PM, NOORAIN ANSARI wrote: > Dear Muneer, > > See the attachment. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jun 11, 2012 at 8:12 PM, Mohammed Muneer wrote: > >> Sorry I forgot to attaché the file… >> >> ** ** >> >> ** ** >> >> Regards, >> >> Muneer, >> >> CC… >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- Forwarded message -- >> From: "Mohammed Muneer" >> To: >> Cc: >> Date: Mon, 11 Jun 2012 17:39:58 +0300 >> Subject: Highlighting the Text based on the Week day. >> >> Dear Friends, >> >> ** ** >> >> If the day in col - A is Friday the Text in col - B should get >> highlighted - please help me I need a VBA code in this to solve. >> >> ** ** >> >> My file carry large no.of this kind of data in my excel sheet. That’s the >> reason I need to approach this method. >> >> ** ** >> >> If necessary please do it little urgent….. >> >> ** ** >> >> ** ** >> >> Regards, >> >> Muneer, >> >> CC…. >> >> > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<> Highlight Any Day Solution by Ankur.xlsm Description: Binary data
Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....
*hi Munner Solution given by Rajab and Noorain Sir had solved your problem,but due to curiosity i try to modify the solution of Noorain sir by adding option to highlight any day ,option given by input box take one look, i request other members to suggest me ,how it can be improve i don't have knowledge of VBA ,its just an effort Note : Choose no. in input box : 1 for sunday , 2 for monday and so on Thanks* Regards: CMA Ankur Pandey Visit My Site <http://cmaankur.wordpress.com/> On Mon, Jun 11, 2012 at 9:08 PM, NOORAIN ANSARI wrote: > Dear Muneer, > > See the attachment. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jun 11, 2012 at 8:12 PM, Mohammed Muneer wrote: > >> Sorry I forgot to attaché the file… >> >> ** ** >> >> ** ** >> >> Regards, >> >> Muneer, >> >> CC… >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- Forwarded message -- >> From: "Mohammed Muneer" >> To: >> Cc: >> Date: Mon, 11 Jun 2012 17:39:58 +0300 >> Subject: Highlighting the Text based on the Week day. >> >> Dear Friends, >> >> ** ** >> >> If the day in col - A is Friday the Text in col - B should get >> highlighted - please help me I need a VBA code in this to solve. >> >> ** ** >> >> My file carry large no.of this kind of data in my excel sheet. That’s the >> reason I need to approach this method. >> >> ** ** >> >> If necessary please do it little urgent….. >> >> ** ** >> >> ** ** >> >> Regards, >> >> Muneer, >> >> CC…. >> >> > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<> Highlight Any Day Solution by Ankur.xlsm Description: Binary data
Re: $$Excel-Macros$$ Extract Comma separated Data
*@ David very good way to solve the above said query...It's really amazing trick... @ Maries.nice one TOday i learn two more tricks out of Countless.. * Regards: CMA Ankur Pandey Visit My Site <http://cmaankur.wordpress.com/> On Mon, Jun 11, 2012 at 12:49 PM, Maries wrote: > HI, > > Use the below formula PFA. > * > =SUBSTITUTE(B2,",",REPT(" ",1000))* > > > > On Sun, Jun 10, 2012 at 11:50 PM, David Grugeon wrote: > >> Hi Nalini >> >> Select the data >> Ctrl H to bring up the replace dialog >> Click in the "Find what" box. Type a comma. >> Click in the "Replace with" box. >> Hold down ALT and on the number pad type 013. Release ALT >> Hold down ALT and on the number pad type 010. Release ALT >> Click Replace All >> Select the rows and with the mouse between two row numbers on the left >> double click. >> >> Regards >> >> David Grugeon >> > > > > -- > * > * > * MARIES* > Excel Inspiration <http://xcel-inspiration.blogspot.com/> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Require Macro for Account Reconcile between 2 different sheet
On 4/18/12, dguillett1 wrote: > This will do for one. Adapt for the other. See attached > Option Explicit > > Sub FindAccountInTallySAS() > Dim i As Long > Dim mf As Range > > For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row > With Sheets("Tally") > Set mf = .Columns("e").Find(What:=Cells(i, "c"), LookIn:=xlValues, _ > LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext) > If Not mf Is Nothing Then > Cells(i, "k") = .Cells(mf.Row, "H") - Cells(i, "H") > Else > Cells(i, "k") = "Not in Tally" > End If > End With > Next i > End Sub > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > From: Ashish Bhalara > Sent: Tuesday, April 17, 2012 11:51 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Require Macro for Account Reconcile between 2 > different sheet > > Dear expert, > > > I need a macro to reconcile account. The output of result are in attached > file by written function. > > Thanks & regards. > > Ashish Bhalara > 9099098307 > > > > > -- > 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 > -- Regards, Ankur -- 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$$ Your Valuable ideas and comments needed
Hello Excel experts I am try to make one website .http://cmaankur.wordpress.com click here <http://cmaankur.wordpress.com/> I am newbie in this regard, i don't know what type of things or stuffs should be added there... i have lots of files , which i got from different sites including this group i had added some ebooks there ,but got stuck now to proceed further...only one question is *"How can i make the site interesting ?"* thats why I want your valuable ideas, comments,help & suggestion to make it better site for everyone... any type of suggestions will be very much helpful to me... CMA Ankur Pandey http://cmaankur.wordpress.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ SUMIFS
hi kaushik plz use this formula =SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0)) sample file is attached for ur reference On 20/07/2011, Aindril De wrote: > Hi Kaushik, > > The criteria that you have mentioned is not clear enough. Please clarify the > critera properly. > Do you mean it would sum is all the criteria is met or sum only the cells > that meet the criteria. > > Cheers, > Andy > > On Wed, Jul 20, 2011 at 1:15 AM, kaushik modak > wrote: > >> Hello Guys, >> >> Please help me to get to result in the attached. >> I have tried with sumifs, if etc., but not getting the accurate result. >> >> Regards, >> Kaushik >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > > Warm Regards, > Aindril De > Unified Learning Pvt Ltd. > Ph: 9811300157 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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 sumifs solution by ankur.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$
*thnks sir *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Jul 12, 2011 at 6:59 PM, Rajan_Verma wrote: > Nice > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Tuesday, July 12, 2011 6:54 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ > > HI AZEEM > plz find the attached file, i had used conditional formatting > explanation is one the sheet > tell me if it helps you. > > On 12/07/2011, Azeem Quraishi (HAB5) wrote: > > Hi Perfects > > > > > > > > I need help from you, I have one excel sheet with more Data when I > > want to search data I am using "CONTROL+F typing in the control box > > particular number then selecting same. > > > > > > > > I need to hide other data except searching shout b on screen. > > > > > > > > > > > > Hope you will give me better tips > > > > > > > > Best Regards > > > > > > > > > > > > > > > > Syed Azeem Quraishi > > > > Engineering Dept. H5-Project > > > > > > > > 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 > > > > > -- > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > -- > > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and > Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$
HI AZEEM plz find the attached file, i had used conditional formatting explanation is one the sheet tell me if it helps you. On 12/07/2011, Azeem Quraishi (HAB5) wrote: > Hi Perfects > > > > I need help from you, I have one excel sheet with more Data when I want > to search data I am using "CONTROL+F typing in the control box > particular number then selecting same. > > > > I need to hide other data except searching shout b on screen. > > > > > > Hope you will give me better tips > > > > Best Regards > > > > > > > > Syed Azeem Quraishi > > Engineering Dept. H5-Project > > > > 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 > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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 solution by ankur.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Convert HTML file to Excel
*hi shree see below link to convert html to excel may this help u http://www.mrkent.com/tools/converter/ http://www.designdetector.com/archives/05/07/HTMLToExcelTheEasyWay.php *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 11, 2011 at 5:11 PM, SHREE wrote: > Thanks Vasant Its working fine, Please can you also advise coding for > only converting HTML file into Excel... > > > On Jul 8, 2:16 pm, SHREE wrote: > > Thanks Vasant Its working fine, Please can you also advise coding for > > only converting HTML file into Excel... > > > > On Jul 6, 8:57 pm, Vasant wrote: > > > > > > > > > Hi > > > > > Pls find the code and the file attached. > > > The html files stored in the folder 'Folder' will be used for the > report. > > > > > Sub Test() > > > Dim Fs As New FileSystemObject, Fl As File > > > Dim Fld As Folder, FolderPath As String > > > Dim WkBk As Workbook, DtWkBk As Workbook > > > Set WkBk = Workbooks.Add > > > NoShts = WkBk.Worksheets.Count > > > WkBk.SaveAs Filename:="Report" > > > > > FolderPath = ThisWorkbook.Worksheets("Sheet1").Range("B1") > > > Application.DisplayAlerts = False > > > Set Fld = Fs.GetFolder(FolderPath) > > > Cn = 1 > > > For Each fls In Fld.Files > > > If fls.Type = "HTML Document" Then > > > Debug.Print fls.Type > > > Workbooks.Open Filename:=fls.Name > > > ActiveSheet.Cells.Copy > > > If Cn <= NoShts Then > > > WkBk.Worksheets(Cn).Activate > > > ActiveSheet.Paste > > > ActiveSheet.Name = Left(fls.Name, Len(fls.Name) - 4) > > > Cn = Cn + 1 > > > Else > > > WkBk.Worksheets.Add > > > Cn = Cn + 1 > > > WkBk.Worksheets(Cn).Activate > > > ActiveSheet.Paste > > > ActiveSheet.Name = Left(fls.Name, Len(fls.Name) - 4) > > > > > End If > > > End If > > > > > Next > > > > > Application.DisplayAlerts = True > > > > > End Sub > > > > > On Wed, Jul 6, 2011 at 4:59 PM, Chidurala, Shrinivas < > > > > > shrinivas.chidur...@citi.com> wrote: > > > > Dear Excel Gurus, > > > > > > I have some HTML files which are saved in same folder and I want to > convert > > > > them into Excel and merger the all files into 1 workbook. Please help > me to > > > > create the macro for the same. Find attached 2 HTML files and > required > > > > report. > > > > > > Regards, > > > > Shrinivas > > > > > > -- > > > > > > > ------ > > > > 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 > > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > Like our page on facebook , Just follow below link > > > >http://www.facebook.com/discussexcel > > > > > -- > > > Regards > > > > > Vasant > > > > > skype Id: vasantjobhttp://facebook.com/vasantjob > > > > > Code.xlsm > > > 23KViewDownload- Hide quoted text - > > > > > - Show quoted text -- 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 > > <><><><><><><><><><><><><><><><><><><><><><> > 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$$ vlookup query
* *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- Forwarded message ------ From: ankur Date: Mon, Jul 11, 2011 at 4:38 PM Subject: Re: $$Excel-Macros$$ vlookup query To: PRADEEP KUMAR KOKNE *hi pradeep plz find the attached file.hope this is what u needed... see "macro file" for solution. i m not so good in vba , but just tried to solve it...let me know if it helps u * * *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 11, 2011 at 2:22 PM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > > Hi > > Can some one write a macro as per the attach files. > > i need a loop fo > > On Mon, Jul 11, 2011 at 11:37 AM, ankur wrote: > >> *where is query? >> *Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> >> On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas < >> venkateshs@gmail.com> wrote: >> >>> please shoot your query >>> >>> >>> On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE < >>> pradeepkumar...@gmail.com> wrote: >>> >>>> I have a some query regarding the vlookup can somebody help >>>> >>>> -- >>>> >>>> -- >>>> 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 >>> Venkatesh KS >>> Phone: +91 98419 69353 >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solution By Ankur.rar Description: application/rar
Re: $$Excel-Macros$$ need help
*can u explain ur requirement with a sample file?, i m not getting it properly *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sun, Jul 10, 2011 at 10:10 PM, Rajan_Verma wrote: > *Which is the Column of Client Name.??* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *syed aliya raza hashim > *Sent:* Saturday, July 09, 2011 1:10 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ need help > > ** ** > > Hi, > > Hi , > > I have the two client sheet one for Genentech and Other one is lifetech but > in different tab I want in single tab what I want a check box should be > there when to select *Genentech* the data of that particular client should > appear same as with* Lifetech* > > > > -- > syed aliya > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup query
*where is query? *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas < venkateshs@gmail.com> wrote: > please shoot your query > > > On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE < > pradeepkumar...@gmail.com> wrote: > >> I have a some query regarding the vlookup can somebody help >> >> -- >> >> -- >> 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 > Venkatesh KS > Phone: +91 98419 69353 > > -- > > -- > 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$$ Help regarding bank statment
*hi LK modi use this simpler formula =LOOKUP(2,1/(A1:A10=A2),B1:B10) file is attached *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote: > HOPE THIS MIGHT BE USEFUL. > > > On 8 July 2011 10:09, L.K. Modi wrote: > >> 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 >> > > -- > > -- > 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 bank statement.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help on Chart
*hi atul dynamic chart preparation can help have a look link below http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/ *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 12:11 PM, Atul Kesaria wrote: > Hello Team, > > I am preparing chart basis certain data. However wanted to check some > way to prepare the chart only on the data which reflect in the excel > sheet post i do a filter. So as soon as I change the filter the chart > should change. > > Do let me know if that can be done. > > Cheers > Atul > > -- > > -- > 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$$ help regarding date formula
*ok sir *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote: > 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 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 > -- -- 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$$ Converting Text Case By VBA
*dear friends plz check the attached file for changing the text case of selected range *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 10:23 AM, anandydr wrote: > Dear STDEV(i), > > As you say text case can be converted to Proper Case using VBA but > wont be using Application.Function/Worksheet Function give faster > results as compared to this other method? > > Warm regards, > Anand Kumar > > On Jul 7, 6:02 am, "STDEV(i)" wrote: > > Converting text case to ProperCase in VBA > > > > alt: > > Instead of using Application.Function / WorksheetFunction) we can also > use > > VBA function: > > *StrConv *function > > > > StrConv(" ", vbProperCase) > > > > Example in sub procedur > > > > Sub ConvertProperCase() > >Application.ScreenUpdating = False > >Dim Cell As Range > >For Each Cell In Selection.Cells > > If Not Cell.HasFormula Then > > Cell.Value = *StrConv(Rng, vbProperCase)* > > End If > >Next Cell > >Application.ScreenUpdating = True > > End Sub > > > > Thank you > > > > On Thu, Jul 7, 2011 at 3:18 AM, Rajan_Verma >wrote: > > > > > > > > > > > > > > > > > > http://excelpoweruser.blogspot.com/2011/07/hiding-data-on-worksheet.h... > > > *** > > > > > ** ** > > -- > > -- > 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 all change case.xlsm Description: Binary data
Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet
*HI VASANT thanks a lot code is working fine in my main data file... this is what i needed u had saved my time and efforts.. thnks again *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 12:42 AM, Rajan_Verma wrote: > *Try this* > > * * > > *Sub MailMerge()* > > *Application.DisplayAlerts = False* > > *Application.ScreenUpdating = False* > > *On Error Resume Next* > > *Dim Form As Worksheet* > > *Dim detail As Worksheet* > > *Dim sh As Worksheet* > > * * > > *Dim rng As Range* > > *Dim cell As Range* > > * * > > *For Each sh In ActiveWorkbook.Sheets* > > *If sh.Name <> "Form" And sh.Name <> "Details" Then sh.Delete* > > *Next* > > * * > > * * > > *Set Form = Sheets("Form")* > > *Set detail = Sheets("Details")* > > *Set rng = detail.Range("A2:A" & detail.UsedRange.Rows.Count)* > > * * > > *result = MsgBox("Do you want to Generate " & detail.Range("F5").Value - > detail.Range("E5").Value + 1 & " Records ", vbYesNo)* > > *If result = 6 Then* > > ** > > *For i = detail.Range("e5").Value + 1 To detail.Range("F5").Value > + 1* > > *Form.Range("b6").Value = detail.Range("A" & i).Offset(0, 2).Value > & detail.Range("A" & i).Offset(0, 3).Value* > > *Form.Range("b7").Value = detail.Range("A" & i).Offset(0, 2).Value > & detail.Range("A" & i).Value* > > *Form.Cells.Copy* > > *Sheets.Add Form* > > *ActiveSheet.Paste* > > *ActiveSheet.Name = detail.Range("A" & i).Value* > > *Application.CutCopyMode = False* > > ** > > *Next* > > *End If* > > *detail.Activate* > > *Application.DisplayAlerts = False* > > *Application.ScreenUpdating = False* > > *End Sub* > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Jai > *Sent:* Wednesday, July 06, 2011 10:45 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Maill Merge in Two Excel Sheet > > ** ** > > Dear Experts > > > > i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name, > Desination, & Emp code . > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Query
* *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 6:05 PM, ankur wrote: > *hi ashish sir > may this help u ... > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Wed, Jul 6, 2011 at 5:30 PM, ashish koul wrote: > >> >> >> On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: >> >>> Dear Experts, >>> >>> For this chart >>> >>> 3001-5000 = 30 >>> 5001-6000 = 40 >>> 6001-7000 = 45 >>> 7001-8000 = 50 >>> 8001-9000 = 50 >>> 9001-15000 = 110 >>> 15001-25000 = 130 >>> 25001-4 = 150 >>> 40001>= =200 >>> >>> I use this formula: >>> >>> >>> >>> =IF(AND(D16>=3001,D16<=5000),30,IF(AND(D16>=5001,D16<=6000),40,IF(AND(D16>=6001,D16<=7000),45,IF(AND(D16>=7001,D16<=8000),50,IF(AND(D16>=8001,D16<=9000),90,IF(AND(D16>=9001,D16<=15000),110,IF(AND(D16>=15001,D16<=25000),130,IF(AND(D16>=25001,D16<=4),150,IF(AND(D16>=40001),200,0) >>> >>> Is their any other short/intelligent way to get desired result? >>> >>> Please help >>> >>> Thanks in advance >>> >>> Kalyan >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> http://akoul.posterous.com/ >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need formula for Current Date Access
* my pleasure *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed wrote: > Dear Ankur, > > Its working fine. Thank you very much. > > Regards, > Idhrees. > > On Tue, Jul 5, 2011 at 3:46 PM, ankur wrote: > >> *You can create a form, by using the IIF function in Control Source >> property...Of the field which required >> >> =IIf([Valid date]=Date(),"valid","expired") >> >> one sample file is attached... >> >> >> *Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> >> >> On Tue, Jul 5, 2011 at 12:35 PM, Idhrees Mohamed wrote: >> >>> Dear Friends, >>> >>> I need a help to access query for current date. >>> >>> I have an column with name valid date. I need a formula for validity date >>> less than current date, its shown "valid otherwise "expired" like that. >>> Please help me the ms access fuction for this. >>> >>> -- >>> Thanks & Regards, >>> >>> Mohamed Idhrees. S. >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & Regards, > > Mohamed Idhrees. S. > > -- > > -- > 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$$ help regarding date formula
* hi L K modi use this formula in d4 =EOMONTH(C4,0)+5 *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma wrote: > *Use this in D4* > > *=DATE(YEAR(C4),MONTH(C4)+1,5)* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *L.K. Modi > *Sent:* Thursday, July 07, 2011 10:26 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ help regarding date formula > > ** ** > > 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 > -- -- 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$$ Re: Query
*hi ashish sir may this help u ... *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 5:30 PM, ashish koul wrote: > > > On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: > >> Dear Experts, >> >> For this chart >> >> 3001-5000 = 30 >> 5001-6000 = 40 >> 6001-7000 = 45 >> 7001-8000 = 50 >> 8001-9000 = 50 >> 9001-15000 = 110 >> 15001-25000 = 130 >> 25001-4 = 150 >> 40001>= =200 >> >> I use this formula: >> >> >> >> =IF(AND(D16>=3001,D16<=5000),30,IF(AND(D16>=5001,D16<=6000),40,IF(AND(D16>=6001,D16<=7000),45,IF(AND(D16>=7001,D16<=8000),50,IF(AND(D16>=8001,D16<=9000),90,IF(AND(D16>=9001,D16<=15000),110,IF(AND(D16>=15001,D16<=25000),130,IF(AND(D16>=25001,D16<=4),150,IF(AND(D16>=40001),200,0) >> >> Is their any other short/intelligent way to get desired result? >> >> Please help >> >> Thanks in advance >> >> Kalyan >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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 solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet
*HI VASANT THNKS FOR UR EFFORTS EmpCode = ThisWorkbook.Worksheets("Sheet2").Cells(x, 1)..this code is not working U R GETTING IN RIGHT DIRECTION, NOW I NEED... THE STAFF NO OF NEXT EMPLOYEE GET CHANGED AND THE RESULT GET PASTED IN SHEET2MEANS AUTO CHANGING OF DATA VALIDATION HAPPENS...AND RESULT GET PASTED IN THE SHEETS thnks *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 3:00 PM, Vasant wrote: > Hi Ankur, > > Not sure, whether i understood your query completly... > > Pls find this code > > This code takes the staff no. from Sheet2 and puts in "A2" in the > 'gents report" sheet. It then picks up the result from "C2" cell > of the same sheet and puts into the income tax column for the > corresponding staff code. > > > Sub Test() > Lrow = ThisWorkbook.Worksheets("Sheet2").Range("A65536").End(xlUp).Row > For x = 2 To Lrow > EmpCode = ThisWorkbook.Worksheets("Sheet2").Cells(x, 1) >ThisWorkbook.Worksheets("gents report").Range("A2") = EmpCode >It = ThisWorkbook.Worksheets("gents report").Range("C2") >ThisWorkbook.Worksheets("Sheet2").Cells(x, 3) = It > Next x > End Sub > > > On Wed, Jul 6, 2011 at 1:20 PM, ankur < ankurpande...@gmail.com> wrote: > > HI VASANT > > PLZ FIND THE ATTACHED FILE > > this is sample file...full data can't be attached becoz of file size..... > > > > Have A Nice Time & Enjoy Life > > > > Regards: > > CMA Ankur Pandey > > (Someone Different) > > > > I'm not the best but i'm not like the rest~~ > > > > > > On Wed, Jul 6, 2011 at 12:49 PM, Vasant wrote: > >> > >> Hi Ankur, > >> > >> Glad to help you. Pls send me your file...let me try :) > >> > >> On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote: > >> > hi vasant > >> > thnks for such nice code > >> > i have similar problem also...but i need some modification > >> > this code produce many workbook...cant it be possible to create a > >> > single > >> > workbook with different sheets for each employee ? > >> > > >> > another query > >> > > >> > i have asked one query earlier about data validation requirement, can > u > >> > help > >> > me in that also > >> > im just giving my requirement.plz help me > >> > i have a workbook for calculating income tax of employees with many > >> > sheets,different sheets are having monthwise data of > >> > employeesone > >> > sheet for their saving particularsone main sheet in which all the > >> > calculation are done...and their net tax is calculated by getting data > >> > from > >> > the sheetslike form 16 > >> > i used data valiation in the to get details of each employee in the > >> > main > >> > sheet( by linking with vlookup and other formulas) i need one > report > >> > which show > >> > net income tax of each employee in one sheet...like > >> > employee name---income tax > >> > 25415 > >> > 5486 > >> > > >> > for that i have to manually change the data validation list from drop > >> > down...the income tax which came , i copy and paste in other > sheet.i > >> > have to do this for all the employees.this take lot of time > >> > > >> > i want just by one click i got all the income tax data of all the > >> > employees > >> > whose name is in data validation listin another sheet. > >> > > >> > can u help me...? > >> > > >> > Have A Nice Time & Enjoy Life > >> > > >> > Regards: > >> > CMA Ankur Pandey > >> > (Someone Different) > >> > > >> > I'm not the best but i'm not like the rest~~ > >> > > >> > > >> > On Wed, Jul 6, 2011 at 11:45 AM, Vasant wrote: > >> >> > >> >> Hi Jai, > >> >> > >> >> Pls find the below code and the file attached. > >> >> > >> >> The code here creates a new workbook for each employee with their > >> >> details and saves them with their name and code. > >> >> >
Re: $$Excel-Macros$$ Sum based on conditional formatting
*HI LK MODI USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU USE THIS UDF, U CAN SEE THE CODE IN MODULE =ColorFunction($B$30,$B$2:$B$27,TRUE) WHERE B30 CELL IS HAVING COLOUR OF THE CONDITIONAL FORMATING FILE IS ATTACHED FOR UR REFERENCE *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 3:48 PM, L.K. Modi wrote: > 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 > -- -- 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 SOLVED.xlsm Description: Binary data
Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help
hi Noorain Ansari very good formula.can u explain me what "*" had make difference in this formula. use of "*" in formula had done what magic..i will also use this in other formulas in future Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > > On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > >> -- >> >> -- >> >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help
*hi jai find the attached filethis has slight modification of venkatesan solution...the repeat of name is taken care , as u required tell me it helps? *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 3:16 PM, Venkatesan c wrote: > Hi Jai, > > Look Attached below.. > > > > > On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Best Regards,* > *Venkat* > * > * > * > * > > > -- > > -- > 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 VLOOKUP Resolved2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet
*hi vasant thnks for such nice code i have similar problem also...but i need some modification this code produce many workbook...cant it be possible to create a single workbook with different sheets for each employee ? another query i have asked one query earlier about data validation requirement, can u help me in that also im just giving my requirement.plz help me i have a workbook for calculating income tax of employees with many sheets,different sheets are having monthwise data of employeesone sheet for their saving particularsone main sheet in which all the calculation are done...and their net tax is calculated by getting data from the sheetslike form 16 i used data valiation in the to get details of each employee in the main sheet( by linking with vlookup and other formulas) i need one report which show net income tax of each employee in one sheet...like employee name---income tax 25415 5486 for that i have to manually change the data validation list from drop down...the income tax which came , i copy and paste in other sheet.i have to do this for all the employees.this take lot of time i want just by one click i got all the income tax data of all the employees whose name is in data validation listin another sheet. can u help me...? *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 11:45 AM, Vasant wrote: > Hi Jai, > > Pls find the below code and the file attached. > > The code here creates a new workbook for each employee with their > details and saves them with their name and code. > > > Sub Test() > Dim NwWkBk As Workbook > Lrow = ThisWorkbook.Worksheets(2).Range("A65536").End(xlUp).Row > For x = 2 To Lrow > Set NwWkBk = Workbooks.Add > ThisWorkbook.Worksheets(1).Cells.Copy > NwWkBk.Worksheets(1).Activate > ActiveSheet.Paste > ActiveSheet.Range("A1").EntireColumn.ColumnWidth = > ThisWorkbook.Worksheets(1).Range("A1").ColumnWidth > ActiveSheet.Range("B1").EntireColumn.ColumnWidth = > ThisWorkbook.Worksheets(1).Range("B1").ColumnWidth > ActiveSheet.Range("C1").EntireColumn.ColumnWidth = > ThisWorkbook.Worksheets(1).Range("C1").ColumnWidth > ActiveSheet.Range("D1").EntireColumn.ColumnWidth = > ThisWorkbook.Worksheets(1).Range("D1").ColumnWidth > > NwWkBk.Worksheets(1).Range("B6") = > ThisWorkbook.Worksheets(2).Range("B" & Trim(Str(x))) > NwWkBk.Worksheets(1).Range("B7") = > ThisWorkbook.Worksheets(2).Range("C" & Trim(Str(x))) & " " & > ThisWorkbook.Worksheets(2).Range("A" & Trim(Str(x))) > NwWkBk.SaveAs ThisWorkbook.Worksheets(2).Range("B" & Trim(Str(x))) & > "(" & ThisWorkbook.Worksheets(2).Range("A" & Trim(Str(x))) & ")" > Next x > End Sub > > > On Wed, Jul 6, 2011 at 10:45 AM, Jai wrote: > > Dear Experts > > > > i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name, > > Desination, & Emp code . > > > > -- > > > -- > > 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 > > Vasant > > skype Id: vasantjob > vasant...@gmail.com > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email
Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet
*hi jai do u want print out of sheet 1 after having Name, Designation, & Emp code of each employee*? Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 11:17 AM, ashish koul wrote: > HI jAI > > do you want to send this form as attachment to emp ids mentioned in sheet 2 > ? > > r u using lotus notes or outlook. > > > > > > On Wed, Jul 6, 2011 at 10:45 AM, Jai wrote: > >> Dear Experts >> >> i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name, >> Desination, & Emp code . >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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$$ select row which have specified data
*hi rajesh i used formulas in sheet 1 , to get data from sheet 2 just enter your data in sheet 2, it will be displayed against the date in sheet 1 may this may help u find attached file *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Jul 5, 2011 at 6:23 PM, ashish koul wrote: > try this > > Sub test() > Dim i As Long > For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row > If DateValue(Sheets(1).Cells(i, 1).Value) = > DateValue(Sheets(2).Range("a1").Value) Then > k = Sheets(2).Range("iv2").End(xlToLeft).Column + 1 > > For j = 2 To 11 > Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value > > Next j > ' use exit for if u dnt want to search any more > Exit For > > End If > Next i > End Sub > > > On Tue, Jul 5, 2011 at 5:53 PM, Rajesh K R wrote: > >> Hi Experts, >> >> Please find the attached file & tell me the code how to select the >> date value in "sheet2" cell "A1" in Sheet 1. After selecting the row >> then all the data in sheet2 range("B2:B11") have to copy & paste in >> the sheet1 colomns("B:K"). >> >> Regards >> >> Rajesh Kainikkara >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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 SOLUTION OF FIND(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ copy data without opening file
hi hanumant you may find this to be useful http://spreadsheetpage.com/index.php...a_closed_file/<http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/> [image: Reply With Quote]<http://www.excelforum.com/newreply.php?do=newreply&p=2079066> Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote: > Hi friends, > > is there any way where we can copy data from closed workbook "A" and paste > it > into workbook "B" which is open? > > -- > > -- > 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$$ count unique values
*hi * all of these are array formulas The following formulas will return the number of distinct items in the range B2:B11. . The following formula is the longest but most flexible. It will properly count a list that contains a mix of numbers, text strings, and blank cells. =SUM(IF(FREQUENCY(IF(LEN(B2:B11)>0,MATCH(B2:B11,B2:B11,0),""), IF(LEN(B2:B11)>0,MATCH(B2:B11,B2:B11,0),""))>0,1)) If your data does not have any blank entries, you can use the simpler formula below. =SUM(1/COUNTIF(B2:B11,B2:B11)) If your data does have embedded blank cells within the full range, you can use the following array formula: =SUM(1/IF(B2:B11="",1,(COUNTIF(B2:B11,B2:B11-COUNTBLANK(B2:$B11) If your data has *only* numeric values or blank cells (no string text entries), you can use the following formula: =SUM(N(FREQUENCY(B2:B11,B2:B11)>0)) Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Jul 5, 2011 at 10:37 AM, Dilip Pandey wrote: > Nice explanation Haseeb (HTH).. !! > > Regards, > DILIPandey > > > On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Hello AIren, >> >> Consider B1:B6 we have these values; >> >> B1=1 >> B2=1 >> B3=Blank >> B4=A >> B5=Blank >> B6=Blank >> >> =SUMPRODUCT((B1:B6<>"")/**COUNTIF(B1:B6,B1:B6&"")) >> >> Firstly take (B1:B6<>"") >> >> This will check B2:B30 is blank or not, If it is blank will give FALSE, if >> not will give TRUE. So will get like this >> >> {TRUE;TRUE;FALSE;TRUE;FALSE;FALSE} >> >> First 2 cells are not blank;3rd one is blank, 4th one is not blank;5th & >> 6th are blank >> >> COUNTIF(B1:B6,B1:B6&"") >> >> This will count B1:B6 against the same range B1:B6. So will get the count >> of the occurances of each values in the range. >> >> If you are adding *&"" *this will add a non zero length text value to the >> every cells. So blank will become a non zero length text value. If you are >> not adding &"" this will give you a #DIVO/0! error. Because all the count of >> blank cells will count as 0 >> >> Without &"", the array will be, >> >> [2;2;0;1;0;0} >> >> With &"", the array will be, >> >> {2;2;3;1;3;3} >> >> See, All blank cells is changed to 3, count of all the blank cells in the >> range. >> >> First 2 cells counts are 2 (First cell value & 2nd cell value should be >> same);3rd one is blank;4th ones count is 1;5th & 6th cells are blank >> >> So, the Arry in SUMP will become; >> >> SUMPRODUCT({TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}/{2;2;3;1;3;3}) >> >> TRUE will converted to 1 >> FALSE will to 0 >> >> So, here; >> >> {1/2;1/2;0/3;1/1;0/3;0/3} >> >> Which is; >> >> {0.5;0.5;0;1;0;0} >> >> {0.5+0.5+0+1+0+0} >> >> =2 >> >> See the below link more about SUMPRODUCT; >> >> http://www.xldynamic.com/source/xld.SUMPRODUCT.html >> >> HTH >> Haseeb >> >> >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp >MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > -- > 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$$ Request for instruction
*hi sant ram plz check links below for sumproduct http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ for array formulas http://www.cpearson.com/excel/ArrayFormulas.aspx for substitute http://www.excelitems.com/2010/05/substitute-function.html *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 4, 2011 at 11:43 PM, Sant Ram wrote: > Hey, > > > please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's > > how to use and instruction > > > -- > Regards, > Santy C > > -- > > -- > 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$$ need required for data validation value query
*hi rajan thnks for such nice helps ... due to size & sensitive data in file i cant upload them cant be there any vba codes for auto change in data validation list one by one , and the result which came ,get pasted in other sheets.this is what i needed... i just want results get pasted in other sheet, by auto change of data validation. like this first a macro change the data validation , and then paste the value in other sheet in front of data validation value( by using lookup or vlookup function ofcourse)and then repeat this process till the end of data validation list .u can use combo box for this.also... * * *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 4, 2011 at 9:29 PM, Rajan_Verma wrote: > You should attached all Sheets so that I can Link Main Sheet with each > other. > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Monday, July 04, 2011 2:06 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ need required for data validation value query > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Mon, Jul 4, 2011 at 12:08 PM, ankur wrote: > > file attachedagain forget to attach file Have A Nice Time & Enjoy > > Life > > > > Regards: > > CMA Ankur Pandey > > (Someone Different) > > > > I'm not the best but i'm not like the rest~~ > > > > > > > > On Mon, Jul 4, 2011 at 11:53 AM, ankur wrote: > >> thnks rajan this is what i needed > >> this is really very nice of youit ease my work load... > >> > >> now one more queryin attached file...sheet "gents report"cell > >> C2 value should get pasted in sheet "gents"...in the front of row > >> having staff no.. > >> example is shown..if income tax calculation show "error"...ignore > >> that data for pasting .. > >> > >> Have A Nice Time & Enjoy Life > >> > >> Regards: > >> CMA Ankur Pandey > >> (Someone Different) > >> > >> I'm not the best but i'm not like the rest~~ > >> > >> > >> > >> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma > wrote: > >>> See if it helps > >>> > >>> -Original Message- > >>> From: excel-macros@googlegroups.com > >>> [mailto:excel-macros@googlegroups.com] > >>> On Behalf Of ankur > >>> Sent: Friday, July 01, 2011 5:17 PM > >>> To: excel-macros > >>> Subject: Re: $$Excel-Macros$$ need required for data validation > >>> value query > >>> > >>> sorry , i forget to attach a sample file in my query.. > >>> Have A Nice Time & Enjoy Life > >>> > >>> Regards: > >>> CMA Ankur Pandey > >>> (Someone Different) > >>> > >>> I'm not the best but i'm not like the rest~~ > >>> > >>> > >>> > >>> On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote: > >>>> hi ayush/ all members > >>>> > >>>> i have one data validation list, which is required in formula to > >>>> get a result i want the all results corresponding to each > >>>> value in different sheet or in different column in one click any > >>>> macro code is there ? > >>>> > >>>> thanks in advance > >>>> > >>>> Have A Nice Time & Enjoy Life > >>>> > >>>> Regards: > >>>> CMA Ankur Pandey > >>>> (Someone Different) > >>>> > >>>> I'm not the best but i'm not like the rest~~ > >>>> > >>>> -- > >>>> --- > >>>> --- > >>>> > >>>> 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 h
Re: $$Excel-Macros$$ querry 5
hi Nemi Gandhi use this formula in cell F4 of your table and than sort it by column F shortest to largestyou will table as per your need *=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5* Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 4, 2011 at 5:04 PM, Nemi Gandhi wrote: > Formula needed please. > > -- > Nemi Gandhi > 98204 92963 > > -- > -- > 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$$ need required for data validation value query
Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jul 4, 2011 at 12:08 PM, ankur wrote: > file attachedagain forget to attach file > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Mon, Jul 4, 2011 at 11:53 AM, ankur wrote: >> thnks rajan this is what i needed >> this is really very nice of youit ease my work load... >> >> now one more queryin attached file...sheet "gents report"cell >> C2 value should get pasted in sheet "gents"...in the front of row >> having staff no.. >> example is shown..if income tax calculation show "error"...ignore >> that data for pasting .. >> >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> >> >> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma wrote: >>> See if it helps >>> >>> -Original Message- >>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >>> On Behalf Of ankur >>> Sent: Friday, July 01, 2011 5:17 PM >>> To: excel-macros >>> Subject: Re: $$Excel-Macros$$ need required for data validation value query >>> >>> sorry , i forget to attach a sample file in my query.. >>> Have A Nice Time & Enjoy Life >>> >>> Regards: >>> CMA Ankur Pandey >>> (Someone Different) >>> >>> I'm not the best but i'm not like the rest~~ >>> >>> >>> >>> On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote: >>>> hi ayush/ all members >>>> >>>> i have one data validation list, which is required in formula to get >>>> a result i want the all results corresponding to each value in >>>> different sheet or in different column in one click any macro code is >>>> there ? >>>> >>>> thanks in advance >>>> >>>> Have A Nice Time & Enjoy Life >>>> >>>> Regards: >>>> CMA Ankur Pandey >>>> (Someone Different) >>>> >>>> I'm not the best but i'm not like the rest~~ >>>> >>>> -- >>>> -- >>>> >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ >>>> http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>>> and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and >>> Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> -- >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> > -- -- 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 1revised Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need required for data validation value query
thnks rajan this is what i needed this is really very nice of youit ease my work load... now one more queryin attached file...sheet "gents report"cell C2 value should get pasted in sheet "gents"...in the front of row having staff no.. example is shown..if income tax calculation show "error"...ignore that data for pasting .. Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma wrote: > See if it helps > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Friday, July 01, 2011 5:17 PM > To: excel-macros > Subject: Re: $$Excel-Macros$$ need required for data validation value query > > sorry , i forget to attach a sample file in my query.. > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote: >> hi ayush/ all members >> >> i have one data validation list, which is required in formula to get >> a result i want the all results corresponding to each value in >> different sheet or in different column in one click any macro code is >> there ? >> >> thanks in advance >> >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> -- >> -- >> >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >> and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and > Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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$$ Re: required open xl addin
thnks Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sun, Jul 3, 2011 at 12:33 PM, OpenExcel.com <26may.1...@gmail.com> wrote: > http://openexcel.googlecode.com/files/OPEN_XL.zip > > Best Regards > Ashish Jain > http://www.eXceLitems.com > http://www.OpenExceL.com > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ I want to learn VBA
hi kurikkal get files from the link below, i had uploaded there. i tried to attach files but due to excess size of files, it cant be attached . http://cmaankur.webs.com/apps/documents/ Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jul 2, 2011 at 1:02 PM, ankur wrote: > hi kurikkal > have this file.. > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Sat, Jul 2, 2011 at 12:54 PM, ankur wrote: >> hi kurikkal >> have this files... >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> >> >> On Fri, Jul 1, 2011 at 9:24 PM, ashish koul wrote: >>> try thse video tutorial and websites >>> http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ >>> http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ >>> >>> >>> On Fri, Jul 1, 2011 at 1:34 PM, kurikkal padinjarappalla >>> wrote: >>>> >>>> please attach it >>>> >>>> On Fri, Jul 1, 2011 at 10:43 AM, ankur wrote: >>>>> >>>>> Dear friends >>>>> I m agree that , the sites you all recommended are very useful ,but >>>>> for a new user , the best way to learn VBA is getting a book dedicated >>>>> on vba...becoz they provide step wise and detailed concepts >>>>> there are many free ebooks on vba on the internet.download it >>>>> ...learn basic from there ...and then make reference from this sites >>>>> to learn more... >>>>> i have books if u need i can attach here... >>>>> >>>>> Have A Nice Time & Enjoy Life >>>>> >>>>> Regards: >>>>> CMA Ankur Pandey >>>>> (Someone Different) >>>>> >>>>> I'm not the best but i'm not like the rest~~ >>>>> >>>>> >>>>> >>>>> On Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c >>>>> wrote: >>>>> > >>>>> > >>>>> > Hi Pooja, >>>>> > Just watch the below link Youtube video's you may get VBA >>>>> > Basic&Advancedconcepts >>>>> > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb >>>>> > >>>>> > Best Regards, >>>>> > Venkat >>>>> > >>>>> > On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma >>>>> > >>>>> > wrote: >>>>> >> >>>>> >> Hi All, >>>>> >> >>>>> >> I want to learn VBA, therefore, could anybody suggest with a good link >>>>> >> where I can learn it. >>>>> >> >>>>> >> -- >>>>> >> Best Regards >>>>> >> Pooja Sharma >>>>> >> >>>>> >> -- >>>>> >> >>>>> >> >>>>> >> -- >>>>> >> Some important links for excel users: >>>>> >> 1. Follow us on TWITTER for tips tricks and links : >>>>> >> http://twitter.com/exceldailytip >>>>> >> 2. Join our LinkedIN group @ >>>>> >> http://www.linkedin.com/groups?gid=1871310 >>>>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >> >>>>> >> To post to this group, send email to excel-macros@googlegroups.com >>>>> >> >>>>> >> <><><><><><><><><><><><><><><><><><><><><><> >>>>> >> Like our page on facebook , Just follow below link >>>>> >> http://www.facebook.com/discussexcel >>>>> > >>>>> > >>>>> > >>>>> > -- >>>>>
Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)
hi Asish sir, Congrats...for this award...keep helping us like this thanks Best Regards, Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Jul 2, 2011 at 2:37 AM, Gyana Ranjan Das wrote: > Hi Ashish, > Congratulation for MVP award.Keep it up..! > > > > Thanks & Regards, > Gyana > > On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote: >> >> Dear Group, >> I am extremely happy to share a good news with you. One of our dearest >> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for >> his exceptional MS Excel skills and voluntary contribution. >> He is well deserving for the award and I am very happy and proud of his >> recognition. The guy has been top poster in the group from last 7-8 months. >> Let see who becomes the next MVP from the group. The group has now three >> active MVPs. >> >> Dear Ashish, >> Many Many congratulations for the award.I am very proud of you to be part >> of this group. >> Keep your valuable contribution to the group. I wish your long association >> with this group. >> Cheers !! >> Best Regards, >> Ayush Jain >> Group Manager >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ need required for data validation value query
hi rakesh thnks for reply this is not a simple vlookup formula case, i just want to get figure by changing validation list..because calculation is having many backhand formulas... well... i want you tell that...this income tax calculation sheet sample.the result which is showing is net income tax payable on month wise..so i have to calculate it manually and than use the tax amount in the employees payroll sheet.so i need only paste special value for data entry, how can i get value in different sheet , when i change data validation, Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 1, 2011 at 8:05 PM, ICWAI Help wrote: > > Please find the attached file. > > Thanks, > Rakesh. > On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote: >> >> I'm not sure if I understand what you want correctly. >> >> O2 cell in your sample file >> you can have the following formula >> =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) >> then do autofill .. >> Is this what you want? >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ need required for data validation value query
sorry , i forget to attach a sample file in my query.. Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote: > hi ayush/ all members > > i have one data validation list, which is required in formula to get > a result i want the all results corresponding to each value in > different sheet or in different column in one click > any macro code is there ? > > thanks in advance > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > -- > -- > 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 Book5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ need required for data validation value query
hi ayush/ all members i have one data validation list, which is required in formula to get a result i want the all results corresponding to each value in different sheet or in different column in one click any macro code is there ? thanks in advance Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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$$ I want to learn VBA
Dear friends I m agree that , the sites you all recommended are very useful ,but for a new user , the best way to learn VBA is getting a book dedicated on vba...becoz they provide step wise and detailed concepts there are many free ebooks on vba on the internet.download it ...learn basic from there ...and then make reference from this sites to learn more... i have books if u need i can attach here... Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c wrote: > > > Hi Pooja, > Just watch the below link Youtube video's you may get VBA > Basic&Advancedconcepts > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb > > Best Regards, > Venkat > > On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma > wrote: >> >> Hi All, >> >> I want to learn VBA, therefore, could anybody suggest with a good link >> where I can learn it. >> >> -- >> Best Regards >> Pooja Sharma >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > > > -- > > > > > > > > -- > Best Regards, > Venkat > > > > -- > -- > 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$$ required open xl addin
hi Ayush/ other members i need a very useful " open xl addin." i cant download it from the site,.. link is not working properly over there.. urgent need Have A Nice Time & Enjoy Life Regards:, CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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: Falha ao cancelar a mensagem: $$Excel-Macros$$ Recall: Help on Percentile Function
hi gilberto your file is undownloadable Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jun 20, 2011 at 10:44 PM, Gilberto wrote: > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract values from cell
hi kashan your sample data will be required for ad hoc solution Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sun, Jun 26, 2011 at 11:41 AM, Dilip Pandey wrote: > Hi Kashan, > > You can use following formula in column B and C respectively > > =SUBSTITUTE(A1,C1,"") > > =IF(VALUE(LEFT(MID(A1,SEARCH("ltr",A1)-1,50)))=0,MID(A1,SEARCH("ltr",A1)-2,50),MID(A1,SEARCH("ltr",A1)-1,50)) > > If you could provide some large set of data, that would have been > great to develop the full proof solution. As of now, spreadsheet is > attached to handle current situation :) > > Best Regards, > DILIPandey > > On 6/26/11, Kashan Abbas wrote: >> >> Hi guys , >> >> Is there any formula that can extract particullar values or text from cell >> .I want to extract the values not on the basis of position of the character >> becuase it can be easily done through left or right function .My creteria is >> value base let say i want to extract values from below illustrated dummy >> collumn .In this example my target is to separte the product name and >> packing size in next collumns as : >> >> Result want to be produced >> Column b collumn c >> deo3000 4lt >> deo3000 10ltr >> >> >> Availiable data >> Collumn A >> deo30004ltr >> deo300010ltr >> >> >> -- >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > -- > 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 Concatenate the Cell without loosing the format
hi ak file is attached for reference Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jun 30, 2011 at 3:10 PM, ankur wrote: > hi AK , use this formula, may it fullfill ur requirement use in F3 cell > =TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the plan)" > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Thu, Jun 30, 2011 at 11:51 AM, Venkatesan c wrote: >> >> Hi Ak, >> >> Find attached your query resolved >> >> Best Regards, >> Venkat >> >> On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote: >>> >>> Hi Experts, >>> >>> >>> >>> I want to concatenate the different cells without losing the format of the >>> cells. Please refer the excel sheet for more details. >>> >>> Thanking you in Advance. >>> >>> >>> >>> Regards, >>> >>> AK >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >> >> >> >> -- >> >> >> >> >> -- >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel concatenation query solved.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format
hi AK , use this formula, may it fullfill ur requirement use in F3 cell =TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the plan)" Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jun 30, 2011 at 11:51 AM, Venkatesan c wrote: > > Hi Ak, > > Find attached your query resolved > > Best Regards, > Venkat > > On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote: >> >> Hi Experts, >> >> >> >> I want to concatenate the different cells without losing the format of the >> cells. Please refer the excel sheet for more details. >> >> Thanking you in Advance. >> >> >> >> Regards, >> >> AK >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > > > -- > > > > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)
hi rajan this font is not showing in excel font dialog box, can u help Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Apr 30, 2011 at 9:12 AM, vaibhav joshi wrote: > > Hi Rajan > I have dwnld the file ,but unable use the font.It is not coming > Regards > Vaibhav Joshi > 91-9869069433 > On Fri, Apr 29, 2011 at 1:05 PM, rajan verma > wrote: >> >> Add the attached Font File and use ' for Rs Font.. >> >> On Fri, Apr 29, 2011 at 12:27 PM, vaibhav joshi >> wrote: >>> >>> Hello everybody >>> Can any one tell me how to insert New Rs font in currency format in >>> excel. >>> So that when ever i type any amt that should reflect & also to ensure >>> that i can use that cell for formula also >>> Regards >>> Vaibhav >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > > -- > -- > 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$$ Excel Charts/Pivots/VBA Newsletter
thnks dear.really useful stufffs Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Feb 9, 2011 at 3:56 PM, Tolontino Gomes wrote: > > > Can some one help me in the following problems with excel 2003? > > > > When I save file a .tmp file saves and when I delete again .tmp saves along > with the orginal .xls file > > > > Please help > > > > Reply me on tolontino.go...@pepsidrc.ae > > > > > > > > > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of OpenExcel.com > Sent: Wednesday, February 09, 2011 2:13 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter > > > > Hey Friends, > > > > Here is something interesting for you. Love is in the air, do some > automation and save your time for your loved ones. Hope this helps you :) > > > > > > > > 1. Collection of VBA Macros > > > > 2. Access a search Engine like Google, Bing or E-Bay on Internet Explorer > using VBA > > > > 3. Learn how to use VLOOKUP function. > > > > 4. Remove VBA Code using VBA > > > > 5. Export Excel Charts to Powerpoint > > > > 6. Embed Adobe Flash in MS Excel > > > > 7. Learn how to use ARRAY Formulas > > > > 8. Validate E-mail addresses > > > > 9. Schedule a VBA Macro > > > > 10. Speed up Excel Start up (FASTER EXCEL) > > > > 11. Shrink or Reduce Excel File Size (From MBs to KBs) > > > > > > > > > > > > > > > > Excel VBA Interview Questions Collection of Excel VBA > Macros VLOOKUP OFFSET ARRAY formulas > > > > Excel 2003 Style Menu in Excel 2007Custom Number Format > SUMIFS CONTACT a TRAINER > > > > > > > > Thanks & Regards > > > > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > > Facebook Twitter LinkedIn LiveJournal Digg Delicious Subscribe > to Email > > > > > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Shorting Problems
*thnks friends ,i was also looking this kind of solution *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 10, 2011 at 11:45 AM, hanumant shinde wrote: > Hi Sudhir, > > i have done this using macro. please find the attached. > 1. paste your data in col "A" from row 1 > 2. in sheet 2 there is 1 button click on it. you will get the desired > result. > > > -- > *From:* sudhir kumar > *To:* Excel Group > *Sent:* Wed, 9 February, 2011 4:29:13 PM > *Subject:* $$Excel-Macros$$ Shorting Problems > > Dear Frnd > > I have list which have many repeated names > i want short it with formula > > > thanx > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9818479722 > * > P think Before you print > * > * > ** > Life is Very beautiful !!! > * > * > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´. > * > * > * > *Happy **Valentine** Day * > \ ¦ / > (ò ó) > _ ___o0o___(_)___o0o__ > ___¦_¦_¦_¦_¦ > ¦_¦_¦_¦_¦__ > ___¦_¦_¦_¦_¦ > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: query for a solution
hi Prakash Singh Gusain and others experts thanks for your supportu all provide very helpful solution. thnks again Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 10, 2011 at 3:53 PM, Prakash Gusain wrote: > Hi Ankur, > > Please find the attached file for solution, I know you have already got the > solution from other experts. The only different thing you will find is > there NO NEED TO SORT DATA AS WELL! no matter were your unique id is in the > column it will give you the solution. > > The solution provided by Expert Umesh lacks this feature! > > Hope it made some contribution to learn something new as well :) > -- > Best Regards! > Prakash Singh Gusain > > Please visit my blog (click here) > > -- > -- > 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$$ Extracting Data from Multiple worksheets using 2 Criterias
hi SK attach one sample file for clear understanding On Fri, Jan 28, 2011 at 4:30 AM, SK wrote: > Hello Experts, > > I have a file which has 11 tabs. The 10 have same template with first > row being the heading. The 11th sheet is suppose to be used as a > summary report sheet that pulls data from the first 10 sheets based on > the following criteria: > > List all rows if business priority 1 or 2 (column A in each of the 10 > worksheets) > List all rows that have a Urgency of A ( even if it is listed with > business priority of 3 or 4) (column B in each of the 10 worksheets) > > So i have to use a combination of this criteria and then for all > projects where this criteria is applicable in each worksheet pull the > all the row data (only specific columns). Remember each row represents > a project with its current status. > > Can you please help ? > > I tired using VLOOKUP and INDEX/MATCH but this needs a code as far as > I can see. > > Please advice. > > Thank you, > > SK > > -- > -- > 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 > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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