I'm looking for something specific and I couldn't find it on your web site. I apologize in advance if it was there.
Here's what I'm looking for :
My company is selling different product at a small business volume. What we're looking for is some fuction to add to our excel template we use to do quote and invoice.
Our template is very basic : Quantity, description, unit price & total. In the description column, we have created a list of 150 items available in all cells for that column. Of course, each item has a selling price. We would like to be able to choose any item in the list, and then, its price appears automatically in the next cell (unit price column).
We would like to be able to edit that list and pricing.
I would also like to have a button available... a button called PRINT PROJECT... when I will press that button, a menu will pop up to ask me which sheet from my spreadsheet I want to print (DÉTAILS TECHNIQUES, QUESTIONS, SOUMISSION 1, BON DE LIVRAISON, TEMPS ET TRSP...).
I will upload a file.... go to sheet SOUMISSION 1... you'll see a list of items. This list is from B251 to B343. You'll see unit price beside each item.
I'm sorry for my english.... I'm a french canadian who never have the chance to practice his english speaking (and writing!).
32 freelancers are bidding on average $162 for this job
Am an expert in VBA, visual basic for applications, and that what you need (Coding in excel). Have understood your requirement. Will deliver you timely. regards
semi-automatic form filling + autocalculate; values from editable separate sheet; print form for sheet printing, it will be done for 5 days, 174$; feel free to contact me if needed
I have already done this type of project earlier which was very much vast than this project. so you can be assured about the accurate output if you hand over me this task.