Objective: Program must be able to automatically consolidate specific raw data by pulling it from the master sheet into columns that can refresh the range periodically in a template summary report(using a simple math algorithm). The template must be able to be used to analyze the summary dated to compare to a set data group(also in excel. Needs to be exported if possible to master summary
The overall purpose of this program is to cut the time it takes to organize and report sales statistics as a consulting firm. Reference sheet will ultimately be used to make purchase recommendations(contact me to see examples of the finished report compared to the raw data it was pulled from).
12 freelancers are bidding on average $192 for this job
Hey, Can you share your existing spreadsheet? I would be able to suggest a few options once I understand the 'As-Is' process. Please see my private message for more details. Thanks and Regards, Shikha
please send me samples I would like to try this or understand better the task seems straight forward but id like to see the samples. many thanks Gary Mcneish