Search : in
By :

Copy data from one excel to another excel

Last answer on Nov 1, 2009 4:35:00 am GMT region4t, on Oct 31, 2009 5:01:16 am GMT 
 Report this message to moderators

Hello,

Hi ppl,
I need your help.I am new to Macro in excel and some say that we need to write vba code to do it.
My question follows:

I have 2 xl say A.xls and B.xls
A.xls has one sheet- sheet1.
B.xlx has 3 sheets- sheet1, sheet2, sheet 3

I need to copy the data from sheet 1 of A.xls to Sheet 1 of B.xls.
Sheet2, sheet3 of B.xls contains some other data.
How do I do it.please help me out.

I did some coding in VBA....but when ever i use the macro to execute it i get the sheet1 of A.xls being copied to Sheeet 1 (1) of B.xls.
The next time i execute the macro I get once again sheet1 of A.xls being copied to new sheet 1 (2) of B.xls

The copy of sheet 1 of A.xls being replicated evry time whenever i execute the macro.....
Please help me out friends...
All I need is the sheet 1 of A to be copied to sheet 1 of B
or whenever a data is entered in Sheet 1 of A, it needs to be updated in sheet 1 of B without the other 2 sheets of B.

Configuration: Windows XP
Firefox 3.0.15

Best answers for « Copy data from one excel to another excel » in :
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Excel – How to extract partial data? ShowExcel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Download Excel Viewer Show
Download Data Quik ShowData Quik allows you to copy data between two or several databases. This program can quickly copy data without using any other software and lets you select the fields or part of the tables to be copied. To accomplish that, it supports the files of...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

iveal, on Oct 31, 2009 5:35:26 am GMT
  • +1

Dear Sir,

You can actually make use of the following to solve the problem that you are having. It will

automatically copy the sheets.

Sub CopyPaste()
Dim ws As Worksheet
For Each ws In Worksheets

If ws.Name <> "Master Sheet" Then
ws.Select
ws.Application.Run "Macro1"
End If
Next
End Sub

Sub Macro1()
Range("A2:B13").Select
Selection.Copy
Sheets("Summary Sheet").Select
ActiveSheet.Paste
End Sub


Thanks.

   
Reply to iveal

2

 region4t, on Nov 1, 2009 4:35:00 am GMT

Thanks men........but still I am unclear about .........
Well there are 2 different woorkbook. Say A.xls and B.xls

A.xls has ----Sheet 1
B.xls has -----Sheet 1, Sheet2,Sheet3
They reside is two different folders.
In the above code where do I mention the path of residence of the 2 workbooks.
And also where i place the code in book A.xls or B.xls....

wil this code automatically copy/ replicate the data in Sheet 1 of A.xls to Sheet 1 of B.xls.......

   
Reply to region4t
Ask your question Reply
They need your help