--
*From: * ashish koul koul.ash...@gmail.com
*Date: *Sun, 9 Mar 2014 22:42:50 +0530
*To: *excel-macrosexcel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com
which row you want to pick how r u going to decide
share how output will look like
Sent on my BlackBerry(R) from Vodafone
--
*From: * ashish koul koul.ash...@gmail.com
*Date: *Sun, 9 Mar 2014 22:42:50 +0530
*To: *excel-macrosexcel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Excel Forum available
which row you want to pick how r u going to decide that
On Sun, Mar 9, 2014 at 1:26 PM, Leo Ruphen logaroo...@gmail.com wrote:
Hi Ashish,
Thanks for the prompt reply, But i have few columns to be copied to the
invoice.
Please refer attachment for more details
Thanks and Regards
Leo
On
Can u share how output will look like
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: ashish koul koul.ash...@gmail.com
Date: Sun, 9 Mar 2014 22:42:50
To: excel-macrosexcel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com
Hi Sir,
Could you help me with vba codes. I need help on vba code to copy data from
sheet 1 and paste in sheet 2.
But the range to copy the data is different from the range to copy the data,
for example : copy from (R20) and paste in (T10).
The sheet 2 is a invoice, There is around 15 rows in
Hi Sir,
Could you help me with vba codes. I need help on vba code to copy data from
sheet 1 and paste in sheet 2.
But the range to copy the data is different from the range to copy the data,
for example : copy from (R20) and paste in (T10).
The sheet 2 is a invoice, There is around 15 rows in
Hi Sir,
Could you help me with vba codes. I need help on vba code to copy data from
sheet 1 and paste in sheet 2.
But the range to copy the data is different from the range to copy the data,
for example : copy from (R20) and paste in (T10).
The sheet 2 is a invoice, There is around 15 rows in
try this see if it helps
Sub test()
Sheets(Sheet1).Rows(20:20).Copy
Destination:=Sheets(Sheet2).Range(a15) ' to copy whole row
Sheets(Sheet1).Range(R20).Copy
Destination:=Sheets(Sheet2).Range(t10) ' to copy cell content
End Sub
On Sun, Mar 9, 2014 at 11:16 AM, Leo Ruphen
Hi Ashish,
Thanks for the prompt reply, But i have few columns to be copied to the
invoice.
Please refer attachment for more details
Thanks and Regards
Leo
On Sunday, 9 March 2014 13:51:43 UTC+8, ashish wrote:
try this see if it helps
Sub test()
Sheets(Sheet1).Rows(20:20).Copy