+ Reply to Thread
Results 1 to 5 of 5

Copy name from list to another worksheet list

Hybrid View

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    2

    Copy name from list to another worksheet list

    Hi

    I need macro which copies row in "Start_list"
    from column A to D to another worksheet called "Final_list" to column B:E.
    Row to copy is given from cell"K1" and it's start number from column A.
    Macro should start with "Add to list" button.
    Copied row should be pasted as a next row in "Final_list".
    Thanks for any help.

    Start_list.xlsm

  2. #2
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Copy name from list to another worksheet list

    Try this! I commented the code to hopefully make more sense. Let me know if you have any questions.
    start_list.xlsm
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.

  3. #3
    Registered User
    Join Date
    05-26-2014
    Posts
    2

    Re: Copy name from list to another worksheet list

    Great, this is exactly what I wanted.
    I wrote some lines to comunicate with users.
    1. when the number don't exist on the list - msg.
    2. when the number exist on the final list - msg, and here
    I found that it paste the same number on the final list.

    How to avoid it?

    start_list1.xlsm

  4. #4
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Copy name from list to another worksheet list

    Try this!
    start_list.xlsm

  5. #5
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Copy name from list to another worksheet list

    Did that answer your question. If so please mark thread as solved, and add reputation.

    Thanks

+ 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. Add colums with same title and have info copy to new worksheet as a list
    By HelenClark in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-01-2014, 09:02 AM
  2. Copy List of Userform Data to Worksheet
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-22-2011, 10:15 AM
  3. Drop Down List to Copy Entire Contents of Worksheet into Master Worksheet
    By mrmartin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2011, 10:54 PM
  4. Auto copy from drop down list to new worksheet
    By allyc0820 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2011, 09:33 PM
  5. alphabetic list - copy each letter to different worksheet
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-17-2010, 08:17 PM

Tags for this Thread

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