+ Reply to Thread
Results 1 to 2 of 2

Simple formatting question

  1. 03-01-2011, 09:14 PM #1
    Sarah_88
    Sarah_88 is offline
    Registered User
    Join Date
    03-01-2011
    Location
    Atlanta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Simple formatting question

    Hello everyone,

    I am having trouble with something that I feel may have a very obvious solution. I have a table such as:

    Test1 85 90
    Test2 72 82
    Test3 45 47

    Which is basically 85 out of 90, 72 out of 82, etc and I want to use some sort of excel formula to format this to a layout where:

    Test1 (cell:A1)
    85(A2) 90(B2)

    Test2 (C1)
    72(C2) 82(D2)

    Test3 (E1)
    45(E2) 47(F2)

    Sorry for the awkward way I explained but my brain is getting fried and this is the easiest explanation I came up with.

    Thanks to anyone who understands why I'm trying to get at and for any help!

    -Sarah
    Reply With QuoteRegister To Reply
  2. 03-02-2011, 01:00 AM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Simple formatting question

    Hello Sarah,

    Welcome to the Forum!

    This macro will reformat the data as you described.

    Please Login or Register  to view this content.

    Adding the Macro
    1. Copy the macro above pressing the keys CTRL+C
    2. Open your workbook
    3. Press the keys ALT+F11 to open the Visual Basic Editor
    4. Press the keys ALT+I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Paste the code by pressing the keys CTRL+V
    7. Make any custom changes to the macro if needed at this time.
    8. Save the Macro by pressing the keys CTRL+S
    9. Press the keys ALT+Q to exit the Editor, and return to Excel.

    To Run the Macro...
    To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1