+ Reply to Thread
Results 1 to 1 of 1

Generating a Dynamic table based off user input

  1. #1
    Forum Contributor
    Join Date
    12-08-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    173

    Generating a Dynamic table based off user input

    I have a static table

    i.e.
    ... ... 21 22 23 24 25 26 27 28 29 30
    50 100 5 5 4 4 4 4 4 4 3 3
    60 150 7 7 7 6 6 6 6 5 5 5
    70 216 10 10 9 9 9 8 8 8 7 7
    80 300 14 14 13 13 12 12 11 11 10 10
    90 400 19 18 17 17 16 15 15 14 14 13
    100 516 25 23 22 22 21 20 19 18 18 17
    110 650 31 30 28 27 26 25 24 23 22 22
    120 800 38 36 35 33 32 31 30 29 28 27
    130 966 46 44 42 40 39 37 36 35 33 32
    140 1,150 55 52 50 48 46 44 43 41 40 38
    150 1,350 64 61 59 56 54 52 50 48 47 45
    160 1,566 75 71 68 65 63 60 58 56 54 52
    170 1,800 86 82 78 75 72 69 67 64 62 60
    180 2,050 98 93 89 85 82 79 76 73 71 68
    190 2,316 110 105 101 97 93 89 86 83 80 77
    200 2,600 124 118 113 108 104 100 96 93 90 87
    210 2,900 138 132 126 121 116 112 107 104 100 97
    220 3,216 153 146 140 134 129 124 119 115 111 107
    230 3,550 169 161 154 148 142 137 131 127 122 118
    240 3,900 186 177 170 163 156 150 144 139 134 130
    250 4,266 203 194 185 178 171 164 158 152 147 142
    260 4,650 221 211 202 194 186 179 172 166 160 155
    270 5,050 240 230 220 210 202 194 187 180 174 168
    280 5,466 260 248 238 228 219 210 202 195 188 182
    290 5,900 281 268 257 246 236 227 219 211 203 197
    300 6,350 302 289 276 265 254 244 235 227 219 212
    310 6,816 325 310 296 284 273 262 252 243 235 227
    320 7,300 348 332 317 304 292 281 270 261 252 243
    330 7,800 371 355 339 325 312 300 289 279 269 260
    340 8,316 396 378 362 347 333 320 308 297 287 277
    350 8,850 421 402 385 369 354 340 328 316 305 295

    1st column is the level
    2nd colume is the moneys recieved
    1st row is the time between 20 min and 60 min
    All green data is generated using a formula

    I then want to create a table that is generated based off the users input

    THe first value would be based on a cell the user inputs into, along with the last value

    i.e
    Start lvl = 200
    End level = 300

    example table

    200 2,600 124 118 113 108 104 100 96 93 90 87 84 81 79 76 74 72 70 68 67 65 63 62 60 59 58 57 55 54 53 52 51 50 49 48 47 46 46 45 44 43
    210 2,900 138 132 126 121 116 112 107 104 100 97 94 91 88 85 83 81 78 76 74 73 71 69 67 66 64 63 62 60 59 58 57 56 55 54 53 52 51 50 49 48
    220 3,216 153 146 140 134 129 124 119 115 111 107 104 101 97 95 92 89 87 85 82 80 78 77 75 73 71 70 68 67 66 64 63 62 61 60 58 57 56 55 55 54
    230 3,550 169 161 154 148 142 137 131 127 122 118 115 111 108 104 101 99 96 93 91 89 87 85 83 81 79 77 76 74 72 71 70 68 67 66 65 63 62 61 60 59
    240 3,900 186 177 170 163 156 150 144 139 134 130 126 122 118 115 111 108 105 103 100 98 95 93 91 89 87 85 83 81 80 78 76 75 74 72 71 70 68 67 66 65
    250 4,266 203 194 185 178 171 164 158 152 147 142 138 133 129 125 122 119 115 112 109 107 104 102 99 97 95 93 91 89 87 85 84 82 80 79 78 76 75 74 72 71
    260 4,650 221 211 202 194 186 179 172 166 160 155 150 145 141 137 133 129 126 122 119 116 113 111 108 106 103 101 99 97 95 93 91 89 88 86 85 83 82 80 79 78
    270 5,050 240 230 220 210 202 194 187 180 174 168 163 158 153 149 144 140 136 133 129 126 123 120 117 115 112 110 107 105 103 101 99 97 95 94 92 90 89 87 86 84
    280 5,466 260 248 238 228 219 210 202 195 188 182 176 171 166 161 156 152 148 144 140 137 133 130 127 124 121 119 116 114 112 109 107 105 103 101 99 98 96 94 93 91
    290 5,900 281 268 257 246 236 227 219 211 203 197 190 184 179 174 169 164 159 155 151 148 144 140 137 134 131 128 126 123 120 118 116 113 111 109 107 105 104 102 100 98
    300 6,350 302 289 276 265 254 244 235 227 219 212 205 198 192 187 181 176 172 167 163 159 155 151 148 144 141 138 135 132 130 127 125 122 120 118 115 113 111 109 108 106
    Last edited by Sparkplug90; 04-29-2017 at 06:43 PM.

+ 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. Create a table that is sized based on user input in Excel?
    By hemagala in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2015, 06:48 AM
  2. VBA to Select Multiple Weeks in Pivot Table based on User Input
    By burrow.philip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 11:36 AM
  3. [SOLVED] Project Timeline with Dynamic Date Range Based on User Input
    By Rollinstone12 in forum Excel General
    Replies: 2
    Last Post: 10-28-2012, 10:07 AM
  4. Code/Macro to populate table based on user input.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-08-2011, 07:50 AM
  5. Updating value in table based on user input
    By danresnick.dr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2010, 07:16 PM
  6. Generating dynamic charts based on the user input
    By shivan4u in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-13-2006, 08:43 AM
  7. Create a table based on user input?
    By S. Anders in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 09:36 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