We are trying to make a dynamic calculation on our "Bid Sheet". The Bid Sheet should be where the calculations final output will be. The "Products/Services" and "Rates" sheets are for reference for the calculations.
We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Services" sheet and “Rates” sheet and fill in the price each and labor hours for the appropriate drop down item.
In the examples given (A4 through F4) we were only able to hard code the calculations. We need them to be dynamic so that when any combination of “item” and “model” is selected the correct price and labor hours from the Products/Services and Rates sheets show for the selections.
We plan to manage the labor hours on the Rates sheet so if we need to change the labor rate calculation, we want to do so by only changing the value on the “Rates” sheet.
We plan to manage the Products/Services costs on the "Products/Services” sheet, we want to do so by only changing the value on the "Products/Services” sheet.
If you do not understand my explanation, please let me know, I would be happy to clarify.
I graduated from Penn State's honors college with a degree in finance. I have worked in both asset management and investment banking. My Excel skills are extensive. I know how to use all functions and tools and know basic VBA coding. I think I would be the ideal candidate for this project. I could accomplish it in just a few minutes.
$12 USD in 0 day
5.0 (4 reviews)
3.6
3.6
5 freelancers are bidding on average $19 USD for this job
My Dear
I'm read you job description carefully, you problems:
1- you drop down list should be depend on to gather item and models.
2- when you select item and model not get all values in price and labor hours correctly.
3- when you copy the total price is not calculation correctly.
Mu solution are:
1- correct the drop down list to be select item and model no return right value in price and labor hours.
2- solve the problem when copy the total price for each one in the column.
With My Regards.