Copy Data from one workbook to another

's Computer Specifications

Hi experts

Thanks in advance for your help.

I have two files - "Tool" and "MasterFile".

I need to pick up 3 columns (how many ever populated rows are there)
from Sheet 1 in the file called "MasterFile" (Columns I, J and M) and
paste them in the "RawData" sheet of the file named "Tool".

I tried looking at the groups for possible solutions but could not
find a solution.

Also I want this action (macro) to be run from the file named "Tool".

Best Regards
Prasad

's Computer Specifications

I would think that if you recorded a macro when you copied and pasted, then your
macro would be pretty close to done.

EE wrote:
>
> Hi experts
>
> Thanks in advance for your help.
>
> I have two files - "Tool" and "MasterFile".
>
> I need to pick up 3 columns (how many ever populated rows are there)
> from Sheet 1 in the file called "MasterFile" (Columns I, J and M) and
> paste them in the "RawData" sheet of the file named "Tool".
>
> I tried looking at the groups for possible solutions but could not
> find a solution.
>
> Also I want this action (macro) to be run from the file named "Tool".
>
> Best Regards
> Prasad

--

Dave Peterson

's Computer Specifications

See Ron de Bruin's site

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples

Gord Dibben MS Excel MVP

On Wed, 15 Aug 2007 23:53:50 -0000, EE <(E-Mail Removed)> wrote:

>Hi experts
>
>Thanks in advance for your help.
>
>I have two files - "Tool" and "MasterFile".
>
>I need to pick up 3 columns (how many ever populated rows are there)
>from Sheet 1 in the file called "MasterFile" (Columns I, J and M) and
>paste them in the "RawData" sheet of the file named "Tool".
>
>I tried looking at the groups for possible solutions but could not
>find a solution.
>
>Also I want this action (macro) to be run from the file named "Tool".
>
>Best Regards
>Prasad

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to copy specific data from master workbook to another workbook	Mark767	Microsoft Excel Programming	13	1st Sep 2009 08:57 PM
Copy data from Workbook Alpha & reorganize it in Workbook Bravo	u473	Microsoft Excel Programming	1	31st Oct 2007 02:37 AM
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.	Cristobalitotom	Microsoft Excel Programming	0	6th Jul 2006 12:24 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 Data from Workbook into specific Worksheet in other Workbook?	kingdt	Microsoft Excel Misc	1	16th Mar 2006 06:55 PM