Is there a way to create a dynamic list like this?

**Foxgguy2001** · 10-16-2011, 12:44 AM

http://img1.UploadScreenshot.com/ima...2880027529.jpg

I'd like to create a dynamic list as depicted in the screenshot above...the actual table of options would be on another sheet, but I'm wondering if it's possible to have a new row created upon selection of a category, and then when a item is selected, it adds the bulletpoint, and creates another new row, where you can either choose a new catagory, or select another item?

The reason I would need it to create a new row is becuase there would be a paragraph or so of text above and beneath the catagories and items.

Almost like a list building deal with information above and below the list.

Is something like this even possible?

**Foxgguy2001** · 10-16-2011, 12:46 AM

I guess on second thought it wouldnt even have to add the bulletpoint, it could be added to every item...

**gilligan8** · 10-16-2011, 01:46 AM

Do you know VBA?

I have built dynamic tables based off of another sheet.

Basically it is a leader board for disc golf. You put in how many players in a grid of pre-defined divisions (Novice, Amateur, Advance, Pro... and so on)... You click a button and it then jumps to another sheet and puts in a row for each player with things like rounds, total, prizes and points to be filled in later. It has headers and such for each division it actually creates two sheets, one doesn't have headers and formatting (for uploading to a website as a CSV) the other is for display.

**Foxgguy2001** · 10-16-2011, 08:51 PM

Originally Posted by gilligan8

Do you know VBA?

I have built dynamic tables based off of another sheet.

Basically it is a leader board for disc golf. You put in how many players in a grid of pre-defined divisions (Novice, Amateur, Advance, Pro... and so on)... You click a button and it then jumps to another sheet and puts in a row for each player with things like rounds, total, prizes and points to be filled in later. It has headers and such for each division it actually creates two sheets, one doesn't have headers and formatting (for uploading to a website as a CSV) the other is for display.

This actually sounds like what I'd need, of course with all of them on one sheet instead of two. I know 'know' bv, but I've been able to do some minimally, and modify other tasks to suit my needs.

**gilligan8** · 10-16-2011, 08:57 PM

I'm a big fan of loops.

So that's basically what I did. Ran lots of loops populating things based of what increment on the for loop I was on.

Create a command button that runs what you need when you click on it.

Check out "for loops" and let me know where that gets you.