I have been stumped by a problem, that I have created a mess of VB examples that nothing works and nothing is coming to mind, so I'm trying a clean slate to hopefully get some fresh perspective on my problem.
Visually here is what I want to happen in Excel. I have 2 variable length tables that I am attempting to combine into unique id numbers; through a VBA script.
Example.
Inputs:
Table 1 - ID Codes
AA
BB
Table 2 - Category
Red
Yellow
Black
White
Desired Results:
Copy Table 2 in it's entirety the # of Variables in Table 1, and then copy/paste Table 1 variables the # of times found in Table 2.
So it would look like. Currently I'm anticipating that Table 2 and Table 1 variables would be in separate columns.
Red-AA
Yellow-AA
Black-AA
White-AA
Red-BB
Yellow-BB
Black-BB
White-BB
Next time I run this, I may have 10 variables in Table 1, so creating a loop that counts the # of variables seems ideal.
Please forgive my newbie question. Any guidance / ideas?
Visually here is what I want to happen in Excel. I have 2 variable length tables that I am attempting to combine into unique id numbers; through a VBA script.
Example.
Inputs:
Table 1 - ID Codes
AA
BB
Table 2 - Category
Red
Yellow
Black
White
Desired Results:
Copy Table 2 in it's entirety the # of Variables in Table 1, and then copy/paste Table 1 variables the # of times found in Table 2.
So it would look like. Currently I'm anticipating that Table 2 and Table 1 variables would be in separate columns.
Red-AA
Yellow-AA
Black-AA
White-AA
Red-BB
Yellow-BB
Black-BB
White-BB
Next time I run this, I may have 10 variables in Table 1, so creating a loop that counts the # of variables seems ideal.
Please forgive my newbie question. Any guidance / ideas?