+ Reply to Thread
Results 1 to 4 of 4

Botton with multiple text entries and a list option that adds data to bottom of table

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    Botton with multiple text entries and a list option that adds data to bottom of table

    I would like to create a button with two text and a drop down option that automatically adds data to the bottom of a table. I want the student name and group to be a text entry but I want the student grade to be taken from a list. As you can see in the sheet, I did the data validation route but I would like for the table to be infinite. I think a button would look better so that people won't have to keep scrolling down in the future. This is a sample data and the actual data has hundreds of students. I'd appreciate any help with this. Thanks.
    Attached Files Attached Files
    Last edited by planjb; 08-03-2020 at 08:04 AM.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Botton with multiple text entries and a list option that adds data to bottom of table

    I just set up a data validation table in cells I1:I6 and linked that to cell F7 then used this macro

    Please Login or Register  to view this content.
    see example attached
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

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

    Re: Botton with multiple text entries and a list option that adds data to bottom of table

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    07-21-2020
    Location
    Washington, DC
    MS-Off Ver
    365
    Posts
    20

    Re: Botton with multiple text entries and a list option that adds data to bottom of table

    Both solutions work! Thank you to you both!

+ 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. List of unique dates with multiple text entries
    By gak67 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2015, 05:46 PM
  2. [SOLVED] option button with next available row that adds on to a cell which already contains text
    By mackenzie.costello in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2015, 12:32 PM
  3. Replies: 4
    Last Post: 01-18-2015, 04:52 PM
  4. Replies: 1
    Last Post: 10-26-2014, 07:54 AM
  5. Replies: 4
    Last Post: 01-31-2014, 06:22 AM
  6. Text entries into data table?
    By Musical in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 11-01-2011, 10:15 PM
  7. Replies: 1
    Last Post: 03-16-2007, 03:45 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