Gregg Wolin
Member
I need a macro that will copy and offset data from a source table of cash flow streams where each column in the source table represents a different type of transaction.
A second source table establishes the timing and velocity (number of transactions that will be executed between various increments of months).
I would like the macro to randomly choose one of the columns from the transaction table and paste the data to a new matrix offsetting each additional project based on the timing table.
The attached file visually illustrates what I'd like to achieve.
Thanks in advance!
A second source table establishes the timing and velocity (number of transactions that will be executed between various increments of months).
I would like the macro to randomly choose one of the columns from the transaction table and paste the data to a new matrix offsetting each additional project based on the timing table.
The attached file visually illustrates what I'd like to achieve.
Thanks in advance!