+ 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
    6,986

    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
    6,986

    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)

Similar Threads

  1. Transfer Input Data from Sheet 1 to Sheet 2 on button click
    By Daniel Pilgrim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2019, 03:24 AM
  2. Replies: 6
    Last Post: 08-09-2018, 11:42 PM
  3. [SOLVED] Transfer data from Input sheet to output sheet on condition
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 07-13-2015, 08:22 AM
  4. Transfer data from Database sheet back to Input sheet
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2015, 05:59 PM
  5. [SOLVED] Issue regarding recorded Macro to transfer data from Input sheet to Storage sheet
    By Hirad001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2015, 04:26 PM
  6. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  7. Transfer cell value from sheet to sheet based on user input (SOLVED)
    By Terrydorset in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2013, 01:28 PM

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