move and format data with double click

[navigator25]

Im not sure how difficult it would be to complete the task im trying to accomplish. Hopefully I can explain this in a way everyone can understand.

I have 2 sheets in a workbook. On sheet 2 I would like to be able to double click a cell to send the contents and all formatting of a cell to sheet 1 to a specific cell. Then after clicking that cell in sheet 2 I would like the background to change colors and add strike through so I know that is no longer an option to select. Each double click I do it needs to send it to the next available cell. I.E. 1st selection goes to a1, 2nd b1, 3rd c1, 4th d1, 5th e1, 6th f1, 7th g1, 8th h1. After I get it to h1 I would like it loop back to stay in the h column but drop to row 2. So the 9th one I select would go to h2, 10th g2, 11th f2 etc. When I get back to the "a" column it would drop to the 3rd row and continue this pattern as long as I need.

I know I could easily copy and paste the content. However this is something I would like to try and get working.

I've got an example sheet attached hopefully it shows good enough what im trying to accomplish.

[antoka05]

See attached file. Be careful not to click the edges of the cells else excel will move the active cell without performing the double click event.
This is the macro I added:

Please Login or Register  to view this content.

Regards,
Antonio

[watersev]

hi, navigator25, please check attachment, double-click cell on Sheet2

[navigator25]

Wow, both do exactly what i need! Thanks a lot guys!

Only thing i can think of is there a way to do an undo button so if i click the wrong cell i can remove it without starting over?

[watersev]

if you are happy with the help provided please mark the thread as Solved, see Forum Rules for details: http://www.excelforum.com/forum-rule...rum-rules.html, Rule #9

[navigator25]

if you are happy with the help provided please mark the thread as Solved, see Forum Rules for details: http://www.excelforum.com/forum-rule...rum-rules.html, Rule #9

I am however I had a second question about the same topic so I was going to wait until I figured that out as well.

Wow, both do exactly what i need! Thanks a lot guys!

Only thing i can think of is there a way to do an undo button so if i click the wrong cell i can remove it without starting over?

If I should start a completely new thread thats fine it just seems like that would make more threads than needed.