Need help modifying a macro to open up workbooks and paste filtered data

[LinkiePoo]

I am using the code below to split a worksheet into multiple workbooks and it works great. Now, what I need to do is to modify this code to perform the same function on a different spreadsheet. I need the data filtered, but instead of saving the filtered data to a new workbook, I need it to open the file with the "Item" name and paste the different data to a new sheet - "Sheet2".

Basically, I only want one workbook per "Item" of data - each workbook would have 2 sheets. Can anyone assist with this?

Please Login or Register  to view this content.

[arlu1201]

So is there data already in the "Item" workbook in Sheet1?

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.

[LinkiePoo]

Here is a sample. This is for District 789. My source file will have many different district #s in it. What I would like to do from the source document is copy district 789 source data, open up the previously saved district 789 workbook and paste the data to a new tab.

Thanks for your help!