Copy and paste ranges from a close book using Validation

S

stakar

Hi !!

I 've got 2 excel files.
In the 1st file, called "Hunter.xls" , I have created a validation lis
with the follow items
"One"
"Two"
"Three"
under the cell H3

Now, when i choose an item e.g the "One" i want to trigger a macro tha
doing the following :

1. To be connected to a closed workbook named "Symm.xls" which is i
the same directory as "Hunter.xls"
2. going to the sheet("Age2")
3. copying the range(C4:C1500) as values
and then at last to
4.paste them to the file "Hunter.xls" under the cell H3

If i 'll choose the item "Three" it will trigger the same macro a
above but with another range to copy from the workbook "Symm.xls"

So its goes on till the end of the choices of the validation list

Thanks in advance
Stathi
 
Top