Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

**deke87** · 10-19-2012, 06:42 PM

Hello, I am an extremely limited VB user and I need assistance in developing a script. I need a script that will allow me to pull rows from multiple workbooks in a folder (named_workbook1.xls thru named_workbook27.xls). I only want to pull rows that match a specific list of values in an existing spreadsheet (OPS_Summary.xls). I then want the matching row(s) to populate a worksheet.

The individual workbooks have information on specific locations (rooms). This information is in column 'L' on each worksheet of each workbook. Each workbook has information on up to three worksheets and I want to filter and copy the information from all worksheets. I want the filter to identify pertinent rows that match a list of existing room numbers that is in a worksheet in OPS_Summary.xls. I then want this information to be populated in OPS_Summary.xls based on which room number it matches. I do not want to add function to each individual sheet in the folder, I only want the macro to live in OPS_Summary.xls.

I have used get_filter_macro example from rondebruin.nl but have not been able to make the example functions work. I have used his code and attempted to point to column 'L' but it does not work for me. I am probably doing it wrong.

Any assistance that anyone may be able to provide is GREATLY appreciated.

**arlu1201** · 10-20-2012, 01:37 AM

Sure this is doable but you need to provide more info.

Why not attach a sample file? Also attach a copy (or sample) of your OPS_Summary file so we can see what are the criteria for the filters.

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.

**deke87** · 10-20-2012, 07:09 AM

Thank you for your interest in helping. I have attached the workbook. I am attempting to use the
' RDB_Filter_Data in the "Get_Filter_Macro" module ' from this website: http://www.rondebruin.nl/fso.htm

The data is to be filtered against the list of room numbers in sheet5 of the attached file. Again, thank you for any assistance you can lend.

**arlu1201** · 10-24-2012, 06:41 AM

It will be good if you explain what you need in detail. This is what i have understood so far and you can correct me if i am wrong -

1. You have multiple workbooks similar to the sample file in one folder.
2. You want to consolidate the data from each file.
3. The data is present in OPS Spaces.
4. Only rows that have data in column D should be consolidated.

Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

LinkBack

Thread Tools

Rate This Thread

Display

Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

Re: Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

Re: Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

Re: Need to copy filtered rows from multiple workbooks in a folder to an existing workbook

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions