Results 1 to 6 of 6

Flexible amout of rows in a table?

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2020
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    15

    Flexible amout of rows in a table?

    Hi everybody,

    I already got a lot of help with my excel files here, it’s a great forum!

    I´m totally new at VBA, please keep that in mind

    I have 4 tables (one for every quarter) that fetch information from a main table. Due to a probability-function (50%,70% or 85%) that I use, the tables could have 50 or only 5 rows. For example:
    The main table has 50 projects in Q1 that have at least 50% probability of becoming an order. The Table for Q1 therefore needs at least 50 rows.

    If I choose only to see the projects that have 85% probability of becoming an order I might see only 5projects in Q1. That means 45 rows could be shown empty, which would look a bit silly

    Is it possible to have flexible tables depending on how many rows the table need in that moment (how many projects I choose to see)?
    I added a file that might help to explain my situation a bit more.

    Thanks a lot!

    Best Regards,

    Telgus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Last five rows in two columns, flexible solution?
    By Tresfjording in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2020, 06:00 PM
  2. Flexible/Automated Table of Contents
    By Keshypops in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 06-15-2016, 02:52 PM
  3. Looking for Flexible Macro to Create Table into Rows for Database
    By alex20850x in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2015, 10:07 PM
  4. [SOLVED] Sort Data with flexible rows and columns
    By cooket4 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 04-26-2012, 11:34 AM
  5. Replies: 0
    Last Post: 07-23-2010, 01:41 PM
  6. [SOLVED] calculate loan amout
    By dadddc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-18-2006, 10:20 PM
  7. [SOLVED] flexible paste rows function that inserts the right number of rows
    By marika1981 in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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