Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one file sheet into another
Hi: Can any one please tell me how to i copy data from one file sheet
into another file sheet? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one file sheet into another
Anna
Do you mean another workbook, or another worksheet? Below is the answer to both, bearing in mind the named references of worksheets and workbooks Sub CopyToAnotherSheet() Worksheets("Sheet1").Range("A1").Copy Destination:=Worksheets("Sheet2").Range("A1") End Sub Sub CopyToAnotherWorkbook() Dim wb1 As Workbook Dim wb2 As Workbook Set wb1 = ActiveWorkbook Set wb2 = Workbooks("Book2") wb1.Worksheets("Sheet1").Range("A1").Copy Destination:=wb2.Worksheets("Sheet2").Range("A1") End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Anna" wrote in message ups.com... Hi: Can any one please tell me how to i copy data from one file sheet into another file sheet? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
Lookup on a sheet so that every time when file open it copes data from another file sheet | Excel Programming | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions |