I have a workbook the workbook has a Quotation Number cell which i need the user to enter the quote number and save the workbook as that quote number before being able to enter any other data in the workbook.
i use this for estimating on the first worksheet it has a category drop down box, a product description drop down box which is based on the category selection which in turn looks up values from a table and then populates the unit cell, price cell and labour cell.
What i would like to be able to do is change either the price or labour value or both without overwriting the lookup formula and before i move out of the cell a popup form comes up and says do you want to save changes to lookup table Yes or No. If yes it updates changes in lookup table. If No the value entered is saved to the open workbook .All this needs to happen without deleting the lookup formula in the price and labour cells.
I hope i have explained this clearly enough
3 freelance font une offre moyenne de $33 pour ce travail
Hello! Your task is easy enough! I can complete it pretty fast! I you will choose me, please contact me on: Skype: ID: florance1980 Yahoo Mess: sandescuflorin Thank you in advance!