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
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
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,
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
--
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
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
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
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
=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)
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
: $$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
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
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
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
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:
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:
16 matches
Mail list logo