I created an invoice in Excel and have some problems with it. No trouble making the formulas work but it requires the user to enter their name and some other information. I have locked cells so they can only go to the cells I want them to.
I have two problems, first, sometimes they forget to enter their name. I was told I could require an entry in that field with validation. I couldn't figure that out.
Each time the file is used, we save it because it has some numbers on it that we want to use next time. When opening the file again, I would like the name to be erased and force them to enter a name as it will be someone else.
Can any of this be done in Excel?
Tried to attach a copy but no success.
I want to create an invoice that makes entries mandatory that all required fields have valid entries before closing
Bookmarks