Copying Data from One Excel Workbook To Another

sandeep - Mar 9, 2015 at 02:29 PM

Newbie here, on my organization my reportees are sending me a report on a daily basis, the pain is to collate each of these sheets onto 1 and do the final dashboard reporting. I would like to know if there is any option where i can use VBA to copy entire contents from one workbook to another Master work book on a button click ideally.