Urgent : Macro code is not working properly.

Dear All,

Below mentioned is the code which I have writen to select, copy and paste the data in new file, but my code is not working. First let me explain what I am looking for.

1) I have Workbook with salary sheet for one company, which I want to break into location.
2) In the workbook, I have two sheet one is Salary and Second is branches.
3) I want to fillter the salary sheet and as per the branches detail mentined in the second sheet.
4) I want to save the filltered data in new worksheet, which is already saved in Demo follder.

Now, my all things are working, but when the macro reached at the level to paste the fillered data on new workbook book it ask to "Select destination and press ENTER or choose paste".

Request you to kindly advice.

Please Login or Register  to view this content.

Thanks & Regards
Kumar Gourav

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.