Thanks for your reply.
The problem with the copy paste solution is that I don't have all the values yet (they will get updated every day so the formula solution would be best).
Quote:
size of the source range and the first cell of your destination column
|
I'm not exactly sure what you mean. If you mean the range as in size then it will be between 1 and 10. The first cell of the destination column is "E9" if that's what you mean.
Cheers