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.
102 freelancers are bidding on average $122 for this job
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