Excel Data Consolidation and Summary

Part 1

The goal is to track all projects (Column A) that have been updated weekly, based on the “project modified date” in Column D. Each week the range will change. For this current file assume the range starts from Saturday February 23 through March 1st (Fiscal Week 9).

Consolidate totals by project name prefix: CO, GA, HI, MAS, National, NCAL, NW, OH, SCAL, CD, CS, HP, OR, TPMO, Wrapper

Please use a separate tab to show the results summary by prefix

Part 2

I would like to see the results mapped to the PPT file, so that the data that is captured in the results tab, automatically updates the “current” data in the PPT file.

Note: Attached is a copy of a similar Excel file and PowerPoint as a guide although, the data being displayed is different.

Taidot: tietojenkäsittely, Excel

Näytä lisää: excel data consolidation, excel consolidation, data consolidation excel, track 1 data, data processing co, summary, NW, fiscal, data consolidate, excel modified, excel summary results, consolidation excel, excel column copy, tab data, march 2013, february 2013, wrapper powerpoint, excel consolidate, project project summary, consolidate excel, excel summary raw data, consolidate data excel, separate excel, convert summary data raw data excel, summary data raw data excel

Tietoa työnantajasta:
( 4 arvostelua ) Valencia, United States

Projektin tunnus: #4302468

Myönnetty käyttäjälle:


Excel/VBA Expert

$60 USD 3 päivässä
(10 Arvostelua)

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


Good day! After reading the project description, im confident that i can do this job. I hope you will consider me for this job and i can start immediately. Top data entry provider Lisää

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

we are excel expert we can start ur work immediately

$75 USD 1 päivässä
(14 arvostelua)

Hi... I would like to apply for the job.

$60 USD 3 päivässä
(5 arvostelua)

Hello, I can help [login to view URL]

$100 USD 3 päivässä
(7 arvostelua)