Hi all,


Here's some background...


My office received daily emails with an excel file attached that is password protected. Every day, we open up the excel file attachment and copy/paste the daily data into a consolidated spreadsheet.


This consumes a lot of manpower each day, and there has to be a better/more efficient way to do this.


Does anyone have any thoughts or suggestions?


Thank you!