Auto Population of a summary list

Tmini

New Member
Joined
Mar 22, 2014
Messages
25
Hi
I currently have a workbook that contains several sheets which has data relating to materials I require. I have one sheet that collects all of this data and will display a summary of the materials I require but currently I have it listing all of the materials for anything, even the ones I don't require, and it will put a figure next to the quantity I require and highlight that line so I can easily see what I require.
Is there a way of making it so I have a summarised list of only what is required rather than having a long list of unnecessary items?
The reason i ask is that I am going to be needing to add to the already long list and it will soon become far too much for me to display everything on one page

https://www.dropbox.com/s/wmogliwf3fyq6z9/A01 Testing.xlsx?dl=0

I have included a link of an example workbook just so you can get a better understand of what I require.

Any help will be greatly appreciated
Thanks
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Tmini

New Member
Joined
Mar 22, 2014
Messages
25
Hi just trying to find out whether my question is too confusing above or maybe it is just not possible to do
 

Watch MrExcel Video

Forum statistics

Threads
1,122,168
Messages
5,594,632
Members
413,919
Latest member
ZaxAlchemist

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top