This is multi-stage project. On the Stage 1 I need to Create a pricing spreadsheet template with 3 tabs.
Tab1 will be a summary tab that will pull out some key-field values from Tab 2.
Tab2 will be data-entry sheet (about 100 lines) with some basic formulas/lookups.
Tab3 will have some static data (about 100 lines) used for calculations/looksups in Tab2.
Users should be allowed to enter data only in specific fields on Tab2 and Print/Email Summary Report from Tab1. Admin will be allowed to edit data in Tab3.
Fields in Tabs 1 and 2 will need to have extensive formatting to make them user friendly and to protect from accidental deleting/modifying by Users.
Would like to use Google Spreadsheets if possible. The spreadsheet should be easy to add/modify by admin.
I'm looking for help with the first stage right now. The info below is just to give you an idea what is the next stage will be.
Stage 2. Add about 6 more Tabs (much smaller than Tab2, 20-50 lines). Convert this spreadsheet to dynamic web-based application.
Stage 3. Continue adding more functionalities and updating the existing ones.
24 freelancers are bidding on average $118 for this job
I am experienced VBA coder with long years experience. I can create also advanced V/H lookup functions and all necessary configurations listed in the request.