Looking for an experienced excel professional to help me build a budget sheet that allows the input of expenses (time & material) as they are incurred and compare against the budgeted numbers.
I would also like to build a couple customer facing sheets (bill of materials, quote, etc.) that are automatically populated with data entered into the original estimation sheet, like part descriptions, part numbers, etc.
The sample file shows three sheets, estimation, product data base and budget. I've already created something that does the math, but it's tied to this particular spreadsheet and I'm not able to create others using this form.
Currently, the "product data base" is not working as expected and I'm basically cutting/pasting data from there to the estimation sheet. I'm okay with this, but need to remove the formulas that a previous Excel guy created.