Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste ranges from a close book using Validation
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
Data Validation - copy paste ! | Excel Worksheet Functions | |||
Select, find in another book, copy, return and paste | Excel Discussion (Misc queries) | |||
How do I copy and paste ranges from VB 6.0 in an Excel spreadsheet? | Excel Programming | |||
Copy and Paste ranges between files | Excel Programming |