sample.xlsm

Hello,

Macro novice here, have work mostly on basic copy-paste codes but not the complex ones.

Been working on a working file with several parameters and would need to create several sets on the results sheet.

For example, I want to see on the result sheet, for each location:
1) Each "structure" code has to be assigned with each "Biz" code (so let's say one structure ID has a counterpart of 5 "Biz" codes.

Please see example result in the file's "results" sheet.

This has to be done for all locations so I was wondering how a code can be applied to this.

Thanks in advance!