collect information from many workbooks using filters

**valveless** · 12-10-2008, 04:44 PM

Hi everyone,

I have a problem I can't solve.
I have many workbooks that I have a userform to input data to. that works fine. each workbook has a sheet called "RefBase", which has a date entry in the first column (format dd/mm/yy).

What I want to be able to do is open a master workbook with a header row, and use a macro, or user form or addin to search all the workbooks in a folder for rows containing a particular date, and paste that information back to the master workbook in the next empty row.

I can't add examples of what I have so far as the information I'm using is data protected.

I did find Ron de Bruin's site with his merge and autofilter stuff, but I can't get it to work. Can anyone help me?

**stanleydgromjr** · 12-10-2008, 05:22 PM

valveless,

Welcome to the ExcelTip Board.

master workbook with a header row

Please attach a sample workbook with two worksheets, one the "Summary" or "Collection" sheet in your "master workbook", and one a copy of the "workbooks in a folder".

What is the sheename in the "workbooks in a folder"?

What is the full path to the "folder"?

Scroll down and see - "Manage Attachments".

Have a grat day,
Stan

**valveless** · 12-15-2008, 09:31 AM

Hi,

Ok. I've had to clear some bits but this is what I have so far.

The Make Referrals file is for a user (1 of possible 50) to enter information which is stored in rows with the current date.

The Master Referral File (MRF) needs to be able to use the form already there to enter the date they require, (ie all referrals made on this date) and for the MRF to open all files in a folder (say G:\*.xls for now), search for all rows with that particular date (which is in the second column of the Make Referrals file) and paste the data from each sheet to the MRF in the next available column.

The Sheet name in the make referrals file is called RefBase with the data on it.

Thanks in advance for you help Stan