Excel Spreadsheet Expert
Closed - This job posting has been filled.
I require someone to correct formulas within an already made excel spreadsheet (attached).
The Excel Spreadsheet will be designed to compare projected data to actual data that will be input throughout the year, i have tried to explain clearly what is required below.
-Green colored boxes information is to be pulled from the 'data' sheet.
-Purple colored boxes information is to be pulled from each months sheet (of which will be filled in throughout the year)
-Red colored boxes information is to be pulled from the 'data' sheet with a running total. (ie when march is used it would be calculated as =SUM(Data!B37:D37), and when November is selected it would show the calculation =SUM(Data!B37:L37)
-Blue colored boxes information is to be pulled from each month as a running total of which will be imputed every month and the cells may not be the same place (i can edit the formula every month for the blue boxes if needed. (for example when February is selected it would look like =SUM(January!B16+Febuary2!B16).