I need to know how to copy and paste ranges. As some who follow this board may know, I am attempting to combine a whole lot of old Amsterdam stock exchange info into one book. I got some good code from a kind poster here to create a list style calendar. Now I need some code to match the data up to the code generated calendar:
before:
1 1 1700 1 1 1700 1.048
1 2 1700 1 3 1700 1.056
1 3 1700 1 5 1700 1.036
1 4 1700 1 6 1700 1.056
1 5 1700 1 7 1700 1.076
1 6 1700 1 8 1700 1.046
1 7 1700 1 9 1700 1.050
1 8 1700
1 9 1700
after:
1 1 1700 1 1 1700 1.048
1 2 1700
1 3 1700 1 3 1700 1.056
1 4 1700
1 5 1700 1 5 1700 1.036
1 6 1700 1 6 1700 1.056
1 7 1700 1 7 1700 1.076
1 8 1700 1 8 1700 1.046
1 9 1700 1 9 1700 1.050
so it would be something like:
I think I need something like that anyway.
Thanks.
Bookmarks