SOLVED

Taking selected info from one sheet and making a new sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1385293%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20selected%20info%20from%20one%20sheet%20and%20making%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F665788%22%20target%3D%22_blank%22%3E%40MickCox%3C%2FA%3E%26nbsp%3Bto%20seek%20further%20clarity%2C%3C%2FP%3E%3CP%3Eso%20u%20have%20a%20load%20of%20data%2C%20pretty%20detailed.%3CBR%20%2F%3EAnd%20u%20want%20to%20summarize%20the%20data%20for%20each%20inventory%20item%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20my%20understanding%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385323%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20selected%20info%20from%20one%20sheet%20and%20making%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385323%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20only%20want%20to%20output%20the%20data%20where%20there%20is%20an%20entry%20for%20a%20quantity%20of%20an%20item%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20while%20there%20are%20lots%20of%20items%20within%20the%20survey%20list%2C%20I%20will%20only%20need%20to%20make%20a%20new%20sheet%20with%20the%20items%20chosen%20on%20the%20survey%20sheet%20for%20that%20particular%20client.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20info%20I%20will%20want%20to%20output%20to%20the%20new%20sheet%20will%20be%20the%20quantity%20we%20have%20entered%20and%20the%20name%20of%20the%20item%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20the%20new%20sheet%20will%20also%20assign%20an%20inventory%20number%20and%20have%20a%20tick%20box%20to%20confirm%20that%20the%20item%20has%20been%20loaded.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385464%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20selected%20info%20from%20one%20sheet%20and%20making%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F665788%22%20target%3D%22_blank%22%3E%40MickCox%3C%2FA%3E%26nbsp%3Byou%20can%20use%20%22Pivot%20Table%22%20under%20excel%20for%20your%20problem.%3C%2FP%3E%3CP%3EYou%20can%20search%20it%20on%20YouTube%2C%20u%20will%20find%20many%20quick%20tutorials%20around%20it.%3C%2FP%3E%3CP%3EFor%20temporary%20solution%2C%20you%20can%20share%20the%20file%20and%20I%20can%20help%20you%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385512%22%20slang%3D%22en-US%22%3ERe%3A%20Taking%20selected%20info%20from%20one%20sheet%20and%20making%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385512%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%2C%20I%20have%20shared%20the%20file%20for%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385134%22%20slang%3D%22en-US%22%3ETaking%20selected%20info%20from%20one%20sheet%20and%20making%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385134%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3EI%20just%20want%20to%20know%20if%20what%20I%20am%20thinking%20is%20possible%20with%20Excel.%3C%2FP%3E%3CP%3EI%20work%20in%20a%20removals%20company%20and%20we%20have%20an%20excel%20survey%20sheet%20with%20lots%20of%20household%20items%2C%20and%2C%20for%20each%20customer%2C%20we%20mark%20off%20the%20number%20of%20each%20item.%20This%20then%20works%20out%20a%20volume%20for%20pricing.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20extract%20the%20info%20we%20have%20entered%20and%20make%20a%20new%20sheet%20with%20that%20info%3F%20This%20will%20then%20be%20the%20basis%20of%20an%20inventory%20list%20for%20when%20we%20arrive%20at%20the%20property%20to%20load%3F%3C%2FP%3E%3CP%3EThis%20will%20save%20us%20having%20to%20write%20out%20an%20inventory%20list%20and%20also%20check%20that%20the%20client%20hasn't%20added%20any%20items%20without%20us%20knowing.%3C%2FP%3E%3CP%3EHope%20I%20have%20explained%20clearly%20enough.%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1385134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi There,

I just want to know if what I am thinking is possible with Excel.

I work in a removals company and we have an excel survey sheet with lots of household items, and, for each customer, we mark off the number of each item. This then works out a volume for pricing.

Is it possible to extract the info we have entered and make a new sheet with that info? This will then be the basis of an inventory list for when we arrive at the property to load?

This will save us having to write out an inventory list and also check that the client hasn't added any items without us knowing.

Hope I have explained clearly enough.

Thanks for your help.

3 Replies
Highlighted

@MickCox to seek further clarity,

so u have a load of data, pretty detailed.
And u want to summarize the data for each inventory item?

 

Is my understanding correct?

Highlighted

@bhushan_z 

Thanks for your question.

 

I really only want to output the data where there is an entry for a quantity of an item,

 

So while there are lots of items within the survey list, I will only need to make a new sheet with the items chosen on the survey sheet for that particular client.

 

The only info I will want to output to the new sheet will be the quantity we have entered and the name of the item 

 

Then the new sheet will also assign an inventory number and have a tick box to confirm that the item has been loaded.

Highlighted
Best Response confirmed by MickCox (New Contributor)
Solution

@MickCox you can use "Pivot Table" under excel for your problem.

You can search it on YouTube, u will find many quick tutorials around it.

For temporary solution, you can share the file and I can help you out.