Loop through list of data and calculate values

I have a list of Currencies against the USD rate.

I basically want to loop through this data to calculate each currency against all the other currencies.

For example on the Input sheet I would want to work out the ANG rate against all other rates shown in the ExampleOutput sheet.

So ANG against ARS would be cell E2 divided by E3 and ANG against AUD would be cell E2 divided by E4.

I want to loop through all of this data before going to the next currency and starting again.

So in this example the next currency would be ARS and the first calculation I would want to do would be ARS against ANG so cell E3 divided by E2 before moving onto ARS against ANG (Cell E3 divided by E4) and so on..............

Is anyone able to help?

Thanks in advance

McC

This is the format I would recommend. A table style should make looking up rates much easier.

I need to loop through it and have it in that format so I can use the data to do a comparison against a similar set of data and then delete any that is not on the 2nd list.

Is anyone able to help?

Thanks