+ Reply to Thread
Results 1 to 3 of 3

Drop down questions

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    1

    Drop down questions

    I created a drop down in a file that contains a list of locations. The people that run these locations have to input data (mileage) in other areas of the worksheet. Is it possible to have the data in the cells change as someone changes the location in the drop down so the information is not lost or overwritten each time?
    I am really trying to avoid making a workbook with several tabs.

    The cells that are colored blue are the cells that the people will have to put input into. I would like to be able to keep the data from all the cells that are blue each time they change the location. The rest of them are already set to change with the location change via a formula. Those are all based on data that I pulled and was able to provide.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Drop down questions

    Please don't post password protected sample workbooks.
    Ben Van Johnson

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Drop down questions

    Use a userform for the input.

    Take a look here for more explanation
    http://www.snb-vba.eu/VBA_Userform_in_database_en.html
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. Drop Down Questions
    By zachyllana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 08:07 AM
  2. [SOLVED] drop-down list data validation questions
    By Compusafe in forum Excel General
    Replies: 2
    Last Post: 07-30-2012, 10:53 PM
  3. Drop down boxes triggering specific questions
    By Claires in forum Excel General
    Replies: 2
    Last Post: 09-22-2011, 02:13 PM
  4. questions on drop down list
    By redf1re in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 09:13 AM
  5. 3 questions: drop downs and comments
    By Wayne Knazek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2006, 09:45 AM

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