|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
Replace contents form 1 workbook with another based on simular data | shabbaranks | Excel | 1 | 12-05-2012 11:11 PM |
#REF! error when opening a workbook that contain a refference to another workbook | tanababa | Excel | 2 | 06-07-2012 03:11 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |