Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Thanks alot Mr. Rajan This function is Perfectly as per my requirement. Thanks once again Amit Gandhi On Sat, Jun 23, 2012 at 6:45 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Amit, ** ** This function can work independently, you just need to understand the function Arguments : *Function* GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As Range, lngCOlumnresult As Long, lngMinusValue As Double) As *Double* rngLookUpRange = it is a value you want to look in table1 rngMapping = Select whole Table1 rngLookup =select the Table2 lngCOlumnresult = Which column you want to Sum from Table2 lngMinusValue = If you want to minus any value from the result formula at every iteration ** ** so if you are increasing column in table2 you also need to increase lngCOlumnresult value in the formula ** ** use the below function in *J15*: =GetTotal(G15,$A$8:$B$18,$F$4:$I$9,4,0) ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi *Sent:* 23 June 2012 5:19 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP ** ** Thanks Mr. Rajan ** ** For given set of values, its working perfectly. But I have some questions. ** ** 1. If values in H5:H9 are changed, then it doesn't give correct result.*** * ** ** Pls suggest function, which can work independently and doesn't depend on adjacent column. I am attaching modified task file for your quick reference. ** ** It will be a great help if you can suggest formula with inbuilt functions (INDIRECT, MATCH, SUMPRODUCT) as well. ** ** Regards ** ** Amit ** ** On Sat, Jun 23, 2012 at 1:38 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Amit, It will fulfil your requirement . J , See the attached. *Function* GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As Range, lngCOlumnresult As Long, lngMinusValue As Double) As *Double* Dim VarMapping Dim VarLookup Dim strLookUp *Dim lngResult As Double* Dim lngCounter As Long Dim StrLookupValue As String VarMapping = rngMapping VarLookup = rngLookup StrLookupValue = rngLookUpRange.Value strLookUp = For lngCounter = LBound(VarMapping) To UBound(VarMapping) If VarMapping(lngCounter, 1) = StrLookupValue Then strLookUp = strLookUp VarMapping(lngCounter, 2) | End If Next lngCounter For lngCounter = LBound(VarLookup) To UBound(VarLookup) If InStr(strLookUp, VarLookup(lngCounter, 1)) Then lngResult = lngResult + VarLookup(lngCounter, lngCOlumnresult) - lngMinusValue End If Next lngCounter GetTotal = lngResult End Function * * * * *Revert if it is not desired * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi *Sent:* 22 June 2012 5:20 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP Hi Experts I have two Input/Lookup tables, and 1 result table. I want a formula which can give me desired result instantly. Sample file is attached for your ready reference. How it will be possible? Pls help me here. Regards Amit -- -- 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
$$Excel-Macros$$ need help on maximum value and thier name
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 max.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need help on maximum value and thier name
PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com 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 the thread of 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 max(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need help on maximum value and thier name
Hi Sunita, In my case, I have used filters since it becomes more easier On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल tosune...@gmail.com wrote: did you filtre the column? thank you On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed waheedb...@gmail.comwrote: PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.comwrote: 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 the thread of 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
Re: $$Excel-Macros$$ need help on maximum value and thier name
Thanx :) On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi Sunita, In my case, I have used filters since it becomes more easier On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल tosune...@gmail.comwrote: did you filtre the column? thank you On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed waheedb...@gmail.comwrote: PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.comwrote: 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 the thread of 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
Re: $$Excel-Macros$$ Lookup problem
Dear Rajan, I sincerely express my gratitude to you for your kind help and support that you have extended towards me. Noorain , Your excellent guidance over MS Excel has proved to be of immense help to me in implementing my work. All the three options that you have taught me are working smoothly. You are a *Teacher* in the true sense of the word. Thanking you all once again. -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. 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, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Run Macro at OPEN of an Excel file
Hi Experts Pls help me with a way, so that a Macro runs whenever I open a particular excel file. (Macro is in that excel file only). Regards Amit -- -- 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$$ 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(AMATCH(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, सुनिता पौडेल tosune...@gmail.com wrote: Thanx :) On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed waheedb...@gmail.comwrote: Hi Sunita, In my case, I have used filters since it becomes more easier On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल tosune...@gmail.comwrote: did you filtre the column? thank you On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed waheedb...@gmail.comwrote: PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.comwrote: 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 the thread of 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)
Re: $$Excel-Macros$$ Run Macro at OPEN of an Excel file
Dear Amit, pest the code in the in vba Private Sub Workbook_Open() your code() End Sub On Mon, Jun 25, 2012 at 1:26 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts Pls help me with a way, so that a Macro runs whenever I open a particular excel file. (Macro is in that excel file only). Regards Amit -- -- 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$$ Run Macro at OPEN of an Excel file
Dear Amit, Please wirte your macro in Workbook Open Event Private Sub Workbook_Open() *Write your vba coding * End Sub On Mon, Jun 25, 2012 at 1:26 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts Pls help me with a way, so that a Macro runs whenever I open a particular excel file. (Macro is in that excel file only). Regards Amit -- -- 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
Re: $$Excel-Macros$$ Lookup problem
Thanks bro.. On Mon, Jun 25, 2012 at 1:05 PM, Kal xcel kalx...@gmail.com wrote: Dear Rajan, I sincerely express my gratitude to you for your kind help and support that you have extended towards me. Noorain , Your excellent guidance over MS Excel has proved to be of immense help to me in implementing my work. All the three options that you have taught me are working smoothly. You are a *Teacher* in the true sense of the word. Thanking you all once again. -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. 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, 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
$$Excel-Macros$$ Re: Run Macro at OPEN of an Excel file
Hi Amit, Please write your macro on the workbook's open event this will let your macro to execute as your excel file get open. regards Prince On Monday, 25 June 2012 13:26:16 UTC+5:30, Mitr wrote: Hi Experts Pls help me with a way, so that a Macro runs whenever I open a particular excel file. (Macro is in that excel file only). Regards Amit -- -- 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$$ Is online learning effective http://online-edu2all.blogspot.com/2012/06/is-online-learning-effective
Is online learning effective http://online-edu2all.blogspot.com/2012/06/is-online-learning-effective.html -- -- 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$$ PLEASE JOIN MY RECHARGE PVT LIMITED.
Dear Tarun, Please follow below rule.. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 25, 2012 at 6:04 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: -- Tarun Mondal Postal Assistant Katwa Head Post Office Burdwan,West Bengal (9474810276) -- -- 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$$ Macro to copy a macro from one workbook to another
Hi Richard, Please explain what is child workbook..? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Richard Sent: 25 June 2012 5:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to copy a macro from one workbook to another I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- 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$$ need help on maximum value and thier name
=INDEX(A2:A15 B2:B15,MATCH(MAX(B2:B15),B2:B15,0),1) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: 25 June 2012 12:32 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com 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 mailto:excel-macros%2bunsubscr...@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
RE: $$Excel-Macros$$ Lookup problem
We are always happy to help you on this group Keep excelling J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kal xcel Sent: 25 June 2012 1:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup problem Dear Rajan, I sincerely express my gratitude to you for your kind help and support that you have extended towards me. Noorain , Your excellent guidance over MS Excel has proved to be of immense help to me in implementing my work. All the three options that you have taught me are working smoothly. You are a Teacher in the true sense of the word. Thanking you all once again. -- Kalyan Chattopadhyay Executive Sales Coordinator R. S. H. 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, 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$$ Macro to copy a macro from one workbook to another
Create a “template” workbook for the child workbooks or do it from the master. A more detailed explanation of your problem may help. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Richard Sent: Sunday, June 24, 2012 6:46 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to copy a macro from one workbook to another I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- 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$$ MY NEW EXCEL DASHBOARD PROJECTS
Good, most like main page J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: 25 June 2012 7:42 To: excel-macros Subject: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS Hello Guys i just completed my two excel projects and want to share. The first one is like an accounting system where you can enter clients information as well as transactions and post it to a database and also able to retrieve the information. Since i am not good with VBA , i used macro recording techniques to achieve these as well as of course formula's. Try it out and have fun and hope someone can improve upon it and give feedback. the pass word on the file is 'kiss The second is a fixed income dashboard, its easy to understand when you test how it works, keep excelling cos excel is fun, have a great day. -- -- 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$$ Macro to copy a macro from one workbook to another
A child workbook is a 2nd, 3rd or 4th workbook created from the master with subsets of the data. The master may contain data for locations 1, 2, 3, and 4, whereas the first child workbook only location 1, the second location 2, etc. Within the first child workbook, I want to put in code in the ThisWorkbook section that with lock selected cells. I know how to write the code to do this, but not how to get it in the Thisworkbook section using my macro that creates the child workbooks. On Monday, June 25, 2012 5:55:52 AM UTC-7, Rajan_Verma wrote: Hi Richard, Please explain what is child workbook..? * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Richard *Sent:* 25 June 2012 5:17 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Macro to copy a macro from one workbook to another I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- 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$$ Macro to copy a macro from one workbook to another
Make an string of your Procedure and try this Application.Workbooks(Book2).VBProject.VBComponents(THisWOrkbook).CodeMo dule.AddFromString YourString HTH Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Richard Sent: 25 June 2012 8:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to copy a macro from one workbook to another A child workbook is a 2nd, 3rd or 4th workbook created from the master with subsets of the data. The master may contain data for locations 1, 2, 3, and 4, whereas the first child workbook only location 1, the second location 2, etc. Within the first child workbook, I want to put in code in the ThisWorkbook section that with lock selected cells. I know how to write the code to do this, but not how to get it in the Thisworkbook section using my macro that creates the child workbooks. On Monday, June 25, 2012 5:55:52 AM UTC-7, Rajan_Verma wrote: Hi Richard, Please explain what is child workbook..? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Richard Sent: 25 June 2012 5:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to copy a macro from one workbook to another I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- 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$$ Re: Macro to copy a macro from one workbook to another
Thank you very much On Sunday, June 24, 2012 4:46:35 PM UTC-7, Richard wrote: I would like to create a macro to copy a macro from one workbooks module area to another workbooks ThisWorkbook area. The first workbook is the master and any other workbook would be subsets of the master. The idea is to have a macro that will further lock cells from input (sub workbook_open) on the child workbooks. Any help would be appreciated Rich -- -- 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$$ Re: need help on maximum value and thier name
Hi Sunita, For finding max value with name you can apply this formula, Hope this will work for you. =INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),1) : INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),2) regards prince On Monday, 25 June 2012 12:13:04 UTC+5:30, suneeta 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
$$Excel-Macros$$ Is there a way of running macros in Macintosh?
Dear excel gurus, quick question for you. I need to run excel macros in a macintosh system, as far as I know libra is the default productivity software in mac and it supports open office as well. Is there a way to run vba macros in libra and/ or open office? Pls advise. Best Regards, Krishnan Sent on my BlackBerry® from Vodafone -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ need help on maximum value and thier name
Hi Sunita, Please try it.. =INDEX($B$3:$B$16,SMALL(IF($K33=$P$3:$P$16,ROW($B$3:$B$16),),COUNTIF($K$24:K33,K33))-2) with ctrl+shift+enter or =OFFSET($B$2,SMALL(IF($K24=$P$3:$P$16,ROW($B$3:$B$16),),COUNTIF($K$24:K24,K24))-2,0) with ctrl+shift+enter See attached sheet with both formula -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 10:30 AM, सुनिता पौडेल tosune...@gmail.com wrote: Guys do me one favor again!! Thanx On Mon, Jun 25, 2012 at 6:46 PM, Rajan_Verma rajanverma1...@gmail.com wrote: =INDEX(A2:A15 B2:B15,MATCH(MAX(B2:B15),B2:B15,0),1) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: 25 June 2012 12:32 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com 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 the thread of 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
Re: $$Excel-Macros$$ need help on maximum value and thier name
सुनिता पौडेल tosune...@gmail.com wrote: Guys do me one favor again!! Thanx On Mon, Jun 25, 2012 at 6:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** ** ** =INDEX(A2:A15 B2:B15,MATCH(MAX(B2:B15),B2:B15,0),1) with CSE ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed *Sent:* 25 June 2012 12:32 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ need help on maximum value and thier name* *** ** ** PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com 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 the thread of 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)