I have designed a quote system, on one worksheet is the customer database, on the next is a qoute page it uses vlookups, blar blar, to save the system I recorded a macro that copys the quote to a new work book, and save it as the customers reference number. I would then like the macro to put a date next to the customers details in the customer database, and have a cell next to it that lets you know when the qoute is out of date(30 days).
If possible I would like a hyperlink to be placed next to the customers details so you can click it and open their quote???? And if possible I need an answer in 3days, HELP!!