+ Reply to Thread
Results 1 to 4 of 4

copy selected column based on selected value to new worksheet

  1. #1
    Registered User
    Join Date
    02-19-2017
    Location
    Malaysia
    MS-Off Ver
    MS Office 2013
    Posts
    2

    copy selected column based on selected value to new worksheet

    hi, i'm new in using excel macro and vba. Here below i attach my sample file. i need help how to change the result from this:

    Capture1.PNG

    to this:

    Capture.PNG

    thank you.

    UserSystem.xlsm

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,742

    Re: copy selected column based on selected value to new worksheet

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,620

    Re: copy selected column based on selected value to new worksheet

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,620

    Re: copy selected column based on selected value to new worksheet

    ladydee94

    Thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. vba code for selected selected pages in one worksheet
    By mehmetics in forum Excel General
    Replies: 0
    Last Post: 11-06-2014, 02:41 PM
  2. Copy filtered Data into another worksheet based on selected criteria
    By TheresaHartigan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2014, 09:39 AM
  3. Macro to Copy Selected Range from one Worksheet to Another, based off of Criteria
    By KLiving in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-04-2013, 03:02 PM
  4. Activate worksheet based on a column value selected from validation list
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 11:05 PM
  5. Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  6. copy data from selected cells , in selected row and paste it to ms word table ?
    By aaashaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 03:25 PM
  7. Copy Selected Cells of Rows to another Worksheet Based on a Condition
    By Al53 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2010, 10:33 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