View Single Post
 
Old 06-05-2019, 07:18 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

How it may be done with Excel:
You have a table where all items/reciepes/whatever are registered, along with fields for search criterions. Going with your example - ReciepeName, Country, Type, Class, ...;
Then in another table you have details for those items/reciepes/whatever registered (e.g. Reciepe, Ingridient, Quantity);
You also need a separate tables for every search criterion from 1st table - so you can use data validation lists for entering data into 1st table, and for setting report criterions.
Then in separate sheet you can select criterion values. And on same sheet, or in some hidden one you need a table, where a list of items/reciepes/whatever matching selected criterions from 1st sheet is generated (worksheet formulas will do nicely);
On same sheet where you did set criterions for report, you can also select a item/reciepe/whatever from this generated list (Data Validation again). Based on this last selection, the report is generated (e.g. the name of reciepe, and below it the list of ingridents and their quantities).
Reply With Quote