Re: $$Excel-Macros$$ Query- Global Variable
Dear Hemant, Lalit solution is nice You can also check.. http://www.ozgrid.com/forum/showthread.php?t=58969 On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote: Hi Group, How can i declare a global variable for below mentioned. Private sub abc() dim sh as worksheet dim rng as range set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub In my module i have 20 procedure and in future comes many more. So, my query how to declare a global variable and how to call in my procedure. Regards, excelvba.lear...@gmail.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 -- 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: Error Cleaning
Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Book4.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ All the sheet names in one sheet
Hi Group, I want the list of all the sheet names available or to created in sheet1 automatically via formula of a workbook *without a macro.* Thanks Regards Santosh santoshkumar.subu...@gmail.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$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......
Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count, A).End(xlUp).Row + 1 dt = Me.DTPicker1 With Application.WorksheetFunction If .WeekNum(dt) (.WeekNum(Date) - 1) Then Cells(i, 1) = Me.DTPicker1.Value Else MsgBox Restricted Last week Entery, vbCritical End If End With End Sub *see attached sheet, hope it will help to you. On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote: Hi Experts Required VBA Code for restrict Previous Week Data Entry to Users. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- 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 Dharti_Query.xlsm Description: Binary data
Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......
dear noorian How u add the Dt picker in user form... pls let me know.. Regards Gawli Anil On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count, A).End(xlUp).Row + 1 dt = Me.DTPicker1 With Application.WorksheetFunction If .WeekNum(dt) (.WeekNum(Date) - 1) Then Cells(i, 1) = Me.DTPicker1.Value Else MsgBox Restricted Last week Entery, vbCritical End If End With End Sub *see attached sheet, hope it will help to you. On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote: Hi Experts Required VBA Code for restrict Previous Week Data Entry to Users. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- 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 -- 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, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Help Me
Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, Please help me to make report I have data in 1 sheet I want make report in sheet 2. Regard Manoj -- 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$$ Help Me
Happy to Help On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, Please help me to make report I have data in 1 sheet I want make report in sheet 2. Regard Manoj -- 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 -- 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$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......
dear noorian Thanks Bro... Regards, Gawli Anil On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Anil Bro, Please right click on Toolbox goto Additional Control and select Microsoft Date and Time Picker. see attached screenshot or if your system doesn't support Date Time picker then install it through below link http://danielcurran.com/instructions/how-to-install-microsoft-date-time- picker-control-60-sp4/ On Mon, Jul 16, 2012 at 3:16 PM, Anil Gawli gawlianil8...@gmail.comwrote: dear noorian How u add the Dt picker in user form... pls let me know.. Regards Gawli Anil On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count, A).End(xlUp).Row + 1 dt = Me.DTPicker1 With Application.WorksheetFunction If .WeekNum(dt) (.WeekNum(Date) - 1) Then Cells(i, 1) = Me.DTPicker1.Value Else MsgBox Restricted Last week Entery, vbCritical End If End With End Sub *see attached sheet, hope it will help to you. On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu dhartiku...@gmail.com wrote: Hi Experts Required VBA Code for restrict Previous Week Data Entry to Users. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- 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 -- 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, 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
Re: $$Excel-Macros$$ Help Me
Dear Kuldeep, thanks.. I need function witch I already provide by Noorain... On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, Use this Regards, Kuldeep Singh Info Edge India Limited (naukri.com) naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Expert, Please help me to make report I have data in 1 sheet I want make report in sheet 2. Regard Manoj -- 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 -- 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,
Re: $$Excel-Macros$$ Help Me
[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █] Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Kuldeep, thanks.. I need function witch I already provide by Noorain... On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, Use this Regards, Kuldeep Singh Info Edge India Limited (naukri.com) naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Expert, Please help me to make report I have data in 1 sheet I want make report in sheet 2. Regard Manoj -- 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
$$Excel-Macros$$ Vlookup Problem
Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......
Thanks Noorain it's working fine, thank for your valuable support. On Mon, Jul 16, 2012 at 4:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: dear noorian Thanks Bro... Regards, Gawli Anil On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Anil Bro, Please right click on Toolbox goto Additional Control and select Microsoft Date and Time Picker. see attached screenshot or if your system doesn't support Date Time picker then install it through below link http://danielcurran.com/instructions/how-to-install-microsoft-date-time- picker-control-60-sp4/ On Mon, Jul 16, 2012 at 3:16 PM, Anil Gawli gawlianil8...@gmail.comwrote: dear noorian How u add the Dt picker in user form... pls let me know.. Regards Gawli Anil On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count, A).End(xlUp).Row + 1 dt = Me.DTPicker1 With Application.WorksheetFunction If .WeekNum(dt) (.WeekNum(Date) - 1) Then Cells(i, 1) = Me.DTPicker1.Value Else MsgBox Restricted Last week Entery, vbCritical End If End With End Sub *see attached sheet, hope it will help to you. On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu dhartiku...@gmail.com wrote: Hi Experts Required VBA Code for restrict Previous Week Data Entry to Users. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- 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 -- 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, 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
$$Excel-Macros$$ Please solve my Pivot Table Problem
Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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 Pivot_Table Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup Problem
Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 -- *Suman Kumar* *Mob: +91-9810333884* *RIM-+91-9555629292* -- 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 -- With regards, MaNgEsH -- 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.comA_html_m691da4f3.gif
Re: $$Excel-Macros$$ Vlookup Problem
so much On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 -- *Suman Kumar* *Mob: +91-9810333884* *RIM-+91-9555629292* -- 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 -- With regards, MaNgEsH -- With regards, MaNgEsH -- 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.comA_html_m691da4f3.gif
Re: $$Excel-Macros$$ Please help me.
Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please find attached simple Calender. You can create it simply. On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, I want to make Calender on excel when i enter year month in a coll it show me date wise calender... Regard Manoj -- 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 -- With regards, MaNgEsH -- 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$$ Vlookup Problem
Dear Mangesh, You can also use.. *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)* or *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))* or *=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)* with ctrl+shift+Enter See attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 Copy of VLookUp Problem Solved(Mangesh)-16Jul12.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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, send a blank email to excel-macros+unsubscr...@googlegroups.com Pivot_Table_Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Hi Anil, Thanks lot. But I need to calculate the average($) by using Calculated Field option given in Options --- Formulas --- calculated field. Is it possible by using above method. Please let me know. Thanks again. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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$$ Vlookup Problem
Hi Mangesh, If you want to learn how vlookup works may be below links helps you.. http://www.free-training-tutorial.com/function-vlookup.html http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm Regards, Lalit Mohan On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Its really helpful. U have done full R D here. Thanks lot. On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, You can also use.. =LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6) or =INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0)) or =OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0) with ctrl+shift+Enter See attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 -- With regards, MaNgEsH -- 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$$ All the sheet names in one sheet
Dear Santosh, I think it is not possible to get all the sheets name by using only formula. Regards, Lalit Mohan On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Santosh, Please create a name range with below formula.. =REPLACE(GET.WORKBOOK(1),1,FIND(],GET.WORKBOOK(1)),) and use below formula to extract sheet name in column A. =IF(ROWS($A$2:A2=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),) See attached sheet for more information. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, I want the list of all the sheet names available or to created in sheet1 automatically via formula of a workbook without a macro. Thanks Regards Santosh santoshkumar.subu...@gmail.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$$ Re: Error Cleaning
I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 8:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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,
Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don, It's working perfectly.but one more problem is this i have shown only 3 columns in my sample file but in real ...i have atleast 23 columns last column is the Error column on which this macro will work...now this macro is consolidating the data at the end.Please have a look.For instance, i have increased the column no to 5. On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote: I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* SG sonal...@gmail.com *Sent:* Monday, July 16, 2012 8:49 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* SG sonal...@gmail.com *Sent:* Monday, July 16, 2012 3:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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
$$Excel-Macros$$ copy color from cell base on condition formating
Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards 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 colour_for_condition_formating.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ copy color from cell base on condition formating
Please try paste special format Sent on my BlackBerry® from Vodafone -Original Message- From: pawel lupinski lupins...@yahoo.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 07:38:57 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy color from cell base on condition formating Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards 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: Error Cleaning
I don’t understand. Look at before/after sheets to see what macro is doing. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 9:30 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, It's working perfectly.but one more problem is this i have shown only 3 columns in my sample file but in real ...i have atleast 23 columns last column is the Error column on which this macro will work...now this macro is consolidating the data at the end.Please have a look.For instance, i have increased the column no to 5. On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote: I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 8:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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
Re: $$Excel-Macros$$ Re: Error Cleaning
Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 9:30 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, It's working perfectly.but one more problem is this i have shown only 3 columns in my sample file but in real ...i have atleast 23 columns last column is the Error column on which this macro will work...now this macro is consolidating the data at the end.Please have a look.For instance, i have increased the column no to 5. On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote: I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 8:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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
Re: $$Excel-Macros$$ Re: Error Cleaning
Yes, if you see..from row 12 to row 40, the data is blank..can it be possible after running the macro...it would consolidated without such blanks in the data?? On Monday, July 16, 2012 8:31:55 PM UTC+5:30, Don Guillett wrote: Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* SG sonal...@gmail.com *Sent:* Monday, July 16, 2012 9:30 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, It's working perfectly.but one more problem is this i have shown only 3 columns in my sample file but in real ...i have atleast 23 columns last column is the Error column on which this macro will work...now this macro is consolidating the data at the end.Please have a look.For instance, i have increased the column no to 5. On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote: I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* SG sonal...@gmail.com *Sent:* Monday, July 16, 2012 8:49 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* SG sonal...@gmail.com *Sent:* Monday, July 16, 2012 3:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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.
Re: $$Excel-Macros$$ Re: Error Cleaning
You might try expanding column C to find out that that is NOT true Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 10:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Yes, if you see..from row 12 to row 40, the data is blank..can it be possible after running the macro...it would consolidated without such blanks in the data?? On Monday, July 16, 2012 8:31:55 PM UTC+5:30, Don Guillett wrote: Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 9:30 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, It's working perfectly.but one more problem is this i have shown only 3 columns in my sample file but in real ...i have atleast 23 columns last column is the Error column on which this macro will work...now this macro is consolidating the data at the end.Please have a look.For instance, i have increased the column no to 5. On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote: I wrote it to continue what you had already done. The TTC could be incorporated. Option explicit forces use of dim Look in vba help index for resize Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 8:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error Cleaning Hi Don, Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can you please explain the option Explicit use of resize would i run this macro after text to column splitting? uillett wrote: Should do it Option Explicit Sub getlists() Dim lr As Long Dim i As Long Dim dr As Long Dim btc As Range lr = Cells(Rows.Count, 1).End(xlUp).Row - 1 Set btc = Cells(2, 1).Resize(lr, 2) For i = 2 To lr + 1 dr = Cells(Rows.Count, 1).End(xlUp).Row + 1 btc.Copy Cells(dr, 1) Cells(2, i + 1).Resize(lr).Copy Cells(dr, c) 'MsgBox i Next i Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub ‘’ Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SG Sent: Monday, July 16, 2012 3:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Error Cleaning Sorry for Replying late.Yes, i choose delimit choose comma for it.Problem is this that the data is in thousandsr rows manually it takes so much time.i have attached a file i hope it clears the doubts brfore cleaning the data after cleaning the data. On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote: Hi Experts, I need your help again.We extract the data from database each user got some errors on different projects.I need to clean the error data to get the count of errors.For this,i do text to column on error column.Then, in each column after error column, i take the value one by one copy paste the data below the original data.It's too time consuming as data may expand up to many columns each column has irregular no. of errors description.I have tried to explain best need a macro to make unique row of erros of all users.I have attached the excel file a document in which i have tried to explain.Looking forward for your help. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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
$$Excel-Macros$$ Sherry's HotList
*Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional consultant* *Moore, OK* *Anywhere* *Konda* *Oracle Apps SCM Consultant* *Chicago,IL * *Chicago, IL* *Arun* *Oracle Apps Techno- functional* *Texas* *CA and UT* *Chanikya* *Oracle Apps technical Consultant* *Indianapolis, IN* *Anywhere * *Padma* *.Net Developer* *Salt Lake City, UT* *Salt Lake City, UT* *Shilpa* *Informatica Developer* *Hopkins, MN* *Salt Lake City, UT* *Sneha* *Java Developer* *Kansas City, MO* *Only TX* *Thanks Regards**...**?* * * *Sherry* *NITYA** **Software Solutions, Inc*** *Direct:801-833-0416; Office : 801-983-2771; Fax:801-606-7919*** *Email: **she...@nityainc.com* she...@nityainc.com*; Web: ** www.nityainc.com* http://www.nityainc.com/** *[image: Description: Description: Description: http://images.wisestamp.com/yahoo.png] **[image: Description: Description: Description: http://images.wisestamp.com/gtalk.png]**: ** sherry.nityainc*** *9690 South 300 West, #319 Salt Lake City, UT 84070*** -- 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$$ Sherry's HotList
Hi moderators, Per rule please ban this user. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: sherry .. sherry.w...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 21:24:44 To: us-recruitment-and-market...@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sherry's HotList *Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional consultant* *Moore, OK* *Anywhere* *Konda* *Oracle Apps SCM Consultant* *Chicago,IL * *Chicago, IL* *Arun* *Oracle Apps Techno- functional* *Texas* *CA and UT* *Chanikya* *Oracle Apps technical Consultant* *Indianapolis, IN* *Anywhere * *Padma* *.Net Developer* *Salt Lake City, UT* *Salt Lake City, UT* *Shilpa* *Informatica Developer* *Hopkins, MN* *Salt Lake City, UT* *Sneha* *Java Developer* *Kansas City, MO* *Only TX* *Thanks Regards**...**?* * * *Sherry* *NITYA** **Software Solutions, Inc*** *Direct:801-833-0416; Office : 801-983-2771; Fax:801-606-7919*** *Email: **she...@nityainc.com* she...@nityainc.com*; Web: ** www.nityainc.com* http://www.nityainc.com/** *[image: Description: Description: Description: http://images.wisestamp.com/yahoo.png] **[image: Description: Description: Description: http://images.wisestamp.com/gtalk.png]**: ** sherry.nityainc*** *9690 South 300 West, #319 Salt Lake City, UT 84070*** -- 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: copy color from cell base on condition formating
Hi Pawel, In case of conditional formatting we can not refer other sheet. So for this problem you can use macro. regards prince dubey. On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote: Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards 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
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks a ton !!! On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manesh, As desired, Please find step by step screen shot with complete explanation as attachment. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain. Thanks but I do not understand how did you calculated the Average Salary ($) by using *calculated field*. Please provide me documentation so that I could understand. I know it is time consuming job for you and really sorry for that. But I dont have alternative. So please help me dear. Sorry to trouble u again and again. On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please find attached sheet.. little correction of Anil's Formula in green part =GETPIVOTDATA(Average of Salary [INR],$E$1,Dept,*$E3*)/55 Calculated Field solution is also attached here with screen shot. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.comwrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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, 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 -- With regards, MaNgEsH -- 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
Re: $$Excel-Macros$$ copy color from cell base on condition formating
Joseph, paste special is not workig as its refering to different sheet Regards, Pawel From: joseph.cam...@gmail.com joseph.cam...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, July 16, 2012 3:41 PM Subject: Re: $$Excel-Macros$$ copy color from cell base on condition formating Please try paste special format Sent on my BlackBerry® from Vodafone From: pawel lupinski lupins...@yahoo.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 07:38:57 -0700 (PDT) To: excel-macros@googlegroups.comexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy color from cell base on condition formating Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards 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 -- 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: All the sheet names in one sheet
Hi Santosh, Please refer attach sheet it may help you. Regards Prince dubey On Monday, 16 July 2012 14:52:01 UTC+5:30, santosh wrote: Hi Group, I want the list of all the sheet names available or to created in sheet1 automatically via formula of a workbook *without a macro.* Thanks Regards Santosh santoshkumar.subu...@gmail.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 SheetName.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: copy color from cell base on condition formating
Hi Prince, Unfortunatelly I think as well that the macro is the only one solution for this, but is outside of my confort zone. Thanks anyway Pawel From: Prince Dubey prince141...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Monday, July 16, 2012 5:21 PM Subject: $$Excel-Macros$$ Re: copy color from cell base on condition formating Hi Pawel, In case of conditional formatting we can not refer other sheet. So for this problem you can use macro. regards prince dubey. On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote: Hi All, I'd like to ask you for favour. I have an issue with copy of the colour from condition formating to new place. What I'd like to do is: copy values and colour to Sheet2 cell B3 in the way that I will have the value and the same colour.But the issue is colour can not be base on condition formating? Does anyone know how to do it? Regards 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: Introduce Yourself !!
Hi Ashish. My name: Trần Văn Bé, of birth 1957, as state employees. Form: Việt Nam I love Excel and a member of the forum, when the new free visit, to exchange knowledge and help other members on the board, I have participated less frequently for free time. 2012/7/16 kumar.ashish861 kumar.ashish...@gmail.com Hi All, Iam Ashish from Delhi, I love excel and loves to learn new tweeks and tricks. Thish Forum is ROCKS..! On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- 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: Introduce Yourself !!
Hi All, This is Venkatesh Narla i am 26 years old and worked as Release manager in Accenture(Bangalore Location). Currently looking out for new job. 5+ years in MIS. I am from Andhra Pradesh. Thanks, Venkatesh Narla. On Mon, Jun 11, 2012 at 9:04 AM, Anand Kumar anand...@gmail.com wrote: Hi, I am Anand Kumar. Aged 31 years and working in fields of data analysis for past aprrox 5 years. I have my PGDM in Marketing and hold a ISO 9000 lead auditor qualifications. -- 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$$ Vlookup Problem
Hi, Please find the attachment and let me know.. any thing els need.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$
*Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional consultant* *Moore, OK* *Anywhere* *Konda* *Oracle Apps SCM Consultant* *Chicago,IL * *Chicago, IL* *Arun* *Oracle Apps Techno- functional* *Texas* *CA and UT* *Chanikya* *Oracle Apps technical Consultant* *Indianapolis, IN* *Anywhere * *Padma* *.Net Developer* *Salt Lake City, UT* *Salt Lake City, UT* *Shilpa* *Informatica Developer* *Hopkins, MN* *Salt Lake City, UT* *Sneha* *Java Developer* *Kansas City, MO* *Only TX* *Thanks Regards**...**?* * * *Sherry* *NITYA** **Software Solutions, Inc*** *Direct:801-833-0416; Office : 801-983-2771; Fax:801-606-7919*** *Email: **she...@nityainc.com* she...@nityainc.com*; Web: ** www.nityainc.com* http://www.nityainc.com/** *[image: Description: Description: Description: http://images.wisestamp.com/yahoo.png] **[image: Description: Description: Description: http://images.wisestamp.com/gtalk.png]**: ** sherry.nityainc*** *9690 South 300 West, #319 Salt Lake City, UT 84070*** -- 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$$ Sherry's HotList
*Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional consultant* *Moore, OK* *Anywhere* *Konda* *Oracle Apps SCM Consultant* *Chicago,IL * *Chicago, IL* *Arun* *Oracle Apps Techno- functional* *Texas* *CA and UT* *Chanikya* *Oracle Apps technical Consultant* *Indianapolis, IN* *Anywhere * *Padma* *.Net Developer* *Salt Lake City, UT* *Salt Lake City, UT* *Shilpa* *Informatica Developer* *Hopkins, MN* *Salt Lake City, UT* *Sneha* *Java Developer* *Kansas City, MO* *Only TX* *Thanks Regards**...**?* * * *Sherry* *NITYA** **Software Solutions, Inc*** *Direct:801-833-0416; Office : 801-983-2771; Fax:801-606-7919*** *Email: **she...@nityainc.com* she...@nityainc.com*; Web: ** www.nityainc.com* http://www.nityainc.com/** *[image: Description: Description: Description: http://images.wisestamp.com/yahoo.png] **[image: Description: Description: Description: http://images.wisestamp.com/gtalk.png]**: ** sherry.nityainc*** *9690 South 300 West, #319 Salt Lake City, UT 84070*** -- 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$$ How to Convert words in digits.
Your question and title are contradicting. Do you want to convert words to numbers, or vice versa? Regards, Sam Mathai Chacko On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 kumar.ashish...@gmail.com wrote: Dear All, Kindly help me to convert numbers in digits. I'll apply the formula spellnums but, I think this formula is working only in Office 2003. please help me to convert this, is this possible to convert it with formula not with the help of VB codeing. EXAMPLE:- Two lacs Two thousand twenty five only. = 220025/- Thanks Ashish Kumar -- 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 -- Sam Mathai Chacko -- 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$$ Vlookup Problem
Do as you like. 2012/7/17 Venkatesh Narla nvenki...@gmail.com Hi, Please find the attachment and let me know.. any thing els need.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 Vlookup Problem..xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sherry's HotList
STOP!! sherry .. sherry.w...@gmail.com wrote: *Hi,* *Hope you are doing great today..* *Please find the updated hotlist of my consultants..* *Please send the requirements to she...@nityainc.com or feel free to call me at 801-833-0416* * * *Consultant* *Technology* *Location* *Relocation* *Karthik* *Oracle apps Finance functional consultant* *Moore, OK* *Anywhere* *Konda* *Oracle Apps SCM Consultant* *Chicago,IL * *Chicago, IL* *Arun* *Oracle Apps Techno- functional* *Texas* *CA and UT* *Chanikya* *Oracle Apps technical Consultant* *Indianapolis, IN* *Anywhere * *Padma* *.Net Developer* *Salt Lake City, UT* *Salt Lake City, UT* *Shilpa* *Informatica Developer* *Hopkins, MN* *Salt Lake City, UT* *Sneha* *Java Developer* *Kansas City, MO* *Only TX* *Thanks Regards**...**?* * * *Sherry* *NITYA** **Software Solutions, Inc*** *Direct:801-833-0416; Office : 801-983-2771; Fax:801-606-7919*** *Email: **she...@nityainc.com* she...@nityainc.com*; Web: ** www.nityainc.com* http://www.nityainc.com/** *[image: Description: Description: Description: http://images.wisestamp.com/yahoo.png] **[image: Description: Description: Description: http://images.wisestamp.com/gtalk.png]**: ** sherry.nityainc*** *9690 South 300 West, #319 Salt Lake City, UT 84070*** -- 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$$ Please help me.
Dear Mangesh, To create this calendar in the range B2:H9, follow these steps: 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge Center. 2. Enter a date into the merged range. The day of the month isn’t important. 3. Enter the abbreviated day names in the range B3:H3. Performing Magic with Array Formulas 4. Select B4:H9 and enter this array formula. Remember: To enter an array formula, press Ctrl+Shift+Enter (not just Enter). {=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))MONTH(DATE(YEAR(B2), MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+ {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””, DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT H(B2),1))-1)+ {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)} 5. Format the range B4:H9 to use this custom number format: d. This step formats the dates to show only the day. Use the Custom category in the Number tab of the Format Cells dialog box to specify this custom number format. 6. Adjust the column widths and format the cells as you like. 7. Change the month and year in cell B2. The calendar updates automatically. After creating this calendar, you can copy the range to any other worksheet or workbook. Thanks Regards, *Deba Ranjan P* On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj, Please find attached simple Calender. You can create it simply. On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Expert, I want to make Calender on excel when i enter year month in a coll it show me date wise calender... Regard Manoj -- 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 -- With regards, MaNgEsH -- 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
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
goto calculations field, then click on field items and set then click on calculation field then click the dropdown button of Name field and click on delete. Regards, Gawli Anil On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay wrote: Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks a ton !!! On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manesh, As desired, Please find step by step screen shot with complete explanation as attachment. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain. Thanks but I do not understand how did you calculated the Average Salary ($) by using *calculated field*. Please provide me documentation so that I could understand. I know it is time consuming job for you and really sorry for that. But I dont have alternative. So please help me dear. Sorry to trouble u again and again. On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please find attached sheet.. little correction of Anil's Formula in green part =GETPIVOTDATA(Average of Salary [INR],$E$1,Dept,*$E3*)/55 Calculated Field solution is also attached here with screen shot. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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, 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$$ Date to be formatted in to Customised Format
Dear Experts, Good Morning... Need your Help in formatting the Given Date in to customised format per attachment... Thanks in Advance! JP. -- -- 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 Formated in to Customised Format - Help Reqd.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Date to be formatted in to Customised Format
Dear JP, Please use below formula for desired output. *=CONCATENATE(TEXT(A3,mm.dd.yy), ,TEXT(B3,hh:mm:ss AM/PM))* or *=TEXT(A3,mm.dd.yy) TEXT(B3,hh:mm:ss AM/PM) *See attached sheet for reference.* * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 17, 2012 at 10:32 AM, Jayaprakash S bhat.jayaprak...@gmail.comwrote: Dear Experts, Good Morning... Need your Help in formatting the Given Date in to customised format per attachment... Thanks in Advance! JP. -- -- 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 Copy of Date Formated in to Customised Format - Help Reqd(JP).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Date to be formatted in to Customised Format
Thanks a Ton Master :-) Working fine !! have a gud day! JP. On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear JP, Please use below formula for desired output. =CONCATENATE(TEXT(A3,mm.dd.yy), ,TEXT(B3,hh:mm:ss AM/PM)) or =TEXT(A3,mm.dd.yy) TEXT(B3,hh:mm:ss AM/PM) See attached sheet for reference. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 17, 2012 at 10:32 AM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Good Morning... Need your Help in formatting the Given Date in to customised format per attachment... Thanks in Advance! JP. -- -- 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 -- Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most desirable habit for success - Swamy Vivekananda. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. -- -- 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