Copy Data from one workbook to another
 

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

Copy Data from one workbook to another
 

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

Copy Data from one workbook to another
 

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 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