In Progress

Write a program to automatically summarize monthly reports

We are a long term care company that provides inpatient care to the elderly in nursing home and assisted living settings. Each month for marketing purposes, we track referrals we receive from local hospitals and inquiries from the local community. We have several Excel worksheets we use to track this information. One spreadsheet acts as the master list and contains all of the data for the other spreadsheets. Right now, we are manually taking data from the master spreadsheets and re-typing it in the appropriate area on the other spreadsheets. I would like a program or Excel macro written that will allow us to only enter the information once (on the master spreadhseet) and have it automatically transferred to the other spreadsheets. If you open the attached files, you will see an exmaple. The "Inquiry Tracking Worksheet" is the master sheet in which we type all of the necessary information. The "Marketing Reports" file contains several worksheets (tabs) for the different reports. When you compare the two, you will see all the information contained on each tab in the "Marketing Reports" file is taken directly from the "Inquiry Tracking Worksheet." Please look at information specifically for October 2009. Let me know if this is possible.

Skills: Data Processing, Excel

See more: summarize program, excel macro summarize reports, macro summarize monthly data, write home, marketing home write, let write, month spreadsheet, excel compare two worksheets, write typing, write re, summarize, marketing reports, inquiry, excel reports, compare spreadsheet, automatically, excel sheet summarize, spreadsheet tracking, write macro, please worksheet attached, excel macro program, type program, data program excel, write file excel, look excel program

About the Employer:
( 0 reviews ) North Ridgeville, United States

Project ID: #557580

Awarded to:

ExcelGurus

Hello, Please take a look at your PMB. Thank you, David

$220 USD in 4 days
(8 Reviews)
4.7

102 freelancers are bidding on average $122 for this job

nagybatonyi

This job can be nicely completed with Excel macros, please, see PMB for details! Regards!

$100 USD in 2 days
(43 Reviews)
5.6
mrbrave

Excel expert here.

$120 USD in 5 days
(76 Reviews)
5.4
vbexcel

Please refer to PMB

$60 USD in 1 day
(25 Reviews)
5.3
binaryromel

Sir, please check PM. Thanks

$60 USD in 1 day
(44 Reviews)
5.1
djucuti

I have 10 years of experience in VBA with Excel, Access, Word.

$70 USD in 3 days
(6 Reviews)
3.7
excelsolution

Hi I work exclusively on MS Office Automation projects using Excel/VBA. I have gone through the requirements and will be able to automate the generation of three monthly reports required. I will also make the reports l More

$150 USD in 6 days
(21 Reviews)
3.6
d2imatrix

Hi, It will be great opportunity to work on this project. Please see messege board.

$100 USD in 3 days
(1 Review)
3.2
shimuliak

Dear sir, I'm interested in this project all of your terms & conditions. I'm confident to perfect delivery about this project. Thanks & regards SHIMUL

$45 USD in 5 days
(8 Reviews)
3.2
frehmanpk

Please Check PMB for details.

$30 USD in 1 day
(5 Reviews)
2.5
mteknight

Please refer to PM for details.

$100 USD in 10 days
(1 Review)
2.2
subhadippal

Hi I have experience in developing excel(vba macro and userform ) based solutions.It would be my pleasure to give solution to this problem. It will take a few hours.but I have posted more time to make it a User Friendl More

$30 USD in 3 days
(2 Reviews)
1.5
MariaMK

I used to work in the investment banking industry in London and performed similar tasks successfully. Rest assured that the job can be done both quickly and efficiently. Regards, Marija

$100 USD in 1 day
(1 Review)
1.4
pareekravi

Hi - this looks to be an exciting project. Please check your inbox

$70 USD in 7 days
(1 Review)
1.0
SLPrintCenter

I WILL DO THIS FOR FREE! Please see PM

$30 USD in 1 day
(2 Reviews)
1.0
nurontech

Hi, This can be easily done. Ready to start anytime...

$75 USD in 5 days
(0 Reviews)
0.0
timothyescopete

I am honest, reliable and trustworthy. I have enough knowledge on this project and willing to start right away. I worked as a Managing Editor of one of the publication here in the city which is in charged of all of t More

$50 USD in 1 day
(0 Reviews)
0.0
mhargrov

This project can be done with a somewhat simple macro. Even if you don't choose me, I would not select anyone who would price this under $100. It will take 4-5 hours and anyone who doesn't charge at least $20/hour pr More

$100 USD in 2 days
(0 Reviews)
0.0
cholland3403

I have done many projects like this in the past. I will have a solution that will work very well for you.

$30 USD in 2 days
(0 Reviews)
0.0
MajaWL

Please see inbox for details. Regards

$70 USD in 1 day
(0 Reviews)
0.0
davidcking

Hello, I am probably not your garden variety "freelancer". I am in between jobs - prior role in as a Market Analyst for a large manufacturer. In this capacity I frequently performed tasks such as that which you ha More

$125 USD in 2 days
(0 Reviews)
0.0