I have never used excel this way, and it may not be possible, but i used to work in quickbooks to create a job proposal/estimate.
the great thing was you could prewrite a description of about 50 items that made up 90% of my transactions, so with a 3 digit code i entered a long piece of writing.
the company i work for now does not use quickbooks, but we all have office, so i am wondering is there a way to have these pre-written text boxes so that when i enter, say "AWS22" it puts this copy in the cell: "Single Hung Aluminum Equal Lite White Frame Clear Impact Laminated Glass 26.00 x 26.00 $ 436.00" and then i can set up the next cell to know to multiply the quantity enter times the $436.00?
it seems like something excel can do, but i have no idea where to start.
thanks
Bookmarks