I am looking to make this a Quotation that will be able to be sent to our customers. There are (2) sheets within this workbook. Sheet 1 is a basic layout and sheet 2 has the data to be inserted (item number, description and pricing).
What I would like is when I enter the item number, the description will populate automatically. Also, depending on what pricing schedule I have my customer at, I would like that to populate as well (you will see on sheet 2 there are columns A, B and C pricing).
If pictures are able to populate with the item, that would be great!
I have entered data on one of the lines just to show an example. Feel free to improve on what we have as it is VERY basic right now.
38 freelancers are bidding on average $33 for this job
I am an Excel expert and pay attention to details. I can create a template to quickly prepare professional looking quotations. Please consider me for accurate work.
Hi I would lek to work on your project. I have seen your project requirement and feel I can definitively help you out in this as I am well versed with excel. Looking forward to hear from you. Thanks.
hello, I'd offer you a better solution, I can develop a C# application that manage all you needs, data lookup, data storage and any other features that you may think about at a later time.
Hi, This can be done using a simple macro, although the pictures wont be there. If you want we can discuss this further and try and improve it more. Regards, Vishal