+ Reply to Thread
Results 1 to 8 of 8

Checking one sheet with results on another

  1. 12-06-2021, 08:54 PM #1
    darrinhoskins
    darrinhoskins is offline
    Registered User
    Join Date
    12-06-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Checking one sheet with results on another

    Can you help me with a situation or direct me to where I can get this information?
    I work for a Mechanical Contracting Company and I am trying to resolve an issue.
    I have a lengthy tool list spreadsheet and have my Project Managers check off the items they need for the jobs on the spread sheet and we have the list go to the tool manager to fill the order. The problem is I want to only have the items checked on the list going to the tool manager. Is there any way to make this list shorter on another tab that will show only the items that were checked so the one pulling the tools is not accidently filling an item that is not checked but on the list?
    Any help would be wonderful.
    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 12-06-2021, 09:25 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Checking one sheet with results on another

    It is certainly possible but the solution would be so specific to your file that we can't give you a generic solution that you can just plug in. For example, I can think of at least two ways that someone could "check off" items. Please note that you can share your file here (see yellow banner at the top of the page). If it has sensitive data, you can replace it with dummy data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 12-06-2021, 09:56 PM #3
    darrinhoskins
    darrinhoskins is offline
    Registered User
    Join Date
    12-06-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Checking one sheet with results on another

    Please see attached Spreadsheet. I am wanting to use the first sheet to enter quantities of each tool needed
    and have the results be on the next sheet (Sheet2)
    showing the name of the tool and the quantity of tools needed only
    and if there is not a quantity entered in Sheet 1 that tool would not show up on Sheet 2.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-09-2021, 02:36 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Checking one sheet with results on another

    Hello darrinhoskins and Welcome to Excel Forum.
    Try pasting the following into cell B5 on Sheet2, then drag the fill handle down to cell B10 and then, while B5:B10 are still selected, drag the fill handle over to cell C10:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  5. 12-09-2021, 02:43 PM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Checking one sheet with results on another

    Hi & welcome to the board.
    Another option for xl365
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 12-09-2021, 04:14 PM #6
    darrinhoskins
    darrinhoskins is offline
    Registered User
    Join Date
    12-06-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Checking one sheet with results on another

    Thank You!!!
    Reply With QuoteRegister To Reply
  7. 12-09-2021, 04:19 PM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Checking one sheet with results on another

    Glad to help & thanks for the feedback.
    Reply With QuoteRegister To Reply
  8. 12-09-2021, 04:23 PM #8
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Checking one sheet with results on another

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
    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)

Similar Threads

  1. [SOLVED] Results from one sheet to other with checking persons names
    By mull21 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-19-2018, 10:34 PM
  2. Checking History of Colomn and Displaying a Dynamic List based on results
    By AZHDes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2017, 01:49 AM
  3. Checking History of Colomn and Displaying a Dynamic List based on results
    By AZHDes in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-10-2017, 01:49 AM
  4. Need help in Checking cells in different files and showing results in the next cell
    By topsoft in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2015, 08:06 AM
  5. [SOLVED] Trouble with Find Error Checking: Is Nothing and Is Not Nothing returning the same results
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2013, 09:02 PM
  6. IF Function results are not accurate when checking the math manually
    By mmcgibbony in forum Excel General
    Replies: 2
    Last Post: 12-29-2011, 03:23 PM
  7. [SOLVED] Wanting to write results to array instead of sheet, results overwriting....
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1