View Single Post
 
Old 04-24-2015, 08:45 PM
vedha vedha is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Apr 2015
Posts: 1
vedha is on a distinguished road
Default data entered in one workbook should be updated in other relevant workbook based on the date

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
Reply With Quote