+ Reply to Thread
Results 1 to 3 of 3

Automatic changing of row number with input

  1. #1
    Registered User
    Join Date
    09-21-2019
    Location
    Canada
    MS-Off Ver
    16.29.1
    Posts
    2

    Exclamation Automatic changing of row number with input

    Hello,

    I am struggling to figure out how to have the number of rows in my table change with respect to the value I enter in a random cell.

    For example, if I enter '4' in this random cell, I want my table to produce 4 rows. Lets say I change that value to '7', my table will change to have 7 rows. Is this possible? How can I do this?

    Please help!

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,582

    Re: Automatic changing of row number with input

    Pl upload a sample file
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    09-21-2019
    Location
    Canada
    MS-Off Ver
    16.29.1
    Posts
    2

    Re: Automatic changing of row number with input

    please see attachments for sample

    thanks
    Attached Files Attached Files

+ 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. Changing data input number from (123) 456-7890 to 123-456-7890
    By Explorer Group in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-17-2017, 12:15 PM
  2. Changing value of a cell based on number input in another
    By mrmatt81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2015, 11:53 AM
  3. Automatic dividing of a changing number
    By Dev89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2014, 10:08 AM
  4. Automatic Formula Input Based on User Input Using a Macro
    By Drayloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 12:10 PM
  5. Automatic tracking number input using barcode input...
    By garyk76 in forum Excel General
    Replies: 0
    Last Post: 12-09-2011, 11:15 AM
  6. Automatic "Bold" or color changing a number?
    By rajivvyas in forum Excel General
    Replies: 4
    Last Post: 08-14-2007, 11:53 AM
  7. Changing number of input boxes???
    By srroduin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2006, 10:50 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