Simple Excel Consolidating Data

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

Hourly Job

Hours to be determined
Less than 1 week

Expert Level

I am willing to pay higher rates for the most experienced freelancers


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:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 16

Hired: 1

About the Client

(4.41) 5 reviews

United States
Redwood City 05:54 PM

19 Jobs Posted
48% 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