Create sets of data (repetitive copy-paste)

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!

Here, try this:

Please Login or Register  to view this content.

option

Please Login or Register  to view this content.

Thank you very much zbor. This is the macro I need! However, I just need the minor problem comes when the parameters are not of the same numbers or values (i.e. 8 Location IDs, 6 Structure ID, 10 Biz codes).
The result shows blanks, and there's a case that not all biz codes will be reflected.
sample2.xlsm

works flawlessly! Thank you very much!