Results 1 to 6 of 6

move and format data with double click

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    ohio
    Posts
    13

    move and format data with double click

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1