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
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
