We need an excel spread sheet with a drop down menu to switch between 2 manufactures that we use. We want to be able to choose one manufacturer or the other and then the sheet populates the information and terms for that particular manufacturer and contract. We have financing contracts that go with them and is different for each state (5 states), so we would need a drop down box to also choose which state the customer is in so it will populate the correct terms per that state.
It will need to calculate tax, and financing options - which the financing rate changes on the term picked from a drop down (36, 48 or 60mo). The sheets are made but not functioning well - One of the financing contracts sheets was just converted into excel by an adobe image and it needs to be fixed and formulas put in...we need some drop down boxes made for options on our product.
I would like to combine all of them for ease of use.
Is this possible?
I have attached a screen shot of one main contract page and the first page of one of the rental/financing sheets just for basic reference and have blotted out our address info. Thanks!
p.s. I would have more product contract sheets to modify if this first one goes well!!!
28 freelancer đang chào giá trung bình $109 cho công việc này
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hi, I can build the excel tools that you need, with drop-down menus to select manufacturer and state and the file will automatically fill with the right data according with your selection. Best regards, Florin Enache
Hi, I check your project description.I can do it now. I can start to work in your project [login to view URL] you please pm and share me the plateform Details? Thanks
Hello. I have done very similar task: https://www.freelancer.com.ru/projects/excel/Excel-task-drop-down-menu/details I will help you resolve problems and complete this tool
I have read through your job posting and I believe my set of skills makes me the best person for the job. I hope to deliver accurately and in good time a well completed job. Message me to get the job started
I have just completed your excel demo that has a drop down to control, Rental term, State, and Manufacturer. If you provide state, tax, and text of terms and conditions, I can provide working Rev 1 this afternoon.