+ Reply to Thread
Results 1 to 3 of 3

Check time from one sheet wrt time between another sheet in given range of two and return

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Check time from one sheet wrt time between another sheet in given range of two and return

    Time in one sheet to be checked inside the range from 2nd sheet & return corresponding values
    attached excel sheet
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Check time from one sheet wrt time between another sheet in given range of two and ret

    Hi and welcome to the forum

    is the data in both sheets sequential? In other words, can row 2 sheet2 be checked against row 2 sheet1, row 3 sheet2 against row 3 sheet1 etc? or is there a unique identifier common to both sheets? (if there is, I cant see it)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-15-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Check time from one sheet wrt time between another sheet in given range of two and ret

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    is the data in both sheets sequential? In other words, can row 2 sheet2 be checked against row 2 sheet1, row 3 sheet2 against row 3 sheet1 etc? or is there a unique identifier common to both sheets? (if there is, I cant see it)
    There is no unique identifier to this , only thing common is that product"ID" in "main" sheet were produced in between
    "online" & "offline" time in "roll Data" time where the rolls were inserted into machine.

    I need to get "stand" & "Roll Shape" information against the product "ID"

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1