Copy row from one workbook to another

's Computer Specifications

Hello,

I need to copy rows 1 - 4 from one workbook to another workbook. I wouldn't
think it would be that difficult, but I can't figure it out. Appreciate any
help. I'm using Excel 2003.

Thanks.

's Computer Specifications

Hi,
try
Sub Macro1()
'
' Macro1 Macro
'

'
Sheets("Sheet2").Select
Rows("1:4").Select
Selection.Copy
Sheets("Sheet1").Select
ActiveSheet.Paste
End Sub

"C Holmes" wrote:

> Hello,
>
> I need to copy rows 1 - 4 from one workbook to another workbook. I wouldn't
> think it would be that difficult, but I can't figure it out. Appreciate any
> help. I'm using Excel 2003.
>
> Thanks.

's Computer Specifications

You can do that manually by selecting the range to copy, then Edit>Copy
---Activate the other workbook, select the anchor cell, then Edit>Paste.

For VBA:

Sub cpyRw1_4()
Set wb1 = ActiveWorkbook.ActiveSheet
Set wb2 = Workbooks(2).Sheets(1)
wb1.Rows("1:4").Copy wb2.Range("A1")
End Sub

Sub
"C Holmes" wrote:

> Hello,
>
> I need to copy rows 1 - 4 from one workbook to another workbook. I wouldn't
> think it would be that difficult, but I can't figure it out. Appreciate any
> help. I'm using Excel 2003.
>
> Thanks.

's Computer Specifications

Thanks everyone, got it working!

"C Holmes" wrote:

> Hello,
>
> I need to copy rows 1 - 4 from one workbook to another workbook. I wouldn't
> think it would be that difficult, but I can't figure it out. Appreciate any
> help. I'm using Excel 2003.
>
> Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook	Chip Pearson	Microsoft Excel Programming	0	26th May 2009 04:27 PM
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1	u473	Microsoft Excel Programming	1	9th Sep 2008 05:14 PM
Copy data from Workbook Alpha & reorganize it in Workbook Bravo	u473	Microsoft Excel Programming	1	31st Oct 2007 02:37 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook	burl_rfc	Microsoft Excel Programming	1	1st Apr 2006 08:48 PM
Copy a range of cells in an unopened workbook and paste it to the current workbook	topstar	Microsoft Excel Programming	3	24th Jun 2004 12:50 PM