Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel to PowerPoint (2007)

    Hello,

    I have an MS Excel list of several hundred words (one word per cell) and what I would like to do is bring it over to PowerPoint where the contents of each cell appears on its own slide. So if I have 100 cells I need 100 slides. I did an export in Excel as a text file and that got me closer but each column in the text file appeared on each slide rather than each cell. If I could put the list into one column that would be one way. Thoughts?

    Thanks much,
    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel to PowerPoint (2007)

    Placing the words in a single column seems indeed to be the easiest way.

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to PowerPoint (2007)

    How can I get the list into a single column?

    Thanks,
    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel to PowerPoint (2007)

    If you need to do this only once, you can simply drag the filled cells in each column to column A, or cut and paste.

    If you will need to do this repeatedly, you might write a macro. If you would like help with that, please attach a small sample workbook.

  5. #5
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to PowerPoint (2007)

    If you wouldn't mind helping with the macro that would be great. Attached is a sampling of a list that needs to go into a single column.

    Thanks a million,
    Steve
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel to PowerPoint (2007)

    Try this:

    Sub MoveToSingleColumn()
    Dim m As Long
    Dim n As Long
    Dim c As Long
    Dim d As Long
    ' First free row in column A
    m = Cells(Rows.Count, 1).End(xlUp).Row + 1
    ' Last filled column
    d = Cells(1, Columns.Count).End(xlToLeft).Column
    ' Loop through columns
    For c = 2 To d
    ' Last filled row in column
    n = Cells(Rows.Count, c).End(xlUp).Row
    ' Cut column to column A
    Range(Cells(1, c), Cells(n, c)).Cut _
    Destination:=Cells(m, 1)
    ' Increment first free row
    m = m + n
    Next c
    ' Turn off copy mode
    Application.CutCopyMode = False
    ' Optional: sort column A
    Range(Cells(1, 1), Cells(m - 1, 1)).Sort Key1:=Cells(1, 1), _
    Header:=xlNo, Order1:=xlAscending, Orientation:=xlTopToBottom
    End Sub

    If you store this macro in the workbook itself, you'll have to save the workbook as a macro-enabled workbook (.xlsm).

  7. #7
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to PowerPoint (2007)

    This is Fantastic. Thank you very much Hans.

    Best to you,
    Steve

Posting Permissions

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