Hey Guys,
I have the following task to provide a solution.
In my Source sheet, i have different crypto-currencies, with a special format for the price in Euro and US$ for each month. The sheet gets updated ones a month filling the last month. Then the new data needs to be added to the target sheet Exchange Rate column at the end, making the table bigger everytime. But i want to have a solution where only the new data is added up to the target sheet so that there is no possibility to double any data. Moreover, as you can see in the other columns in the target sheet, i need the column "Cl.";"RT" and "RF" to be filled with the same value all the time. The Column "ValidFrom" should show the last day of the month before. The Column "ExRt" should be the Currency EUR or US$ due to the source sheet.
I really hope you guys know what im looking for! Thanks a lot !
I have the following task to provide a solution.
In my Source sheet, i have different crypto-currencies, with a special format for the price in Euro and US$ for each month. The sheet gets updated ones a month filling the last month. Then the new data needs to be added to the target sheet Exchange Rate column at the end, making the table bigger everytime. But i want to have a solution where only the new data is added up to the target sheet so that there is no possibility to double any data. Moreover, as you can see in the other columns in the target sheet, i need the column "Cl.";"RT" and "RF" to be filled with the same value all the time. The Column "ValidFrom" should show the last day of the month before. The Column "ExRt" should be the Currency EUR or US$ due to the source sheet.
I really hope you guys know what im looking for! Thanks a lot !
