+ Reply to Thread
Results 1 to 9 of 9

As user fills out data sheet, then fill out a results sheet based on data sheet entry

  1. 02-13-2012, 01:50 PM #1
    clemsoncooz
    clemsoncooz is offline
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    As user fills out data sheet, then fill out a results sheet based on data sheet entry

    I have a data sheet that a user will continue to add records in the last empty row. Then they will place an "x" into (3) columns indicating what type of data it is.

    I have a seperate sheet dedicated to each Column type. Depending upon where they place the X (in whichever Column), then it shows on that specified results page. How do I set up a feature that once a user enters in the data in the last row, it will automatically be added to that specified results sheet?

    I have a sample workbook attached. Its pretty easy and self explanatory once you see it.
    Attached Files Attached Files
    Last edited by clemsoncooz; 02-13-2012 at 03:57 PM.
    Reply With QuoteRegister To Reply
  2. 02-13-2012, 02:22 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    Hello clemsoncooz,

    What if your Selections on the Data Sheet Changes to different Cells? Will the last row always be what it is now, or could it go down further?

    With the present setup, I have made a few simple changes, which might serve your purpose better, if I understand you correctly.

    See attached WorkBook
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 02-13-2012, 02:23 PM #3
    Pichingualas
    Pichingualas is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    You could try using an events macro.
    Reply With QuoteRegister To Reply
  4. 02-13-2012, 02:27 PM #4
    clemsoncooz
    clemsoncooz is offline
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    Thanks for looking at this Winon.

    The last row on the data sheet will change as the user enters data. As each row is populated, that is when I would want them to appear on the Results page. This isnt a one time event, but a contineous event, so I think I need something that uses an event change much like Pichignualas has recommended....I just dont know how to do it.
    Reply With QuoteRegister To Reply
  5. 02-13-2012, 03:23 PM #5
    Pichingualas
    Pichingualas is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    OK try this code. But mind you, paste it on the code that corresponds to the page named "DATA".

    Please Login or Register  to view this content.
    The location of Events macro codes is important, otherwise they don't work. I also attach the file you uploaded with the working macro.

    Hope that helps.
    Example 2-13 (2).xlsm
    Last edited by Pichingualas; 02-13-2012 at 03:30 PM.
    Reply With QuoteRegister To Reply
  6. 02-13-2012, 03:28 PM #6
    Pichingualas
    Pichingualas is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    btw, if you change a cell that is part of an entry that was already there it will copy it again. also, this works regardless of what the user writes on the column that shows which type of data it is. if you want it to work only when an "x" is typed, then change the line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Hope it helps.
    Reply With QuoteRegister To Reply
  7. 02-13-2012, 03:35 PM #7
    clemsoncooz
    clemsoncooz is offline
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    Very Cool Pichingualas. Thank you very much! This does help!

    What about if you were to delete an X or change it? I recieve an error " run Time error 13: Type Mismatch" (debug takes me to val = target.value)

    If I delete an "X" - I would like the sheet to update and remove the "TEXT" from the data column ON the RESULTs pages. Can this be done?
    Reply With QuoteRegister To Reply
  8. 02-13-2012, 03:52 PM #8
    Pichingualas
    Pichingualas is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    Yes it can be done, sorry I'm on my way home atm and can't help.
    Reply With QuoteRegister To Reply
  9. 02-13-2012, 03:57 PM #9
    clemsoncooz
    clemsoncooz is offline
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: As user fills out data sheet, then fill out a results sheet based on data sheet e

    Quote Originally Posted by Pichingualas View Post
    Yes it can be done, sorry I'm on my way home atm and can't help.

    ok - thanks. I will make it as solved anyways as you have answered my first question.

    Thanks again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1