+ Reply to Thread
Results 1 to 1 of 1

Recording multiple data points to multiple rows at once

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    salinas, ca
    MS-Off Ver
    Excel 2010
    Posts
    25

    Recording multiple data points to multiple rows at once

    Hello Everyone!

    I need help resolving a problem I have with a userform. The userform is meant to record a series of visual inspections (Pass/Fail) on a group of items before these items are sent to storage; and for that purpose the userform works fine. The problem arises when the item in question has more than one component (ball= 1 component, toy soldier= 4-8 components).
    The process in the vba code assigns an identifier to each item based on a combination of a Base ID (static), Location(dynamic) and the first four letters of the component which are also dynamic and are only visible depending on the item itself.
    If the item has more than 1 component, the code would have to assign this identifier to all of the components at once and record the results of the inspections with the location and unique identifier for each component. Please take a look at the sample file attached to this request.
    My problem is that I cannot figure out a way to complete this task with the form the way it is at the moment; and I need your help to come up with a solution by either modifing the userform or the vba code -- or a combination of both -- so that the identifier comes together and then gets recorded on the sheet for each component.

    Please let me know if anyone has any ideas or if you need more info... any help will be greatly appreciated!

    Julian
    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. Multiple Data Points for a Single Day
    By SheilaV in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 08-20-2019, 02:51 AM
  2. Splitting rows with multiple columns into seperate rows for time points.
    By mbracha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2013, 10:06 AM
  3. Need macro to search multiple data points from multiple entries and return single value
    By Redbullmoo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 02:16 AM
  4. Compare multiple data points in row _ multiple sheets _ output different information
    By floydian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 08:52 AM
  5. Replies: 4
    Last Post: 07-05-2012, 12:05 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