I have an excel spread sheet 1 LABELED (QUICK ESTIMATES), I built for quoting repair jobs. This sheet has information that I add on a periodic basis as I add more jobs to the mix. Sheet 1 (QUICK ESTIMATES), has the repair jobs. Sheet 2 (Customer Estimates) need to be an easy fill in based on the jobs on sheet 1.
I want to type in a number on my quoting sheet (sheet 2) and the quote sheet auto fills from information on sheet 1. I also need the ability to add more jobs to sheet 1, plus change globally change the parts prices by a percentage.
I also need to be able to see a summary sheet of all quotes. And open up old quotes. I need to close quotes and see open vs closed.
I am also open to suggestions.