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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how to protect cells in excel sheet
- Thread starter enxocoebl
- Start date
is it impossible???
should i make a separate workbook for the billing sheet?
it wud be great if the changes i make to the workbook get recorded without saving the changes... some kinda refresh button that automatically removes the contents of the last bill and show the original sheet.( the inventory update and the sales is calculated on a different sheet.. that still has to work).
please help me with this i am almost done.. thank you
should i make a separate workbook for the billing sheet?
it wud be great if the changes i make to the workbook get recorded without saving the changes... some kinda refresh button that automatically removes the contents of the last bill and show the original sheet.( the inventory update and the sales is calculated on a different sheet.. that still has to work).
please help me with this i am almost done.. thank you
Upvote
0
