Move specific cells in a list

**questionguy** · 07-31-2012, 02:09 PM

Hi all,

little problem here, I got a list with information were I would like to move cells in column F, G, H, I, and J either up or down.
Currently my up and down buttons move the entire row; however, only those specific cells should be moved. Any ideas???

Here is a sample workbook:
Special Project.xlsm

**Pichingualas** · 07-31-2012, 02:23 PM

This should do it:

Special Project1.xlsm

I hope that helps.

**questionguy** · 07-31-2012, 02:31 PM

Yes it helps, but is it possible to modify it a little bit whereas when I click on a cell in either column F, G, H, I, or J, to make it active that it moves Serial #, Name, Line, Size and Dealer either up or down depending whether I use the Move Up or Move Down button??

**Pichingualas** · 07-31-2012, 03:13 PM

Maybe this then:

Special Project2.xlsm

I hope that helps.

**questionguy** · 07-31-2012, 03:32 PM

It Works!! Thanks...

**Cutter** · 07-31-2012, 05:13 PM

@ questionguy

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.