I have an invoice spreadsheet template that I am trying to make more user friendly. I attached it and explain what I need below:
The areas I need work on is in A23:A35 and D:23:D35. If you look at A23:A35, this area is to list the different contractors that were used on the job. Sometimes I will be invoicing for 1 person, sometimes 3 of them, and sometimes all of them… then I enter their rate into column D.
So this is what I need:
To be able to type their name or select it from a drop box, and then column D would automatically update with that contractors rate. I am assuming you will have to create a sort list or database, so I need to know how to access that database or sort list and how to add contractors, change rate, etc.
Bonus: If you could make the invoice generate an invoice # for every new invoice created. Let me know if your bid includes this or not.
This needs to be spreadsheet template based and I use OpenOffice.org, not Excel, although I believe they are pretty much the same.
Thanks!
