Please help!
I want use a vba script or macro to copy a range of celsl from one column into another column. Thus, these columns do not have the same size

Situation:
I download on a daily basis end-of-day data from various markets into two columns (date, price). I download a fixed period of time, 15 years. But because the number of trading days vary, i get a column with variable length.
To assure that all my calculations in other worksheets are executed in the right way, I need a FIXED amount of data. Therefore I download more calendar days then I actually need and then I need to copy a fixed number of cells (3850) into a another column. This range has to end with the last available date and must include the previous 3850 cells.

How can I make this work?
Any help would be much appreciated. Thanks