Consulting

Results 1 to 2 of 2

Thread: Consolidation of various files based on cell value/Filter

  1. #1

    Consolidation of various files based on cell value/Filter

    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"

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •