So I have a spread sheet called Strategies/Benchmarks that accross the top starting in B1 has benchmarks and different strategies and below each of them has there rate of return starting in the corresponding month. In column A2 going all the way down I have dates. All the stategies and bench marks start at different times. I want to write a macro that starts in B1 takes the stategy/benchmark name and assigns it a specific number that I have on a driver sheet called driver inside the Strategies/Benchmarks spreadsheet(Below you can see an example). Then in the same column go down until you find the first rate of return and copy all the data until the last rate of return. (Remember all benchmarks/strategies dont start in same month/year.) Next you would want to take that stream of data, open a new spread sheet "abc" and copy it into Column C cell 1. After that we would want the correspongding date range copied into column B cell 1. The last thing I would want to do in spread sheet ABC is put the assigned number to the strategy/benchmark and copy in colum A cell 1 all the way down till the data stops.
The Driver page looks like this
Strategy Corresponding number
A 1
B 2
C 3
I am new to VBA and need some help.
The Driver page looks like this
Strategy Corresponding number
A 1
B 2
C 3
I am new to VBA and need some help.
