Simple Excel Consolidating Data

Web, Mobile & Software Dev Desktop Software Development Posted 3 years ago


Hours to be determined
Less than 1 week

Expert Level

Start Date

July 30, 2013


I have a workbook with 13 individual spreadsheets for each week of a quarter.  The file layout of each weekly spreadsheet is the same.  Each week the user will enter a doctor's name and the activities they will do for the week with a particular doctor (i.e. office visit, distribute literature, etc.).  Each week may have a different doctor in each weekly spreadsheet.  I need a summary page that will consolidate the data collected from each doctor each week and summarized the totals.

I don't think this is a complicated job in Excel but I'm not a programmer and don't write VB codes.  I'm hoping that this can be done in an hour or so and I need this to be done asap.  I'm hoping you can help me.

Open Attachment

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

About the Client

(4.41) 5 reviews

United States
Redwood City 05:18 PM

20 Jobs Posted
45% Hire Rate, 1 Open Job

$997 Total Spent
9 Hires, 1 Active

$16.37/hr Avg Hourly Rate Paid
9 Hours

Member Since Jul 28, 2013