Dear All, I want to update the status in master file from various users. The user files are located in particular folder but the count and name of these user is not define. Hence all records in master file should search all the user file (in same folder and in same format) and update the status till current date.
pls find attached the master file.The user file will have same details and user name will be the same as user file name ( for ex file a.xls is for user a). Thanks in advance. Kind Regards, Hemant -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Master.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet