hey i have a problem.. my stock list and my invoice are in the same workbook. i have made the base for my invoice with vlookup and data validation. the problem is.. if i enter product names and make a bill i cant save it cos if do i cant use it next time.. at the same time i have the inventory update thing and the profit/ loss calculations going on in another worksheet in the same workbook that takes its input from the billing sheet. everything is working now as it should but will work for one time only. i want a permanent invoice form with its formulas intact irrespective of what i do to it or whatever the best workaround there is for this problem. pardon me for the noobish terminology. thank you.