Hi everybody..
i have n workbooks.
one is main workbook.
second, third.. workbooks are for data to be organised in particular date

first workbook name : All_data
second workbook name : Data_25_4_2015
third workbook name : Data_26_4_2015
fourth workbook...and so on..

my requirement is...
i enter data in All_data. there is a dedicated column to enter the date in this workbook.
based on the date entered, the entire record should be updated in second or relevant work book named with that date.

Example:

record in 'All_data' workbook.
A B C D
Customer1| attended the meeting| need to call again on| 25/4/2015|
Customer2| not attended | need to call on | 27/4/2015|

so now based on the data i entered in all_data workbook, records should get updated in relevant workbooks. if relevant workbook is not available in specified folder it should create one and update.

Purpose:
daily i get number of requests in my business operations. but the request should be processed in a particular date as we suggest.
soon i enter a suggested date, total record of that particular request should be updated in relevant workbook maintained on date basis, so as to enable the caller to easily identify the customers to be called up on that particular date.
hope you can understand my requirement..

thanks for your help.
regards


Vedh