Hi
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.