vba transfer data from multiple columns into one column in another sheet (really need your help!) Thank you :)

[karlm98]

Hey Guys,
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 !

 

[Peter_SSs]

Duplicate to: convert data from multiple columns into one column at the end of a table in another sheet vba

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.