+ Reply to Thread
Results 1 to 4 of 4

Transfer input onto the next sheet

  1. #1
    Registered User
    Join Date
    05-23-2020
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    2

    Transfer input onto the next sheet

    Hey guys I'm brand new with excel. I've created a sheet with material list for construction purposes and I have a question. Because there is like a list of 100 different types of materials in the sheet - Can i somehow make all the cells in which i have put the amount of each item populate on the next sheet?
    So basically if I have 100 items, and i put whatever # next to 15 of them, Is there a way that only those 15 will populate into a list on sheet #2?

    I hope it's not too confusing and I would appreciate the help.


    Thanks!

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,303

    Re: Transfer input onto the next sheet

    .
    Here is a sample project for you to review. This project comes from a friend of mine in South Africa.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-23-2020
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    2

    Re: Transfer input onto the next sheet

    This is exactly what I was looking for. Thank you so much!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,303

    Re: Transfer input onto the next sheet

    .
    You are welcome.

+ 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