I have a sheet that contains three separate components...
The first is a column titled "Key" (column B in the attached example). Data would be periodically added to this column by the user.
The 2nd component is a counter button that increases it's value by 1 each time it is pressed. (I didn't include the actual button macro in the example, but the value under the heading "Count Enter" in column D would normally be populated from this button)
What I would like to happen is each time the counter button is pressed changing the count, a row would be added for each entry in the "Key" column, and these rows would be populated with one column that would equal the "Count Enter" value, and a 2nd column that would recreate the "Key" list. Because data would be periodically entered into the "Key" column the number of rows that would need to be added would continue to grow at an unpredictable rate. The attached example shows 3 "button clicks". For the first 2 button clicks the key has 8 entries, and I've simulated 12 entries in the key for the 3rd click.
The last component is a separate table (found on "sheet 6" in the attached example), would populate the added rows using VLOOKUP.
Hopefully the attached example can demonstrate what I'm asking more clearly. Thanks for any help!
Bookmarks