Copy paste data on each worksheet of a file

[nicolaforni]

Hi,

I have a file called Data.xls in directory P:\Lonib\Data.xls and I need to copy range C3:E8 from this file onto each worksheet of a different file called Fruit.xls which is found in directory C:\Lonib\Fruit.xls.
The data must be copied onto range K3:M8 of each worksheet of file Fruit.xls.

How do I do that?



Nix

[ragulduy]

You can do this fairly simply without any VBA:
1. Open both files
2. Select C3:E8 in data.xls and copy
3. Select all the worksheets in fruit.xls (click on the first sheet then hold shift and click the last sheet)
4. Select K3 and paste

[nicolaforni]

Great thanks!

Nix