I would like to combine worksheets from different workbook to a Workbook Master with just a click of macro button on Workbook Master.
For example, copy
Workbook Jan Worksheet Ace to Workbook Master Worksheet Ace
Workbook Feb Worksheet Janice to Workbook Master Worksheet Janice
Workbook Mac Worksheet Grace to Workbook Master Worksheet Grace
All the Workbooks will be stored at the same directory C:\Project
Anyone knows how to configure the macro? Please help!!!
For example, copy
Workbook Jan Worksheet Ace to Workbook Master Worksheet Ace
Workbook Feb Worksheet Janice to Workbook Master Worksheet Janice
Workbook Mac Worksheet Grace to Workbook Master Worksheet Grace
All the Workbooks will be stored at the same directory C:\Project
Anyone knows how to configure the macro? Please help!!!