...manage a building business and have developed an excel based job costing workbook with multiple spreadsheets. Each spreadsheet represents a job and all spreadsheets are referenced to a summary spreadsheet to sum up all jobs in progress including payments received. I would like to automate the workbook so that i can automatically add new spreadsheets
...coordinates of the antenna locations are entered in cells D9-I9 and D10-I10. Only cells that can accept input can be modified, which are highlighted in yellow. The rest of the workbook is protected to avoid unintended modifications that could result in erroneous calculations. Some cells that calculate intermediate values are not displayed unless these cells
...looking to develop an online application for a Cost-Benefit calculating tool. The tool and all calculations have already been created in Microsoft Excel workbook. Our current tool has been created in Excel using protected worksheets and navigation via form control buttons. This project would essentially be taking the existing tool and putting it into
I have a workbook that I manually import data from an external database. The data goes onto a master sheet, then is transferred to individual sheets by date. I want to use formulas in the mastersheet to copy and sort the data into the appropriate cells on the daily sheets. (sort by date to get the data onto the correct sheet, then copy to the range
You want to design a simple web based net worth calculator for people to use. You have a mockup in a spreadsheet - see the Net Worth Tracker tab in this workbook. You will track assets and liabilities only. For your proof of concept, you will populate the rows in the tables by default, the user will not be able to add or remove rows. The client
You want to design a simple web based net worth calculator for people to use. You have a mockup in a spreadsheet - see the Net Worth Tracker tab in this workbook. You will track assets and liabilities only. For your proof of concept, you will populate the rows in the tables by default, the user will not be able to add or remove rows. The client web
NU 576 Excel Workbook Exercise The purpose of this exercise is to familiarize you with the effective use of Excel as a tool to manage finances and numbers. You are to create an Excel worksheet that demonstrates a staffing plan with salary information for a small hospital unit. The Unit is staffed in three 8 hour shifts. There is 1 nurse manager who
Create 2 macro based on described rules. See more info in the attached workbook. Please check the sample1 and sample2 worksheets.
I want built a workbook (VBA) whereby I am able to distinguish between various products and departments for a automotive retail dealership group for sales and gross profit downloaded from a transaction listing per month from 2014 onwards. Must be able to incorporate numerous account numbers per model (minimum 5) or sales category say Toyota Corolla
...Person who is strong in EXCEL MACRO. Make presentation automatically with specified format presentation from Excel workbook. Input : 1) Presentation Template 2) 2 Excel Sheet Output : Macro - Should create automatically presentation Chart and test from the 2 Excel sheet. I will give 1 presentation and 2 Excell file workbook. Macro Should create same
I have a very complicated workbook designed by someone else, who is not available anymore. Unfortunately one of my formula's is not working and will have to be figured out what it did and now how to fix it. I think this is about 2-3 hours work.
I just wrote my very first workbook to support my clients on their 21 day journey. Every one of the Day (21) has 3 pages - design elements repeat every day (the third page is identical on each day) There are also additional 10 text pages. This program starts in December so I need it completed in 5 days.
I am a project manager and have an excel workbook that lets me plan how project resources (people) will be utilised across lots of different projects at any point in time. Basically, you list a set of people who are available to work on projects by name and job type. You then allocate people by job type to your individual projects and state how
Hi all, We are looking to setup a simp...So here we are, going to try again. I will be taking my time sorting the right people out for this job. Start simple, & weed-out weakness in the site. I have attached a excel workbook. It contains items listing headers and what we want to collect as info from customer for sales & communication. regards 3net
I would like to create a wellness diary organized on 52 calendaristic weeks,I will need illustration and graphi...the style is classical and impressionistic , modern with refined elements of illustration- style is elaborated and colors combine in harmonic and complementary ways; this workbook encourages the reader into adopting healthy lifestyle ;
...Redskins *Not all data may be available so please ask for clarifications and confirmations on any missing data - The data for each team should be delivered in a separate Excel workbook as shown in my example attached. Please be patient as the tool can take some time. Please do *not* delete anything within the tool! This video should explain the