Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2001
    Location
    NJ
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reformatting a multi-page double column listing (excel 2000)

    Other than cut/paste,how can I take a 1201 row, 2 column table (columns A and [img]/forums/images/smilies/cool.gif[/img] with headings in the first column and reformat it into the following:
    headings in columns A, B copied to columns D, E, and G, H (columns C, F are empty)
    Data in rows 401 thru 801, columns A, B moved to rows 2 thru 401 of columns D, E
    Data in rows 801 thru 1201, columns A, B moved to rows 2 thru 401 of columns G, H

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: reformatting a multi-page double column listing (excel 2000)

    If you don't need to keep the original layout, then Cut and Paste is probably the best way to go. If you want to keep the original layout, then you could create a new sheet with links to the original. This can also be done with VBA, but it would take longer to write the VBA than use Cut and Paste if you only have to do it once. If you need to do it many times, let me know and I can give you the VBA (you can also record it).
    Legare Coleman

Posting Permissions

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