Hi all,

I need help for vba code for creating a master file. I would like to create a master file which needs to be read only in Excel format. The information for the master file is integrated from three different excel workbooks and only a particular information (eg. Column B and Column E only) is outsourced for the master file. When the information in the workbook is updated, the master file needs to show the most updated status. Do you know how can I get this done?

Thanks in advanced.