Need to append Excel data from daily email attachment into a single Excel sheet in Sharepoint
Each morning, I receive an email with an Excel attachment that includes our sales data for the previous day. There is only 1 tab. The email always has the same number of columns, with headers, but there are a dynamic number of rows. I manually open the Excel attachment, and copy all of the data - excluding the header row - and then paste those results into an Excel sheet in Sharepoint. This provides me a running total for historical reporting. How can I go about automating this process so when the email is received, the data within the attachment is automatically appended to the central sheet in Sharepoint? Thanks for your time!