Results 1 to 4 of 4

Thread: convert (2003)

  1. #1
    Lounger
    Join Date
    Feb 2004
    Location
    Romania
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    convert (2003)

    I have a file that looks like the one attached.
    I have a lot of information and i want that sheet1 to look like the sheet2. This I want to be done trough a macro if possible not manual.
    This is just a demo, because the whole excel file is around 25MB.

    Best regards,
    Marius
    Attached Files Attached Files

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

    Re: convert (2003)

    I recorded a macro then edited it heavily. Here is the result:

    Sub Macro1()
    Dim m As Long
    ' Get rid of the first row
    Range("A1").EntireRow.Delete
    ' Determine the last used row in column A
    m = Cells(Rows.Count, 1).End(xlUp).Row
    ' Delete the rows containing a blank in column A
    Range("A2:A" & m).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    End Sub

  3. #3
    Lounger
    Join Date
    Feb 2004
    Location
    Romania
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: convert (2003)

    Thanks, Hans.
    Is working perfectly.

    Is there a way to compare 2 sheets in the same workbook row by row. I have the sheets for each month and I need to compare quickly, were are the changes and which row are affected. The comparison is better to create a new sheet with differenced between the compared sheets
    The tables are exactly like the one presented in the excel sheet attached.

    regards,
    Marius

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

    Re: convert (2003)


Posting Permissions

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