This may be a terrible way of doing this, but I will try to explain and hopefully get some better direction. What I am trying to create is something that is easy to use and will allow the user to move people up and down on a list by clicking an up or down arrow (CommandButton). There are two CommandButtons per row, one in column A and one in column B. Clicking on the Down button on the first row for instance, replaces the range C2:H2 with C3:H3.
What I do not currently understand is a dynamic way of doing this. Surely I wouldn't have to replicate code for each button would I? I would like for this to be about a list of 30 people (rows) or so. I would appreciate any or all help.
Regards,
Hoffey
Bookmarks