+ Reply to Thread
Results 1 to 7 of 7

How to copy each result to other column when accepted?

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    6

    How to copy each result to other column when accepted?

    I am looking for help from exports.
    In attached sample sheet, F3 is the result cell. When "select" button next to the cell is activated I want this result value copied to selection list cell E7 (paste special).
    Continuing with next result F3, and "selected" I need this new result copied to next column on selection list E8 and so on. How do I do this?

    Next task is to remove any selected items (that were copied from various results) when "remove" button is activated and below items should move up to fill the blank cell.

    F G
    <1> choose--> Category A
    <2> choose--> Size S
    <3> result--> Model A-S select button


    Selected Model (from f3 result. whenver G3 is selected new result copied to below list)
    <7> Cell E7 (f3 copy here) remove button
    <8> Cell E8 (f3 copy here) remove button
    <9> Cell E9 (f3 copy here)
    <10> Cell E10 (f3 copy here)

    Looking forward to experts guide.

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to copy each result to other column when accepted?

    this seems to accomplish the first task.

    Please Login or Register  to view this content.
    I don't know where QTY is supposed to come from...

    as for the remove button, I was actually looking for something similar earlier without any luck... i'll keep looking though.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    07-25-2014
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    6

    Re: How to copy each result to other column when accepted?

    Wow, so fast and nicely done. However, I need to make first selected result stays in the list. Then when new result is selected it should copied to next column upon selected. Currently, reult value copied to E7 does not stay and keeps changing with new result. Any other method?
    You can disregard the QTY. It is for user to add when ordeirng selected items.

    In general, here is my scnario.
    E1:F3 is for selection of many products and the model number is the result at F3. If OK user can click "select" button and it should go to the cart (E7:E13). User needs to select more items and keep adding them to the cart.

  4. #4
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to copy each result to other column when accepted?

    sorry, i wrote that assuming QTY (column F) would also be filled in this works w/out QTY:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-25-2014
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    6

    Re: How to copy each result to other column when accepted?

    Super!!!!
    Thank you sooooo much!!

  6. #6
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to copy each result to other column when accepted?

    this seems to be working for the second request:

    Please Login or Register  to view this content.
    http://stackoverflow.com/questions/3...ch-was-clicked

  7. #7
    Registered User
    Join Date
    07-25-2014
    Location
    Irvine
    MS-Off Ver
    2007
    Posts
    6

    Re: How to copy each result to other column when accepted?

    Simarui, I've been struggling for a week with this and you solved it just in a split seconds!!
    Both work perfectly per my needs. I am so lucky to find you here today. Thank you again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to copy each result to other column when accepted?
    By robbykang in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2015, 01:51 PM
  2. Column with "accepted, rejected" from values with tolerances
    By CA Louw in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-21-2014, 09:12 AM
  3. VBA copy filtered result to next column help. New to VBA
    By kc001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 01:05 AM
  4. Filter List by Keyword & copy the result in column by keyword as header
    By kitunga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2013, 07:16 AM
  5. ? format column so no duplicate entries are accepted
    By Selina in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2006, 08:40 PM

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