+ Reply to Thread
Results 1 to 7 of 7

How to make a self expanding table?

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    Croatia
    MS-Off Ver
    2013
    Posts
    4

    How to make a self expanding table?

    Hello forum!

    I'm having a problem with making a table. As a novice in Excel I am wondering if it's possible to make a self expanding table.
    What I have is a sheet with a table with loads of biking tracks with track number, date, nr of miles and so on...
    I'd like to make a table on the second sheet so that I can see only the tracks that auto fill as I put in info about number of miles or date or track number.
    And I'd like it to auto expand so I don't have a lot of wasted space on the page. I'd like the TOTAL amount of miles, when i put in multiple tracks, to move up or down when I add or remove tracks...
    Sorry if I'm not clear about what I need... As I said I'm a novice and English is not my native language.

    Thank you

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: How to make a self expanding table?

    It may be possible, upload a sample file

  3. #3
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: How to make a self expanding table?

    To upload a file, click on "Go Advanced" button below and the tool for attachment pops up. Follow through and attach your file.

    Cheers
    Don't forget to rate 1 who helped u, using "Star"

  4. #4
    Registered User
    Join Date
    06-19-2014
    Location
    Croatia
    MS-Off Ver
    2013
    Posts
    4

    Re: How to make a self expanding table?

    Tracks - help.xlsx
    Hope this is it... :D

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: How to make a self expanding table?

    see the attached file
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-19-2014
    Location
    Croatia
    MS-Off Ver
    2013
    Posts
    4

    Re: How to make a self expanding table?

    Thank you very much. This is exactly what I needed

  7. #7
    Registered User
    Join Date
    06-19-2014
    Location
    Croatia
    MS-Off Ver
    2013
    Posts
    4

    Re: How to make a self expanding table?

    How do I make a third column in the 2nd sheet to also appear as the others do? I'd like to put in a km/h column
    btw the formula you put in there is still giving me headaches :D

+ 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] Table not auto-expanding
    By teenyjem in forum Excel General
    Replies: 3
    Last Post: 01-21-2014, 05:33 AM
  2. Expanding only one field in pivot table
    By geabarbic in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-09-2014, 04:40 AM
  3. How do I create an automatically expanding data table?
    By johnw993 in forum Excel General
    Replies: 2
    Last Post: 12-05-2012, 01:23 AM
  4. Expanding Pivot Table Range
    By john_london in forum Excel General
    Replies: 4
    Last Post: 05-03-2010, 02:49 PM
  5. Excel formula in an expanding table
    By Keady in forum Excel General
    Replies: 1
    Last Post: 07-30-2005, 01:05 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