Results 1 to 7 of 7

How to copy each result to other column when accepted?

Threaded View

  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

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