I am fairly inexperienced with VBA, so I'm having issues understanding exactly how to program two loops.

I have two charts (chart A and chart B) that I want to pull data from into a calculation sheet and then copy the output into the output sheet.

Chart A and B have entries in the vertical direction, that I need to compare in the calculation sheet in a 2 x 2 matrix. The first loop I need is for data to be pulled in the vertical direction from Chart B and placed in the calculation sheet, for one Chart A value (which I would also like to be automatically pulled from its respective sheet). The second loop I need is for when all of the Chart B entries are completed, VBA automatically moves on to the next Chart A value and repeat the process by comparing all the Chart B values. This needs to continue until all Chart A values (~6,000) have been compared to Chart B values (~160).

Finally, after each 2 x 2 matrix is solved, I need those values to be copied into the output sheet - so this could potentially be a third loop?

Thanks in advance!