Consulting

Results 1 to 3 of 3

Thread: Moving rows from one spreadsheet to another

  1. #1
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    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.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,445
    Location
    Nothing attached.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    attachments

    Volume worksheet is attached and broker volume is on sheet one
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •