Moving rows from one spreadsheet to another
On the attached spreadsheets, i would like to be able to do the following:
On the Volume worksheet spreadsheet, i would like to replace column A with column E. Next i would like to be able to link this spreadsheet to the broker volume spreadsheet. For example, row a has broker AOCP. I would like to be able to move this row to the broker volume spreadsheet and have this row inserted in row under Angel Oak Capital in row 59. And of course I would like to have a macro that does this for each row in the spreadsheet.
Please help!
Thanks!
ONly one spreadsheet could be attached so the Broker volume spreadsheet is attached on the below post.
