Welp, I've signed on with a small business and have been thrown the operations hat, which includes IT work. Here's my problem currently:
Our parent company sends us an excel workbook (with 200 worksheets) everyday that we then have to sort through and shoot different worksheets to our clients. We have been using a macro to cut out the sheets that we want to new workbooks that we then e-mail to our clients each day. This is a very time-consuming process and frequently breaks because new worksheets are constantly being added.
We have a website with MySQL. I was wondering if it would be an easier process to upload workbooks each day and give the clients a password-protected link so that they can view the information that is pertinent for them. Is this possible? Is it difficult? Or do you guys have any other ideas?