+ Reply to Thread
Results 1 to 2 of 2

Autopopulate multiple columns based on dropdown selection in far left column

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Trinity, Texas
    MS-Off Ver
    Excel 2013
    Posts
    5

    Unhappy Autopopulate multiple columns based on dropdown selection in far left column

    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!
    Attached Files Attached Files

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Autopopulate multiple columns based on dropdown selection in far left column

    Hi tina

    Please include in your Sample File what a completed "typical" Estimate Form will look like.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-03-2013, 10:50 AM
  2. Autopopulate rows based on contingencies in multiple columns
    By sir stoffer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 09:29 AM
  3. Replies: 3
    Last Post: 01-22-2013, 01:13 AM
  4. [SOLVED] Relative Selection based on column to the left
    By Shawn Michaels in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2012, 12:12 PM
  5. Return Multiple Values Based On Dropdown List Selection
    By tigabalm in forum Excel General
    Replies: 5
    Last Post: 04-01-2010, 07:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1