I'm not even sure where to start. I think this isn't all that tough to do I just don't think I can get it done without a lot of headaches so I'm reaching out. I'm looking for a suggestion and the ability for you to modify my current spreadsheet to work the way I envision it.
Here's what I have now. Our website [url removed, login to view] offers a spreadsheet to members that uses a macro to customize player rankings based on projected stats that are stored on several worksheets within the workbook. I then update the spreadsheet projections daily and then members must download the newest version to get the updates.
What I what is for my members, with their local spreadsheet saved to their home computer to be able to click a button to get the latest projections. This will then get the latest data for the stat projection worksheets from my main, master copy or this data stored somewhere (table on web, access db on a server, MySQL on my webhost, ???) remotely.
So - what is the best way to accomplish this that is easy for my members (click button in spreadsheet to get latest projections) and is easy for me updating the data on the master - easy export to XML file and upload, just save the excel file, export to MySQL, export to Access. Whatever is easy for me that remains secure and easy to access for my users will win the bid! I will then need you to modify the spreadsheet so I can provide my users with a version with the aforementioned update data button rather than the updated master as I currently provide.
Follow all that......?
Please e-mail with any questions.