+ Reply to Thread
Results 1 to 5 of 5

Userform, Search, copy an paste data from a userform database to another sheet.

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    toronto
    MS-Off Ver
    excel 2010
    Posts
    3

    Userform, Search, copy an paste data from a userform database to another sheet.

    Good Evening All,

    I appreciate any help or direction that the community here can offer.

    I have included and excel sheet (with comments) of what i have accomplished to date; vba is completely new to me, so I have been doing as much reading as my job allows.

    To start, here is the situation: I have to log test results from students into excel, then manipulate and analyze the data in a couple of months. Each student will be assessed around 6 times, depending on failures, on various tests in various roles with various instructors. I created a user form so the teachers could enter the data themselves as they assess.

    Every time the userform is used, it will add an entry into Candidate Data Log.

    What I need to do now, is take all the test results for each student and summarize into a single row by student. I put an example in the summarize sheet done manually.

    So for example, Tom has done two tests, Toms row on the summarize sheet would show the first test results, in in Row 14 from B14-J14 and his second test from K14 to S14, and so on as tests are done. Each student has a row unique row.

    The reason for populating the data like this is so that I can use mail-merge each to populate the Data into weekly assessment forms showing all the tests they accomplished that week with the test data.

    I put in the comments on excel how I thought I could do it, but the coding is beyond me.

    Essentially I think I need a macro to search down column A in the log, take the first name, copy the adjacent 9 cells, then search for the same name in the summarize sheet, check for an empty column beside it, if true past the result, then continue to search, on the next entry it would do the same thing except to a different student. When it finds a name, and check for an empty cell it would paste the date in the row, after the previous data, in the next empty cell. After it reaches the end of the log it would stop.

    This may be entirely round-about way of doing this, if so let me know, the end result is to have a log of individual chits as well as chits listed horizontally by student.

    Again thank for any help, and I apologize for the large explanation, I just wanted to be as clear as possible.

    Regards,

    Mason
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Userform, Search, copy an paste data from a userform database to another sheet.

    Hi Mason

    What you ask for is very easy to do,

    However I don't believe that your data is not yet in a fit state for me to spend time writing a macro.

    You really need to use students surnames, zip codes or student numbers to make sure that the data is clearly identifiable.

    Surely there will be more that one John or Sue?
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-31-2015
    Location
    toronto
    MS-Off Ver
    excel 2010
    Posts
    3

    Re: Userform, Search, copy an paste data from a userform database to another sheet.

    Thank you for your response,

    I appologize for taking so long to get back. I did not include any actual data from the students for policy reasons. Each student will be indentified by a student number and their last name (Candidate Name) and (StNumber). Would you like me to fill in the lists with example data to work from?

    Thanks again,

    Mason

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Userform, Search, copy an paste data from a userform database to another sheet.

    yes please.

    Dummy Data in the same format.

    It is annoying when you spend hours creating something, only to be asked to rewrite it all.

  5. #5
    Registered User
    Join Date
    03-31-2015
    Location
    toronto
    MS-Off Ver
    excel 2010
    Posts
    3

    Re: Userform, Search, copy an paste data from a userform database to another sheet.

    Mehmetcik,

    Here it is. I included an additional sheet that has a wish list item on it, it might not be possible in excel or it might be a bad idea, treat it as such if so.

    Again I really appreciate your help.

    Thanks,

    Mason
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 02-27-2014, 04:43 PM
  2. Replies: 4
    Last Post: 12-30-2013, 10:10 AM
  3. Search database using userform return result in another sheet
    By ankuagarwal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 04:19 AM
  4. [SOLVED] Userform for date entry and then copy/paste matching data to another sheet
    By nymanns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 03:22 AM
  5. Database userform search data, go to row
    By dmanatee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2010, 09:06 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