I have a spreadsheet with a workbook for each job. Each workbook shows a list of materials needed. To make ordering them easier I would like these separate lists amalgamated into specific areas based on the supplier.
As the materials ordered are in a jumbled list the supplier name must be search on with an area and the results displayed in another sheet. Example attached.ExcelForum.xlsx