I need someone to make an Excel spreadsheet that helps me keep track of job costs (construction industry) The front page needs to be set up with a list of items/trades (Concrete/Carpentry/Plumbing etc) This page will have, for each trade, average costs, highest cost, lowest cost, square meter rates. The next pages will be set up with the same list of items/trades etc but will be job specific. This means that when quantities are entered into the job specific pages the first page is automatic updated with the averages and so on. I will need to add pages (using the tabs at the bottom) for each new job. I have attached a very simple example of what I am after. as you will see I have a very limited knowledge of Excel. you can use my spreadsheet as a starting point or you can completely start over. Open to any suggestions or ideas you may have.
VB / VBA professional with +15 of programming experience. Please check my PM. Could be helpful if you could submit a file for analysis. Thanks once more.