Results 1 to 17 of 17

Userform to copy data from one sheet to another

Threaded View

  1. #1
    Forum Contributor Marco-Kun's Avatar
    Join Date
    04-14-2009
    Location
    Holland
    MS-Off Ver
    Dutch:2007
    Posts
    298

    Userform to copy data from one sheet to another

    Hello everyone,

    The added workbook has an example.

    On Sheet2 I would like to have a botton which opens a form which has to ask for an input.
    This input has to be compared with entries on Sheet1 in column A. If they match it should copy the data from Sheet1 to Sheet2.
    But not all data, only the data in column C: Input2. If it doesn't match it should give an error message and the option to either try again or cancel.

    I hope you can help me with this!
    Also, I would like to request the apostrophe notes with the code so it's easier for me to understand what is going on.

    Thanks in advance,

    Kind regards,

    Marco
    Attached Files Attached Files
    Last edited by Marco-Kun; 12-13-2011 at 10:58 AM. Reason: Removed a spelling error

Thread Information

Users Browsing this Thread

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

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