Hi Group,
Pls help me on this, it will make my life easy...
- Original Message -
From: Dave Bonallack
To: excel-macros@googlegroups.com
Sent: Monday, September 20, 2010 4:15 PM
Subject: RE: $$Excel-Macros$$ Column Data in Rows Table
Hi,
Sorry, but someone else will have
uot;Sheet1").Cells(R, C).Value
End If
Next C
Next R
Sheets("sheet2").Select
End Sub
Paul
>
>From: Dave Bonallack
>To: "excel-macros@googlegroups.com"
>Sent: Mon, September 20, 2010 6:45:08 AM
>Subject: RE: $$Excel-Macros$$ Colum
, 2010 2:32 PM
Subject: RE: $$Excel-Macros$$ Column Data in Rows Table
Hi Sayyad,
Have a look at the attached.
Click the button on sheet 2.
Regards - Dave
> Date: Tue, 7 Sep 2010 23:30:20 -0700
> Subject: $$Excel-Macros$$ Column Data in Rows Table
> From: anamika2...@gmail.com
> To:
Thx ,, This is very helpful & clear solution
On Sep 9, 6:25 am, siti Vi wrote:
> *(1) : Macro VBA-Excel Solution*
>
> Private Sub CommandButton1_Click()
> Dim SrceTbl As Range, DestTbl As Range
> Dim r As Long, nr As Long, c As Integer
> Set SrceTbl = Sheets("Sheet1").Cells(1, 1).Curren
*(1) : Macro VBA-Excel Solution*
Private Sub CommandButton1_Click()
Dim SrceTbl As Range, DestTbl As Range
Dim r As Long, nr As Long, c As Integer
Set SrceTbl = Sheets("Sheet1").Cells(1, 1).CurrentRegion
Set DestTbl = Sheets("Sheet2").Cells(2, 2)
For r = 2 To SrceTbl.Rows.Count
Hi Dave ,
Thanks but if you see the output I am expecting I need data in 3
columns ..i.e. column headings also need to displayed against each
cell
On Sep 8, 2:02 pm, Dave Bonallack wrote:
> Hi Sayyad,
>
> Have a look at the attached.
>
> Click the button on sheet 2.
>
> Regards - Dave
>
>
>
> >
Hi Sayyad,
Have a look at the attached.
Click the button on sheet 2.
Regards - Dave
> Date: Tue, 7 Sep 2010 23:30:20 -0700
> Subject: $$Excel-Macros$$ Column Data in Rows Table
> From: anamika2...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi ,
>
> I have a case where I get the data
