$$Excel-Macros$$ Re: how to fill series
Hi amir shahzad Plz find attached is solution. Regards Mukesh On Wed, Jul 29, 2009 at 12:58 AM, Aamir Shahzad aamir...@gmail.com wrote: Dear Members, I have little issue Series please see attached sheet I just want to know how I put series if I have thousand of names. But space is problem. Kindly resolve. Regards, Aamir Shahzad --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Groups(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query
Hi Nikhil, Please find attached solved sheet. Thanks Regards Mukesh On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah nikhil201...@gmail.com wrote: Dear All Members, Here I am postin excel sheet.. *Problem : * *when I select the NAME I want the POLICY NOS. of that perticular NAME only in the Drop List menu.* For Ex. If I selet the name as Nikhil then all the policy Nos. of NIKHIL only. Pl help me out to solve my problem..I DO Not Want MACRO..I want Fromula only.. Nikhil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Mukesh Kumar Jha Opera Solutions Tech Boulevard, 8th Floor, Tower C Sector 127, Plot No 6 Noida, INDIA 201 301 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Nikhil_-_Insu.Query_Solved.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Query continuous copy paste
Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 Xl008.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
@ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use
Re: $$Excel-Macros$$ Query continuous copy paste
Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i was looking for. You are marvellous in excel sir. Thanks again. Regards, Mukesh Kumar On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: The code I gave was exactly for assigning any number of header groups. Sam On Tue, Jan 31, 2012 at 11:44 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari
$$Excel-Macros$$ Need formula for rearranging all column data to single column
Hi Experts, I need formula (not macro code) to rearrange various column data in a single column. Sample file is attached herewith. Regards, Mukesh 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 re-arrange_the_products.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need macro or Formula
Hi Experts, I need macro /formula for query given in attached file. The result should come based on values given in column A. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Query.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need macro or Formula
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is coming twice in result. Can it also come single time. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 1:48 PM, De Premor d...@premor.net wrote: Solution Attached On 16/07/2013 14:10, Mukesh Kumar wrote: Hi Experts, I need macro /formula for query given in attached file. The result should come based on values given in column A. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscribe@**googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macroshttp://groups.google.com/group/excel-macros . For more options, visit https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscribe@**googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macroshttp://groups.google.com/group/excel-macros . For more options, visit https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Need macro or Formula
Thanks DP Sir, the code is now working perfectly. Regards, Mukesh Kumar On Wed, Jul 17, 2013 at 6:40 AM, De Premor d...@premor.net wrote: ignore my last email, i've made some change in variable declaration PFA On 17/07/2013 7:32, De Premor wrote: Hi, Mukesh Try to change this code: *For Each Rng In Data** **If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add Rng.Value, Rng.Value** **Next** * to *For Each Rng In Data** **i = i + 1** **If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add Rng.Value, Rng.Value** **Next** * Rgds, [dp] On 16/07/2013 18:03, Mukesh Kumar wrote: Dear Sir, thanks for your help. This file gives 99% correct result. Only problem in this formula is that if we gives the range in this formula from the very first cell then it gives correct result eg. concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE) If we gives range from 2nd cell (in case of header row) then it gives wrong result eg. concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE). You can see this in attached file. Pls solve this too, so that whatever range we give, the result should come true. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 2:52 PM, De Premor d...@premor.net wrote: Ups sorry, my mistake i've attached new file for revision Rgds, [dp] On 16/07/2013 15:27, Mukesh Kumar wrote: Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is coming twice in result. Can it also come single time. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 1:48 PM, De Premor d...@premor.net wrote: Solution Attached On 16/07/2013 14:10, Mukesh Kumar wrote: Hi Experts, I need macro /formula for query given in attached file. The result should come based on values given in column A. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material
$$Excel-Macros$$ paste special particular formula
Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ paste special particular formula
Thanks a lot Sir for the help. On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Set rngRange = ActiveSheet.UsedRange VarArr = rngRange.Formula strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR ActiveSheet.UsedRange.Value = VarArr MsgBox strFormula is replace in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email
Re: $$Excel-Macros$$ paste special particular formula
Rajan ji , this macro code is limited to one sheet only. I want the macro that works upon all sheets at once. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Set rngRange = ActiveSheet.UsedRange VarArr = rngRange.Formula strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR ActiveSheet.UsedRange.Value = VarArr MsgBox strFormula is replace in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL
Re: $$Excel-Macros$$ paste special particular formula
Thanks a lot Rajan Ji for your help. This code is working fine. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 12:03 PM, rajan verma rajanverma1...@gmail.comwrote: So problem was the reference in formulas , if any formula have reference like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here) it will always assume that reference is from activesheet until we provide full reference like Sheet1!A1:A5, but it is complex to write that code , so the simple solution would to be to activate that sheet where the formula is going to be evaluated, try this code , Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet Dim wksLastActive As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 Application.ScreenUpdating = False Set wksLastActive = ThisWorkbook.ActiveSheet For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then wksSheet.Activate For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR wksSheet.UsedRange.Value = VarArr End If Set rngRange = Nothing End If Next wksSheet wksLastActive.Activate Application.ScreenUpdating = True MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Fri, Sep 27, 2013 at 12:08 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Rajan Ji, Plz see attached file. I have inserted the macro code in it. But it is giving wrong results. Plz check. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 9:45 PM, rajan verma rajanverma1...@gmail.comwrote: use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR End If End If wksSheet.UsedRange.Value = VarArr Next wksSheet MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 10:14 AM, rajan verma rajanverma1...@gmail.comwrote: Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC
Re: $$Excel-Macros$$ paste special particular formula
Rajesh Ji, In my workbook, formulas are in range b. This macro code is working on other ranges also. Thanks to you very much. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 1:17 PM, Ravinder ravinderexcelgr...@gmail.comwrote: But where u want to paste those formula means which range all sheets have the same format.. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Thursday, September 26, 2013 3:10 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ paste special particular formula ** ** Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Macro code requirement
Dear Sir, I have an excel file in which there are 300 names are there they are given different targets. Now I have to take print outs of these 300 names. I have prepared drop down list of 300 names in cell A7 in attached sample file. My requirement is that I want 300 sheets according to dropdown list. Please provide macro code for this. Sample file is attached. Please note that dropdown list in this sample file is in A7 cell. I want macro code that works on dropdown list regardless of dropdown list position i.e it may be in any other cell in my other files. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Book.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Macro code requirement
Dear Sir, Please check that there is no changes done in your attached file. Regards, Mukesh Kumar On Wed, Oct 9, 2013 at 4:46 PM, Ravinder ravinderexcelgr...@gmail.comwrote: pfa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Wednesday, October 09, 2013 4:44 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Macro code requirement ** ** Dear Ravinder Ji, I have checked the file, but it is making 50 sheets only. Secondly when I tried this macro code in my another file then it is showing error, after ignoring error it is making sheets in which formatting gets disturbed. *** * My requirement is that the macro code first asks for drop down list location after this the macro generate as many as sheets according to list. Please find attached another sample file. Regards, Mukesh Kumar ** ** On Wed, Oct 9, 2013 at 4:04 PM, Ravinder ravinderexcelgr...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Wednesday, October 09, 2013 3:24 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Macro code requirement Dear Sir, I have an excel file in which there are 300 names are there they are given different targets. Now I have to take print outs of these 300 names. I have prepared drop down list of 300 names in cell A7 in attached sample file. My requirement is that I want 300 sheets according to dropdown list. Please provide macro code for this. Sample file is attached. Please note that dropdown list in this sample file is in A7 cell. I want macro code that works on dropdown list regardless of dropdown list position i.e it may be in any other cell in my other files. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security
Re: $$Excel-Macros$$ Macro code requirement
Thanks a lot Ravinder ji for your help. On Wed, Oct 9, 2013 at 6:05 PM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA..actually if you will try to rename excel sheet with “M/s Ram Niwas Sons, K”, excel does not allow u rename and len of sheetname should not be more than 31 character, so I have taken only 31 character if text is more than 31 character. ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Wednesday, October 09, 2013 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Macro code requirement ** ** Dear Sir, This code is working fine in very first file i have sent you but is showing error in next file I have sent you. Please execute macro in attached file see the error. Regards, Mukesh Kumar ** ** On Wed, Oct 9, 2013 at 5:00 PM, Ravinder ravinderexcelgr...@gmail.com wrote: PFA…….. Sub Button2_Click() Application.ScreenUpdating = False 'Application.Calculation = xlCalculationManual Dim sh As Worksheet Dim datash As Worksheet Set datash = Sheets(data) Set sh = ActiveSheet For i = 1 To 300 Sheets.Add after:=Sheets(Sheets.Count) shname = WorksheetFunction.Substitute(datash.Cells(i, 1), /, ) ActiveSheet.Name = shname sh.UsedRange.Copy Sheets(shname).Range(a4).PasteSpecial xlPasteAll Selection.Columns.AutoFit Sheets(shname).Range(a1).ColumnWidth = 15.4 ActiveWindow.DisplayGridlines = False Sheets(shname).Range(a7).Validation.Delete Sheets(shname).Range(a7) = datash.Cells(i, 1) Next sh.Select MsgBox Done End Sub *From:* Ravinder [mailto:ravinderexcelgr...@gmail.com] *Sent:* Wednesday, October 09, 2013 4:04 PM *To:* 'excel-macros@googlegroups.com' *Cc:* Soum (quote.ex...@gmail.com) *Subject:* RE: $$Excel-Macros$$ Macro code requirement pfa *From:* excel-macros@googlegroups.com [ mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Wednesday, October 09, 2013 3:24 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Macro code requirement Dear Sir, I have an excel file in which there are 300 names are there they are given different targets. Now I have to take print outs of these 300 names. I have prepared drop down list of 300 names in cell A7 in attached sample file. My requirement is that I want 300 sheets according to dropdown list. Please provide macro code for this. Sample file is attached. Please note that dropdown list in this sample file is in A7 cell. I want macro code that works on dropdown list regardless of dropdown list position i.e it may be in any other cell in my other files. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members
$$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values
Hello Experts Please provide me solution for the query given in attached file. Thanks Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values
Ashish ji, macro given by you only paste special in column D. But my requirement is according to given examples above Option 1 on running macro the result should be or option 2 Units Rate Amount 1 3 =1*B2 2 4 =2*B3 3 5 =3*B4 4 6 =4*B5 5 7 =5*B6 6 8 =6*B7 7 9 =7*B8 or option 3 My actual requirement is that formula recalculate within formula by values formula can we anywhere in the sheet. Regards, Mukesh Kumar On Sat, Jan 11, 2014 at 10:51 PM, ashish koul koul.ash...@gmail.com wrote: try this Sub test() Range(d2:d8).Value = Range(d2:d8).Value End Sub On Sat, Jan 11, 2014 at 1:38 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Hello Experts Please provide me solution for the query given in attached file. Thanks Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Replace formulas with values
Hi Experts, I need your help. My requirement is that I want to replace cell addresses with their respective values (*paste special not required as it will replace whole formula with values)*, e.g. let's say that the formula of cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to change it so that the formula of cell C2 is =10+20 after running macro. Example file with similar type of macro code is attached for your reference, But this macro is working on column C only also it displaces the result cell by one place. Please provide similar type of macro that work on other formulas too it would be better that on running macro, user form appears that asks for the range where to run this macro. Please provide help. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Replace formulas with values
Ashish ji, this code is working on column C only not on column E which also contains formula. As I have said earlier that user form is required which asks for range of cells first where to apply macro? Any help in this regards will be helpful to me. On Sat, Jan 18, 2014 at 12:50 PM, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim i As Long For i = 2 To Range(a65356).End(xlUp).Row Range(c i).ClearContents Range(c i).Formula = = Range(a i).Value * Range(b i).Value Next End Sub On Sat, Jan 18, 2014 at 12:24 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Hi Experts, I need your help. My requirement is that I want to replace cell addresses with their respective values (*paste special not required as it will replace whole formula with values)*, e.g. let's say that the formula of cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to change it so that the formula of cell C2 is =10+20 after running macro. Example file with similar type of macro code is attached for your reference, But this macro is working on column C only also it displaces the result cell by one place. Please provide similar type of macro that work on other formulas too it would be better that on running macro, user form appears that asks for the range where to run this macro. Please provide help. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message
Re: $$Excel-Macros$$ Replace formulas with values
Thanks Ravi for your help. This sheet fulfills my motive to some extent. But it will not work in following example : *A1=40% ; B2=200 ; C1=100 ; D1=A1*B1+C1. D1 will return 180 and i want to show th caclculation as =40%*200+100* I have searched many forum regarding this following link has some solution, but I didn't understand how to apply these codes. Please help me out in this matter. Link is http://www.vbaexpress.com/forum/showthread.php?19661-Showing-Formula-with-valueshighlight=precedent Regards, Mukesh Kumar On Sat, Jan 18, 2014 at 3:43 PM, Ravi Kumar excellearn2...@gmail.comwrote: Hi, PFA… *Warm Regards,* *Ravi Kumar.* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Saturday, January 18, 2014 12:25 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Replace formulas with values Hi Experts, I need your help. My requirement is that I want to replace cell addresses with their respective values (*paste special not required as it will replace whole formula with values)*, e.g. let's say that the formula of cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to change it so that the formula of cell C2 is =10+20 after running macro. Example file with similar type of macro code is attached for your reference, But this macro is working on column C only also it displaces the result cell by one place. Please provide similar type of macro that work on other formulas too it would be better that on running macro, user form appears that asks for the range where to run this macro. Please provide help. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any
Re: $$Excel-Macros$$ Replace formulas with values
Great Ravi bro. This is exactly what I wanted. Thanks for your help. Regards, Mukesh Kumar On Mon, Jan 20, 2014 at 11:26 AM, Ravi Kumar excellearn2...@gmail.comwrote: PFA…, I guess you are looking for this. J *Warm Regards,* *Ravi Kumar.* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Saturday, January 18, 2014 4:48 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Replace formulas with values Thanks Ravi for your help. This sheet fulfills my motive to some extent. But it will not work in following example : *A1=40% ; B2=200 ; C1=100 ; D1=A1*B1+C1.D1 will return 180 and i want to show th caclculation as =40%*200+100* I have searched many forum regarding this following link has some solution, but I didn't understand how to apply these codes. Please help me out in this matter. Link is http://www.vbaexpress.com/forum/showthread.php?19661-Showing-Formula-with-valueshighlight=precedent Regards, Mukesh Kumar On Sat, Jan 18, 2014 at 3:43 PM, Ravi Kumar excellearn2...@gmail.com wrote: Hi, PFA… *Warm Regards,* *Ravi Kumar.* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Saturday, January 18, 2014 12:25 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Replace formulas with values Hi Experts, I need your help. My requirement is that I want to replace cell addresses with their respective values (*paste special not required as it will replace whole formula with values)*, e.g. let's say that the formula of cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to change it so that the formula of cell C2 is =10+20 after running macro. Example file with similar type of macro code is attached for your reference, But this macro is working on column C only also it displaces the result cell by one place. Please provide similar type of macro that work on other formulas too it would be better that on running macro, user form appears that asks for the range where to run this macro. Please provide help. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like
Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.
Please add my number 9650590467 On 8 Aug 2016 9:43 pm, "Rajeev Ranjan" <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to join. >> >> Add me in WhatsApp and Msg me to - 9500087194 >> >> Regards, >> Prabhu.R >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Job- Required Excel Expert
Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company Role: Data Analyst Salary: Negotiable Functional Area: IT-Other Job Description . Good Analytical skills . Proficient in Advance Excel , Good hands on Excel Formulas and Dynamic Dashboard . Proficient in Excel Formulas(Logical(IF, AND, OR, NOT), Text(LEN, MID, LEFT, RIGHT), Lookup Refrence (Vlookup, Hlookup, Index, Match), Math Trig (Sumif, Sumifs..) . Should have Database Knowledge . Good written and oral communication Skill Company Profile Opera Solutions is one of the world's most rapidly growing consulting firms with offices in Boston, New York, San Diego, New Delhi, London and Shanghai. We specialize in tangible profit enhancement and deliver it through a series of focused practice areas, services and products. Our clients span across industries including Financial Services, Private Equity, FMCG, Publishing, Retail Distribution. We excel at working in 'data rich' environments and achieve outstanding results for our clients using proprietary analytics, and strategic execution talent, turning Big Data into profit growth. Thanks Mukesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Job- Required Excel Expert
Hi Excel Experts, We need urgent some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company Role: Data Analyst Salary: Negotiable Functional Area: IT-Other Job Description . Good Analytical skills . Proficient in Advance Excel , Good hands on Excel Formulas and Dynamic Dashboard . Proficient in Excel Formulas(Logical(IF, AND, OR, NOT), Text(LEN, MID, LEFT, RIGHT), Lookup Refrence (Vlookup, Hlookup, Index, Match), Math Trig (Sumif, Sumifs..) . Should have Database Knowledge . Good written and oral communication Skill Company Profile Opera Solutions is one of the world's most rapidly growing consulting firms with offices in Boston, New York, San Diego, New Delhi, London and Shanghai. We specialize in tangible profit enhancement and deliver it through a series of focused practice areas, services and products. Our clients span across industries including Financial Services, Private Equity, FMCG, Publishing, Retail Distribution. We excel at working in 'data rich' environments and achieve outstanding results for our clients using proprietary analytics, and strategic execution talent, turning Big Data into profit growth. Thanks Mukesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Job- Required Excel Expert
Hi Anil, Please find below my emailid mukeshconsci...@gmail.com Thanks Mukesh - Original Message - From: anil kumar To: excel-macros@googlegroups.com Sent: Saturday, October 22, 2011 12:28 PM Subject: Re: $$Excel-Macros$$ Job- Required Excel Expert Hi Mukesh, Plz send any mail ID -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Job- Required Excel Expert
Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company Role: Data Analyst Salary: Negotiable Functional Area: IT-Other Job Description . Good Analytical skills . Proficient in Advance Excel , Good hands on Excel Formulas and Dynamic Dashboard . Proficient in Excel Formulas(Logical(IF, AND, OR, NOT), Text(LEN, MID, LEFT, RIGHT), Lookup Refrence (Vlookup, Hlookup, Index, Match), Math Trig (Sumif, Sumifs..) . Should have Database Knowledge . Good written and oral communication Skill Company Profile Opera Solutions is one of the world's most rapidly growing consulting firms with offices in Boston, New York, San Diego, New Delhi, London and Shanghai. We specialize in tangible profit enhancement and deliver it through a series of focused practice areas, services and products. Our clients span across industries including Financial Services, Private Equity, FMCG, Publishing, Retail Distribution. We excel at working in 'data rich' environments and achieve outstanding results for our clients using proprietary analytics, and strategic execution talent, turning Big Data into profit growth. Thanks Mukesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help needed..?
Hi Sriram, Please find attached solved sheet. Thanks Mukesh - Original Message - From: sriram ji To: excel-macros@googlegroups.com Sent: Monday, October 24, 2011 7:04 PM Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide formula for this Thanks Regards, Sriram.G Chennai. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Help Needed.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year
Hi lee, Please find attached formula for your query. Thanks Mukesh - Original Message - From: Sara Lee To: excel-macros@googlegroups.com Sent: Monday, October 31, 2011 6:49 AM Subject: $$Excel-Macros$$ formulas to get the week in the month and week of the year hi i have a column in excel with the following date format-- ship date 20110801 20110823 20110903 I need another column adjacent to it which gives me the following results for every respective date above-- basically calcualate month and the week in that particular month in below format... Also the week column should give the week no in the year . for example 20110801 might represent 32 nd week in the year . so i need to fill up 2 columns week-monthweek 08-1 week 08- 4 week 09 -1 week what formulas should i use to generate both the columns -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 Weeknum.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Job- Required Excel Expert
Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company Role: Data Analyst Salary: Negotiable Functional Area: IT-Other Job Description . Good Analytical skills . Proficient in Advance Excel , Good hands on Excel Formulas and Dynamic Dashboard . Proficient in Excel Formulas(Logical(IF, AND, OR, NOT), Text(LEN, MID, LEFT, RIGHT), Lookup Refrence (Vlookup, Hlookup, Index, Match), Math Trig (Sumif, Sumifs..) . Should have Database Knowledge . Good written and oral communication Skill Company Profile Opera Solutions is one of the world's most rapidly growing consulting firms with offices in Boston, New York, San Diego, New Delhi, London and Shanghai. We specialize in tangible profit enhancement and deliver it through a series of focused practice areas, services and products. Our clients span across industries including Financial Services, Private Equity, FMCG, Publishing, Retail Distribution. We excel at working in 'data rich' environments and achieve outstanding results for our clients using proprietary analytics, and strategic execution talent, turning Big Data into profit growth. Thanks Mukesh -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ remove a certain text from every sentence
Hi Smitha, Try below formula =RIGHT(A1,LEN(A1)-FIND(:,A1)) Thanks Mukesh - Original Message - From: smitha.kumari To: excel-macros@googlegroups.com Sent: Thursday, November 10, 2011 11:32 AM Subject: RE: $$Excel-Macros$$ remove a certain text from every sentence The result should be david and not Technology company Regards Smitha/ Senior Finance Executive World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Thursday, November 10, 2011 11:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ remove a certain text from every sentence Use This command Thanks with Mothilal.J -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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 image001.jpgimage002.png