+ Reply to Thread
Results 1 to 4 of 4

Copy and sort cells

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    59

    Copy and sort cells

    Hi, I have a little problem, so maybe one of you skilled members can help me out.

    I would like to make a piece of VBA code that will copy the data from B3:C11 (fist sheet) and put it into the individual columns (second sheet). The columns are named ID, name, e-mail, phone, value, adress.
    The second sheet should therefore act as some kind of database, where new entries are put below the last one. Also, it would be great if the program checked at first whether the ID is already written in the sheet2(database) and if so, it would write an error message.

    Does anyone know how to achieve this the least difficult way? I am not very skilled with VBA.

    Thanks. Any help will be appreciated.

    P.S.: I have included the sampleAttachment 336217

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy and sort cells

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-02-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    59

    Re: Copy and sort cells

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.
    Yes, that is exactly what I meant. Thank you kind sir )
    * to you.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy and sort cells

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

    9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

+ 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. Copy Info between Cells and Sort by Horizontal Titles
    By awolfa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 09:08 AM
  2. [SOLVED] How to dynamic copy a range of cells and sort them?
    By nchinas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 03:33 PM
  3. Macro tied to button to copy cells to another sheet even if I re-sort
    By coolistic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2012, 06:11 AM
  4. copy and sort data to new cells automatically...by function or macro maybe?
    By soundengineer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-22-2007, 10:30 PM
  5. [SOLVED] Pls. reply Sort Data and copy to next coulmn when sort order chang
    By shital shah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10:05 AM

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