Manipulate a set of spreadsheets - Create a roll up master spreadsheet with aggregate data

Background: We have approximately 60 separate excel files that contain approximately 50 tabs each. Each tab contains the same columns but different row data. Some files contain similar row data but not identical. The data relates to retail locations and the price of a product on a given date. Each tab on the file is a different state within the USA.

The Desire/Intended Outcome:

• Have a place/tab that calculates the past trend data for each row, on each tab, to allow us to see the median and mean price that was offered for this product, at each ‘location’ over the history of our data. Have the same data calculate the median and mean pricing over the most recent 12 weeks of data, the most recent 26 weeks of data, and the most recent 52 weeks of data.

• Add data each week when new pricing comes out, and have that data ‘recalculate’ the mean and median pricing trend as listed above. Some simple method to paste or merge files to allow the new data to be imported into the master spreadsheet that contains the calculations and graphs.

• Have a line graph that shows the past 12 months of pricing data for any location, by clicking that location from a drop down to allow for the line graph to be displayed, and then printed.

• A version that allows us to print on one page the 12,26, and 52 week data trends for any one location.

All of this should be done in Excel, not in another program. We should be able to drop in/paste in the latest weeks data to allow for the data to update

A sample version of one of the 60 spreadsheet files is attached. Please see all of the tabs on the sample file.

Taidot: tietojenkäsittely, Excel, Excel Macros, Excel VBA

Näytä lisää: merge excel worksheets into one master worksheet, copy data from multiple worksheets into one vba, combine multiple excel sheets into one sheet, how to pull data from multiple worksheets in excel, macro to pull data from multiple excel sheets, consolidate data from multiple worksheets in a single worksheet vba, how to copy data from multiple sheets to one sheet in excel, combine multiple worksheets into one using vba, create spreadsheet website data, create letter excel spreadsheet, create form excel spreadsheet, create roll online, tutorial create intranet master page sharepoint, create roll menu flash, create quality master page website aspnet, create time management spreadsheet, create web master tool script dns, create sharepoint master template, vbnet set folder create date, create css master page aspnet

Tietoa työnantajasta:
( 2 arvostelua ) Fort Lauderdale, United States

Projektin tunnus: #17013533

Myönnetty käyttäjälle:


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Lisää

$250 USD 4 päivässä
(643 Arvostelua)

41 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi there..... Warm Greetings We came along with your request for Manipulate a set of spreadsheets and we reviewed your project description. We'd like to help you with confidence and satisfying results... We ha Lisää

$180 USD 3 päivässä
(293 arvostelua)

I love excel, and have done several projects to create summary sheets, like the way you want.. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work. Lisää

$250 USD 5 päivässä
(274 arvostelua)
$170 USD 1 päivässä
(254 arvostelua)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD 5 päivässä
(281 arvostelua)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$200 USD 5 päivässä
(212 arvostelua)

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un Lisää

$211 USD 7 päivässä
(182 arvostelua)

Hello Sir, i am Ajay from India without wasting our both time i want to work for your sample file for selection for this [login to view URL] allow me to start sampling .contact me anytime i am always here. Relevant Sk Lisää

$250 USD 3 päivässä
(182 arvostelua)

Hi there. My name is Daniel and I would be glad to help you out. I appreciate the details of the project description. I can guarantee an excellent job and deliver as soon as possible. Do you need this steps to run inde Lisää

$199 USD 3 päivässä
(96 arvostelua)

Greetings, I'm ready to work on roll up master spreadsheet with aggregate data project. Relevant Skills Excel, VBA Milestones 106 USD - project requirements done and delivered 106 USD - last milestone after full ch Lisää

$213 USD 4 päivässä
(120 arvostelua)

A proposal has not yet been provided

$150 USD 5 päivässä
(124 arvostelua)

Hello there, I can try to optimise it. I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A

$250 USD 3 päivässä
(164 arvostelua)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$250 USD 5 päivässä
(75 arvostelua)

Hi, You won’t select the right candidate without knowing what your project on conducting data analysis in Excel based on your intended outcome will look like. Fortunately, I can complete a part of your job before you Lisää

$150 USD 3 päivässä
(40 arvostelua)

PM me for sample work on this project. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 Lisää

$170 USD 5 päivässä
(72 arvostelua)

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$200 USD 3 päivässä
(71 arvostelua)

Hi, I have checked details of your project and your requirements. So, you want a master excel file which will import data from all your 60+ files and from new files. Will do different calculations on them and will d Lisää

$155 USD 3 päivässä
(54 arvostelua)
$50 USD 1 päivässä
(43 arvostelua)

Hello I am available to help extract the relevant statistics from your Excel files. I am proficient in VBA and scripting with Python to provide the required data analysis and charts. I will provide a single point for Lisää

$166 USD 5 päivässä
(34 arvostelua)

HI, I went through your requirement, and understood that you are basically trying to consolidate your data, to a unified excel sheet, which you can slice n dice based on time-frames/location/master ID etc, besi Lisää

$500 USD 5 päivässä
(6 arvostelua)

Dear Sir, I have gone through the project requirements and willing to do it as per your requirements. I am an excel professional having hands on expertise in data analysis and management. I will do your project by d Lisää

$338 USD 5 päivässä
(12 arvostelua)