Buttons to move cells from one sheet to another (back and forth)

[farresto]

Hi everyone,

I have 2 sheets: one for all the tasks and another one for the priority 1 tasks. What I need to do is to create something easy and user friendly for everyone to move a/several task/s from the ALL to the PRIO sheet (back and forth).

I thought of adding "plus" or "remove" buttons on the sides of the tasks (each one takes 6 columns) and creating a macro that will cut the row and paste it on the other sheet. This has several problems (I wanted to make it more "generic" and I'm wondering whether there's another way to start... Unfortunately, I need to do this with Excel.

Can anyone enlighten me a bit on this please? I wanted to be clear and concise, if the problem is not clear please let me know.

Thanks a lot!

[carsto]

you'd only need two buttons (one per sheet) if the code operated on the current selection.
"Move Selected Cell to ALL" & "Move Selected Cell to PRIO"
example:

Please Login or Register  to view this content.

as a safety measure you could add in a message box asking if they really want to move "XXX".
"XXX" being data displayed from one of the cells in the row

[farresto]

Hi,

First of all, thanks for your quick reply. The code is "somewhat" like I did. It's workable, but:

1- I need something completely visual. The person that will move cells from one sheet to the other should not have to select the row or one cell. He would just click on the button (at the side of the task) and the info would go to the other sheet. That's why I would need one button per task. If you know a work-around for it, I'm more than willing to do a couple of changes. What I can't do is have the users input text or go around the xls selecting cells

2- I thought of moving the row depending on the object's cell position. But... I don't know how to get the object's position nor how to insert a variable into the Range (like: Range("Var")).

I'm attaching a fake screenshot on how each sheet would look like. Just imagine there are a lot of rows like those . The Plus and Minus Signs are just an example. Those are the ones that will trigger the moving cells/rows.

Thanks again.