I work on a business analytics team which finds itself having to send out various spreadsheets in Excel asking for input from the field regional managers. The spreadsheets themselves are typically hundreds of lines long representing data points from each region that need to be broken out prior to being emailed to each individual regional manager for their input. What we’re looking for is a tailored solution that allows us to keep this entire process closed looped without resorting to breaking apart, emailing, aggregating responses etc… Please note, these spreadsheets when broken apart contain exactly the same number of columns per region however the rows will vary because every region will have it’s own set of x (eg. customers). We’re looking for a fully automated solution that will be able to break these sheets apart based on the change in column x, send them out to the appropriate regional managers (their email addresses would be in another column) for their responses (inputs to cells in the spreadsheet), remind them if they haven’t responded in x number of days, aggregate all of the input rows back into a master spreadsheet that we can then access for further analysis. In a nutshell that’s the process we’re looking to automate. If you have any further questions or need additional clarity on the use case, feel free to reach out. Open to hiring an expert for a short term project provided we agree on terms, deliverables etc...
Alex
