PDA

View Full Version : Consolidation of various files based on cell value/Filter



aravindhan_3
12-06-2010, 02:01 AM
Hi,

Thank you all for your help,
I need your help once again for consolidating various files into my master file , I found similar codes from http://www.rondebruin.nl/fso.htm site but my requirement is bit different from those.

I have a master file in my C:/Master folder with Heading in row 2( Same as all other files)
and I have some 100 files in C:/working_Files folder( Heading in 301th row and datas from there on)

I need a macro in my master file to consolidate the data from all those 100 files ( starts from 302 row in all the files) and put in my master file from row 3 onwards one afterthe other)
however this should happen based on a condition
If I enter the Date in Cell A1 in my master file( Say 05-Dec-2010) Then look in Column AC(Processed Date) in all those 100 files, filter the data by the above date and get the data to my master file
Next time if I change the date and run again, then get data only for this date and paste below. But by mistake if I keep the same date and run the macro then it should tell me that "I am trying to import duplicate data"

aravindhan_3
12-06-2010, 07:21 AM
Cross Post : http://www.excelforum.com/excel-programming/755630-consolidation-of-various-files-based-on-cell-value-filter.html#post2429890