Need Advanced Excel skills to create a Multi Sheet Workbook

Spreadsheet Development

I need a spreadsheet designed to handle Contact Information for a small organization, (maximum 60 members). It will have two main aspects - One Section for Personal data such as Name, Company Name, Address, Phone, etc. And a second Section that will track Meeting activities such as attendance, referrals, fines, etc. This Section will need to make calculations of points for each member on a weekly basis and total those on an annual basis. Both these Sections will require the flexibility to add and remove members without disrupting the formulas. It requires a Form sheet that allows for the data entry of a new member, that will automatically populate the Personal Data section and the Meeting activities section respectively.

I will provide two spreadsheets with selected person only, that should give you a feel for what the end product should look like. The PBA Member List is pretty much complete as far as proper Columns, but the Form Fill sheet needs more work to make it properly fill the next available row and preferably auto re-sort the rows based on alpha order of the Classification column. As well as reset the Form for the next entry of a new member.

The PBA Meeting Notes sheet is relatively complete in that it properly reflects the Columns and basic math formulas for totaling weekly counts, but needs the following improvements. I need an easy way to automatically create a new sheet for each weekly meeting and date it (or pre-create 52 sheets if thats the only way it can be done). The totals sheet should always represent the current up to date totals of each column. Note Column I as needing to be developed with an appropriate formula(s). As stated earlier, we need to be able to add or delete a member without that creating a formulas problem.

If possible, all of the above would be combined into a single workbook using multiple sheets, but not necessarily mandatory. Cost will be a consideration so I am open to consider different alternatives on how the above requirements might be accomplished.

My time frame for completion is flexible so the job need not be done on a rush basis.
About the recuiter
Member since May 20, 2018
Andy Hidayat
from Virginia, United States

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions