Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2015, 08:45 PM
vedha vedha is offline data entered in one workbook should be updated in other relevant workbook based on the date Windows 7 32bit data entered in one workbook should be updated in other relevant workbook based on the date Office 2007
Novice
data entered in one workbook should be updated in other relevant workbook based on the date
 
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
Reply

Thread Tools
Display Modes


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
data entered in one workbook should be updated in other relevant workbook based on the date #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
data entered in one workbook should be updated in other relevant workbook based on the date macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft