Ahhhh okay so this is so complicated, but I will try my best to explain it. I am trying to help the new company I work for with their forms and there are several people in the office who either a) do not even know how to turn a computer on or b) Say, "Excel WHAT?" They literally type up everything in a Word document and print it and write everything in. So, I am trying to create an estimate form and I want each of the services that we provide to be in a drop down list in the first column of a table and then depending on which service is chosen, I want the rest of the cells to auto populate various information, additional criteria needed, and different formatting--- based strictly on that service we provide. The reason for this is because the person who will be doing most of this data entry is the one person who does not even know how to turn on a computer. I want to edit the total lines to automatically calculate themselves based on our pricing structure for each service. I have attached an example. I hope I am making sense. It seems so simple, but I cannot seem to figure it out. I have tried everything and the owner of the company is irritated that it is taking me so long (even though I am literally trying to make a form that will almost completely fill itself out and save so much time and substantially reduce the amount of errors that are being made by still using a darn calculator! UGHHH, please help me!
Bookmarks