Hello,
I am trying to build a spreadsheet that will track quotes we are receiving. The purpose is to track the time it takes from inquiry to quote. I'm hoping to take as much manual entry as possible (multiple time stamps?) I'm thinking it would be possible to use the time stamp feature with a vba code, ex. once an entry is made for a part number, it automatically stamps the time in a column for "Inquiry delivered", and then when a quote is sent back the user would input into another column for what was quoted, and it would stamp the time in a "Quote Received" column. From here I'm sure it would be easy to have another column to calculate the time it took with basic functions. Any ideas?