Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
mind blowing Haseeb, On Sat, Oct 29, 2011 at 5:52 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello XLS S; Let me try to explain my best :) In sheet2 B1, used a formula to get all items in sheet1, which is =COUNTA(Source!A3:Z65536) B2, used too get total columns used, which is =COUNTA(Source!A2:Z2) Based on the attached, there are 3 columns 300 rows. So, first 3 rows need the data from row 1 in sheet1, but different columns. Next 3 rows from Row2 Row1_ColA Row1_ColB Row1_ColC Row2_ColA Row2_ColB Row2_ColC So, the logic is after 3 rows Row # needs to increase 1, Column # needs to add 1 on each row, after 3 rows it needs to reset to 1 INT will rounddown a value to Integral. say, 2.9 will round to 2, 0.0001 to 0, 3.5 to 3 etc A5 formula =INDEX(Source!$A$3:$Z$65536,INT((ROWS(A$5:A5)-1)/$B$2)+1,MOD(ROWS(A$5:A5)-1,$B$2)+1) (ROWS($A5:A5)-1) *| *How may rows in A5:A5 = 1, 1-1 = 0 (ROWS($A5:A5)-1)/$B$2 *|* 0/3 = 0 INT((ROWS(A$5:A5)-1)/$B$2)+1 *|* INT(0)+1, 0+1 = 1 MOD function will returns the remainder after number is divided by divisor. eg: =MOD(3,6), multiplication of 6 where falls =3, here it returns 1. If number is less than the divisor, MOD will return the same number. =MOD(20,6), multiplication of 6 where falls =20, here it falls on 18 (3*6), So the remaining value is 2. MOD will return 2 =MOD(25,5) multiplication of 5 where falls =25, here it falls on 25 (5*5), So the remaining value is 0. MOD will return 0 In the attached, MOD(ROWS(A$5:A5)-1,$B$2)+1 ROWS($A5:A5)-1 *| *How may rows in A5:A5 = 1, 1-1 = 0 MOD(0,3)+1 *|* 0+1 = 1 So the INDEX will become, INDEX(Source!$A$3:$Z$65536,1,1) A15, formula will be like =INDEX(Source!$A$3:$Z$65536,INT((ROWS(A$5:A15)-1)/$B$2)+1,MOD(ROWS(A$5:A15)-1,$B$2)+1) INT((ROWS(A$5:A15)-1)/$B$2)+1 *|* INT(10/3)+1, INT(3.33)+1, INT(3)+1, 3+1 = 4 MOD(ROWS(A$5:A15)-1,$B$2)+1 *|* MOD(10,3)+1, MOD(1)+1,1+1 = 2 So the INDEX will become, INDEX(Source!$A$3:$Z$65536,4,2) If you use Formula Evaluator tool, you can see the calculation easily step by step than my longest explanation :) HTH Haseeb -- 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
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Hello XLS S; Let me try to explain my best :) In sheet2 B1, used a formula to get all items in sheet1, which is =COUNTA(Source!A3:Z65536) B2, used too get total columns used, which is =COUNTA(Source!A2:Z2) Based on the attached, there are 3 columns 300 rows. So, first 3 rows need the data from row 1 in sheet1, but different columns. Next 3 rows from Row2 Row1_ColA Row1_ColB Row1_ColC Row2_ColA Row2_ColB Row2_ColC So, the logic is after 3 rows Row # needs to increase 1, Column # needs to add 1 on each row, after 3 rows it needs to reset to 1 INT will rounddown a value to Integral. say, 2.9 will round to 2, 0.0001 to 0, 3.5 to 3 etc A5 formula =INDEX(Source!$A$3:$Z$65536,INT((ROWS(A$5:A5)-1)/$B$2)+1,MOD(ROWS(A$5:A5)-1,$B$2)+1) (ROWS($A5:A5)-1) *| *How may rows in A5:A5 = 1, 1-1 = 0 (ROWS($A5:A5)-1)/$B$2 *|* 0/3 = 0 INT((ROWS(A$5:A5)-1)/$B$2)+1 *|* INT(0)+1, 0+1 = 1 MOD function will returns the remainder after number is divided by divisor. eg: =MOD(3,6), multiplication of 6 where falls =3, here it returns 1. If number is less than the divisor, MOD will return the same number. =MOD(20,6), multiplication of 6 where falls =20, here it falls on 18 (3*6), So the remaining value is 2. MOD will return 2 =MOD(25,5) multiplication of 5 where falls =25, here it falls on 25 (5*5), So the remaining value is 0. MOD will return 0 In the attached, MOD(ROWS(A$5:A5)-1,$B$2)+1 ROWS($A5:A5)-1 *| *How may rows in A5:A5 = 1, 1-1 = 0 MOD(0,3)+1 *|* 0+1 = 1 So the INDEX will become, INDEX(Source!$A$3:$Z$65536,1,1) A15, formula will be like =INDEX(Source!$A$3:$Z$65536,INT((ROWS(A$5:A15)-1)/$B$2)+1,MOD(ROWS(A$5:A15)-1,$B$2)+1) INT((ROWS(A$5:A15)-1)/$B$2)+1 *|* INT(10/3)+1, INT(3.33)+1, INT(3)+1, 3+1 = 4 MOD(ROWS(A$5:A15)-1,$B$2)+1 *|* MOD(10,3)+1, MOD(1)+1, 1+1 = 2 So the INDEX will become, INDEX(Source!$A$3:$Z$65536,4,2) If you use Formula Evaluator tool, you can see the calculation easily step by step than my longest explanation :) HTH Haseeb -- 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$$ Need your support (Re-arrange_the_products)
excel 2007 not support VBA coding so save ur in excel 2003 or xlsb On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Dear Noorain, when I am saving your file it shows the attached error. please suggest. Regards, Aamir Shahzad On Mon, Oct 24, 2011 at 5:03 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Haseeb, why u use int or mod function ? pleas tell me On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello Murali; You can also use INDEX with INT MOD see the attached HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
xlstime, that is the most hilarious statement I have ever seen. You might want to reiterate. Excel 2007 has the macro enabled file and the non-macro file apart from a few other formats. To use VBA, you'll have to save the file as a macro enabled file, and the extension is .xlsm Any file saved in .xlsx format cannot contain VBA, except that it can be a place holder while it is yet not saved. Regards and Happy Diwali to all, Sam Mathai Chacko (GL) On Wed, Oct 26, 2011 at 7:43 AM, xlstime xlst...@gmail.com wrote: excel 2007 not support VBA coding so save ur in excel 2003 or xlsb On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Dear Noorain, when I am saving your file it shows the attached error. please suggest. Regards, Aamir Shahzad On Mon, Oct 24, 2011 at 5:03 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- 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 -- Sam Mathai Chacko --
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Sorry Sam you are completely , i mean excel 2007 (Excel workbook not support vba) so save ur file in excel 2003 or excel macro enable 2007 format On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Dear Noorain, when I am saving your file it shows the attached error. please suggest. Regards, Aamir Shahzad On Mon, Oct 24, 2011 at 5:03 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Re-arrange_the_products(Solved).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
=INDEX($A$3:$C$10,ROUNDUP(ROW(INDIRECT(1:COUNTA($A$3:$C$10)))/COLUMNS($A$3:$C$10),0),IF(MOD(ROW(INDIRECT(1:COUNTA($A$3:$C$10))),COLUMNS($A$3:$C$10))=0,COLUMNS($A$3:$C$10),MOD(ROW(INDIRECT(1:COUNTA($A$3:$C$10))),COLUMNS($A$3:$C$10 Use this formula as an array. Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 5:33 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- 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-arrange_the_products.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Option Explicit Sub TransposeRowsToColumns_SAS() Dim i As Long For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row Cells(i, 1).Resize(, 3).Copy Cells(Rows.Count, 6).End(xlUp).Offset(1).PasteSpecial _ Paste:=xlPasteAll, Operation:=xlNone, Transpose:=True Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: MURALI NAGARAJAN Sent: Monday, October 24, 2011 6:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need your support (Re-arrange_the_products) Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
IF? you use a formula you may want to convert to values to keep from cluttering the file with a lot of unnecessary calculation. Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Monday, October 24, 2011 7:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products) =INDEX($A$3:$C$10,ROUNDUP(ROW(INDIRECT(1:COUNTA($A$3:$C$10)))/COLUMNS($A$3:$C$10),0),IF(MOD(ROW(INDIRECT(1:COUNTA($A$3:$C$10))),COLUMNS($A$3:$C$10))=0,COLUMNS($A$3:$C$10),MOD(ROW(INDIRECT(1:COUNTA($A$3:$C$10))),COLUMNS($A$3:$C$10 Use this formula as an array. Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 5:33 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear noorain, Excellent,is there any formula available? On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Dear Shahzad, Please save this file in your Excel 2010, I hope it will be error Free. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Re-arrange_the_products(Solved).xlsm Description: Binary data
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Your are right but can I not save file with coding? when I save file this simply in excel format this do not save code. Aamir Shahzad On Mon, Oct 24, 2011 at 8:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shahzad, Please save this file in your Excel 2010, I hope it will be error Free. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
There were two posts with formula based solutions. Have you checked those? Sam On Mon, Oct 24, 2011 at 8:40 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Your are right but can I not save file with coding? when I save file this simply in excel format this do not save code. Aamir Shahzad On Mon, Oct 24, 2011 at 8:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shahzad, Please save this file in your Excel 2010, I hope it will be error Free. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
ok sorry now saving the code file in xlsm format. On Mon, Oct 24, 2011 at 8:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: There were two posts with formula based solutions. Have you checked those? Sam On Mon, Oct 24, 2011 at 8:40 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Your are right but can I not save file with coding? when I save file this simply in excel format this do not save code. Aamir Shahzad On Mon, Oct 24, 2011 at 8:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Shahzad, Please save this file in your Excel 2010, I hope it will be error Free. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)
Correct Shahzad, after saving in .xlsm format, you will be able to view code in VBE. On Mon, Oct 24, 2011 at 8:43 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: ok sorry now saving the code file in xlsm format. On Mon, Oct 24, 2011 at 8:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: There were two posts with formula based solutions. Have you checked those? Sam On Mon, Oct 24, 2011 at 8:40 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Your are right but can I not save file with coding? when I save file this simply in excel format this do not save code. Aamir Shahzad On Mon, Oct 24, 2011 at 8:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Shahzad, Please save this file in your Excel 2010, I hope it will be error Free. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 24, 2011 at 5:26 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Murali, Please try below Code and See attached sheet. Sub re_arrange() Dim i, j, k, l As Integer j = Range(A65536).End(xlUp).Row l = 3 For i = 3 To j For k = 1 To 3 Sheet1.Range(F l).Value = Sheet1.Cells(i, k).Value l = l + 1 Next k Next i End Sub -- On Mon, Oct 24, 2011 at 5:18 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear excel experts, I have a doubt below attached file, kindly provide exact solution for this problem. Thanks Regards Murali.N Chennai-50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari