+ Reply to Thread
Results 1 to 3 of 3

How do I extend the inputs to match the table

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    How do I extend the inputs to match the table

    Hey Guys

    I found this neat Data Entry form as a free download BUT I need your help extending the Input table in the Input sheet ( Cells A12:D12) to match the extended table in The parts data sheet.

    Can someone please help me to do this and tell me how to do it so I can extend it as my data base grows

    Thank you Guys.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2019 and 365
    Posts
    135

    Re: How do I extend the inputs to match the table

    You need to begin by looking at the Name Manager under the formulas tab. There you can EDIT the various ranges that may help you achieve your goals.
    ***Warning, make sure you create a backup copy of your workbook before making these changes. If you are not familiar with the Name Manager, you easily mess up.

  3. #3
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242
    Cheers Dentler, I will look at it when the wife gives me back the computer after her net flix videos. 😆

    Quote Originally Posted by dentler View Post
    You need to begin by looking at the Name Manager under the formulas tab. There you can EDIT the various ranges that may help you achieve your goals.
    ***Warning, make sure you create a backup copy of your workbook before making these changes. If you are not familiar with the Name Manager, you easily mess up.

+ 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. [SOLVED] Extend currnt table whilst keeping the Formula (Create a live league table)
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2018, 02:11 PM
  2. Replies: 6
    Last Post: 12-01-2017, 03:45 PM
  3. Auto Extend Table linked with another table
    By azmat119 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2017, 03:51 PM
  4. Auto Extend Table linked with another table
    By azmat119 in forum Excel General
    Replies: 1
    Last Post: 02-09-2017, 02:35 PM
  5. Auto Extend Table linked with another table
    By azmat119 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-09-2017, 06:37 AM
  6. Match inputs in one column with data from another if >50% of their consec letters match
    By TaskinRahman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2012, 01:47 AM
  7. extend index/match
    By want2learn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2011, 01:46 PM

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