Using currency converter - Please advise

asked 2017-07-15 14:49:25 +0200

VVHH gravatar image


I am using a currency converter.

Sheet 1 contains various currencies (USD, JPY, GBP, CAD, INR, CNY etc.) The value is taken from online sources.

Sheet 2 contains a number. There is another table with various currencies mentioned thereto. The values are calculated in different currencies grouped as per Date.

This data could be used to guess the pattern and create charts accordingly.

I am witnessing 2 problems

1. After linking data to external sources (Sheet 1) - it is updating fine. But, whenever the file is closed and re - opened, it stops refreshing the data.

2. Need macro tutorial to help me achieve what I want.

edit retag flag offensive close merge delete


Please provide an example document containing such links.

Regina gravatar imageRegina ( 2017-07-16 20:24:41 +0200 )edit