Data Transfer to a New Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1519261%22%20slang%3D%22en-US%22%3EData%20Transfer%20to%20a%20New%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519261%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EI%20have%20a%20list%20with%20a%20calculator%20set%20up%20on%20an%20excel%20spreadsheet%20for%20my%20business%2C%20but%20I%20am%20currently%20trying%20to%20figure%20out%20if%20it%20is%20possible%20to%20get%20a%20shortened%20list%20to%20transfer%20to%20the%20second%20sheet%20with%20only%20the%20values%20i%20have%20entered%20included.%20I%20would%20like%20to%20have%20an%20entire%20list%20generated%20on%20Sheet%202%20based%20on%20the%20materials%20i%20actually%20need%20for%20a%20specific%20job.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20on%20Sheet%201%20i%20have%20my%20list%20of%20possible%20materials%20needed%3B%20Wood%2C%20Metal%2C%20Nails%2C%20Screws%2C%20etc.%20and%20the%20cost%20is%20calculated%20when%20i%20enter%20a%20quantity.%20What%20i%20would%20like%20to%20happen%20is%20when%20i%20enter%20quantities%20in%20the%20nails%20and%20wood%20category%20those%20rows%20transfer%20to%20Sheet%202%20but%20when%20data%20is%20not%20entered%20into%20metal%20and%20screws%20those%20categories%20do%20not%20appear%20on%20Sheet%202.%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20this%20is%20possible.%20Thank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1519261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519460%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Transfer%20to%20a%20New%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F727161%22%20target%3D%22_blank%22%3E%40Alysonfoster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20it's%20possible.%20Especially%20if%20you%20have%20the%20newest%20version%20of%20Excel.%20There's%20a%20function%20called%20%3CSTRONG%3EFILTER%3C%2FSTRONG%3E%20that%20could%20be%20set%20up%20to%20extract%20only%20the%20items%20and%20values%20that%20you've%20identified%20for%20a%20specific%20job%2C%20and%20list%20them%20on%20a%20second%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20simple%20demonstration.%26nbsp%3B%20If%20this%20doesn't%20work%20for%20you%20%5Byou%20should%20be%20able%20to%20add%20to%20the%20master%20list%20and%20immediately%20see%20the%20results%20on%20the%20second%2C%20filtered%20list%5D....if%20that's%20not%20working%2C%20it%20means%20you%20don't%20have%20the%20most%20current%20Excel.%20Look%20into%20getting%20it.%20If%20you%20can't%20there%20are%20older%20ways%20of%20doing%20this%2C%20but%20this%20is%20so%20convenient%2C%20you%20should%20get%20it%20if%20at%20all%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1519504%22%20slang%3D%22de-DE%22%3ESubject%3A%20Data%20Transfer%20to%20a%20New%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1519504%22%20slang%3D%22de-DE%22%3EA%20small%20demo%20Excel%20file%20with%20your%20project%20would%20be%20of%20great%20help%20for%20all%20of%20us%20...%20Especially%20for%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello.

I have a list with a calculator set up on an excel spreadsheet for my business, but I am currently trying to figure out if it is possible to get a shortened list to transfer to the second sheet with only the values i have entered included. I would like to have an entire list generated on Sheet 2 based on the materials i actually need for a specific job. 

For example on Sheet 1 i have my list of possible materials needed; Wood, Metal, Nails, Screws, etc. and the cost is calculated when i enter a quantity. What i would like to happen is when i enter quantities in the nails and wood category those rows transfer to Sheet 2 but when data is not entered into metal and screws those categories do not appear on Sheet 2.

Please let me know if this is possible. Thank you in advance

2 Replies

@Alysonfoster 

 

Yes, it's possible. Especially if you have the newest version of Excel. There's a function called FILTER that could be set up to extract only the items and values that you've identified for a specific job, and list them on a second sheet.

 

I've attached a simple demonstration.  If this doesn't work for you [you should be able to add to the master list and immediately see the results on the second, filtered list]....if that's not working, it means you don't have the most current Excel. Look into getting it. If you can't there are older ways of doing this, but this is so convenient, you should get it if at all possible.

A small demo Excel file with your project would be of great help for all of us ... especially for you