PDA

View Full Version : Moving rows from one spreadsheet to another



Klartigue
09-08-2011, 08:03 AM
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.

Bob Phillips
09-08-2011, 09:37 AM
Nothing attached.

Klartigue
09-08-2011, 09:49 AM
Volume worksheet is attached and broker volume is on sheet one