Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Print Macro as one PDF file
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2012
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Print Macro as one PDF file

    Hello,

    I have a print macro in excel that prints multiple ranges in my file (roughly 100 pages). I tried to print as a PDF file, however it tries to save each page as a pdf and asks me to name each page. Is there a way for me to save/print all 100 pages a one batch file pdf? I don't believe Microsoft has this feature and it may need to be a macro vba code. Any suggestions?

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,059
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Print Macro as one PDF file

    please post your current print macro
    - click on # icon above post window first and then ...
    [ CODE ] paste your code inside the tags [ /CODE ]

    thanks

  3. #3
    New Member
    Join Date
    Aug 2012
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Print Macro as one PDF file

    Code:
            
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "smbrdrow"
            .PrintTitleColumns = "smbrdcol"
        End With
       
        Application.Goto Reference:="smtestp1A"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp1B"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp1C"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp1D"
        Selection.PrintOut
                          
        Application.Goto Reference:="smtestp2A"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp2B"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp2C"
        Selection.PrintOut
       
        Application.Goto Reference:="smtestp2D"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "smbrdrowftnt"
            '.PrintTitleColumns = "smbrdcol"
        End With
       
        Application.Goto Reference:="smftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "cwbrdrow"
            .PrintTitleColumns = "cwbrdcol"
        End With
        
        Application.Goto Reference:="cwtestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="cwtestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="cwtestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="cwtestp1d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "cwbrdrowftnt"
            '.PrintTitleColumns = "cwbrdcol"
        End With
       
        Application.Goto Reference:="cwftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
            
        With ActiveSheet.PageSetup
            .PrintTitleRows = "inbrdrow"
            .PrintTitleColumns = "inbrdcol"
        End With
       
        Application.Goto Reference:="intestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp1d"
        Selection.PrintOut
           
        Application.Goto Reference:="intestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="intestp2d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "inbrdrowftnt"
            '.PrintTitleColumns = "inbrdcol"
        End With
       
        Application.Goto Reference:="inftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "gpbrdrow"
            .PrintTitleColumns = "gpbrdcol"
        End With
       
         Application.Goto Reference:="gptestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp1d"
        Selection.PrintOut
          
        Application.Goto Reference:="gptestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp2d"
        Selection.PrintOut
           
        Application.Goto Reference:="gptestp3a"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp3b"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp3c"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp3d"
        Selection.PrintOut
          
        Application.Goto Reference:="gptestp4a"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp4b"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp4c"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp4d"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp5a"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp5b"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp5c"
        Selection.PrintOut
       
        Application.Goto Reference:="gptestp5d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "gpbrdrowftnt"
            '.PrintTitleColumns = "gpbrdcol"
        End With
       
        Application.Goto Reference:="gpftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="gpftntp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="gpftntp1c"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "adbrdrow"
            .PrintTitleColumns = "adbrdcol"
        End With
       
        Application.Goto Reference:="adtestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp1c"
        Selection.PrintOut
          
        Application.Goto Reference:="adtestp1d"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="adtestp2d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "adbrdrowftnt"
            '.PrintTitleColumns = "adbrdcol"
        End With
       
        Application.Goto Reference:="adftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="adftntp1b"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "msbrdrow"
            .PrintTitleColumns = "msbrdcol"
        End With
       
        Application.Goto Reference:="mstestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="mstestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="mstestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="mstestp1d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "msbrdrowftnt"
            '.PrintTitleColumns = "msbrdcol"
        End With
       
        Application.Goto Reference:="msftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "orbrdrow"
            .PrintTitleColumns = "orbrdcol"
        End With
       
        Application.Goto Reference:="ortestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp1d"
        Selection.PrintOut
      
        Application.Goto Reference:="ortestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp2d"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp3a"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp3b"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp3c"
        Selection.PrintOut
       
        Application.Goto Reference:="ortestp3d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "orbrdrowftnt"
            '.PrintTitleColumns = "orbrdcol"
        End With
       
        Application.Goto Reference:="orftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="orftntp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="orftntp1c"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "rvbrdrow"
            .PrintTitleColumns = "rvbrdcol"
        End With
       
        Application.Goto Reference:="rvtestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp1d"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp2d"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp3a"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp3b"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp3c"
        Selection.PrintOut
       
        Application.Goto Reference:="rvtestp3d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "rvbrdrowftnt"
            '.PrintTitleColumns = "rvbrdcol"
        End With
       
        Application.Goto Reference:="rvftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="rvftntp1b"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "ombrdrow"
            .PrintTitleColumns = "ombrdcol"
        End With
       
        Application.Goto Reference:="omtestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp1d"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp2d"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp3a"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp3b"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp3c"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp3d"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp4a"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp4b"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp4c"
        Selection.PrintOut
       
        Application.Goto Reference:="omtestp4d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "ombrdrowftnt"
            '.PrintTitleColumns = "ombrdcol"
        End With
       
        Application.Goto Reference:="omftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="omftntp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="omftntp1c"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "debrdrow"
            .PrintTitleColumns = "debrdcol"
        End With
       
        Application.Goto Reference:="detestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp1d"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp2a"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp2b"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp2c"
        Selection.PrintOut
       
        Application.Goto Reference:="detestp2d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "debrdrowftnt"
            '.PrintTitleColumns = "debrdcol"
        End With
       
        Application.Goto Reference:="deftntp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="deftntp1b"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "txbrdrow"
            .PrintTitleColumns = "txbrdcol"
        End With
       
        Application.Goto Reference:="txtestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="txtestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="txtestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="txtestp1d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "txbrdrowftnt"
            '.PrintTitleColumns = "txbrdcol"
        End With
       
        Application.Goto Reference:="txftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Format_for_Printing
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "albrdrow"
            .PrintTitleColumns = "albrdcol"
        End With
       
        Application.Goto Reference:="altestp1a"
        Selection.PrintOut
       
        Application.Goto Reference:="altestp1b"
        Selection.PrintOut
       
        Application.Goto Reference:="altestp1c"
        Selection.PrintOut
       
        Application.Goto Reference:="altestp1d"
        Selection.PrintOut
       
        Sheets("Notes").Select
       
        Format_for_Printing_Notes
       
        With ActiveSheet.PageSetup
            .PrintTitleRows = "albrdrowftnt"
            '.PrintTitleColumns = "albrdcol"
        End With
       
        Application.Goto Reference:="alftntp1a"
        Selection.PrintOut
       
        Sheets("MODEL").Select
       
        Range("MODEL!A1").Select
        
         End Sub
    Last edited by theanchorman; Jun 6th, 2019 at 11:19 AM.

  4. #4
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,059
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Print Macro as one PDF file

    1. One solution is to create 100 PDF files (autonamed by VBA from 00 to 99) and then combine them sequentially using 3rd party software
    - various programs available eg Adobe Acrobat (not Adobe Acrobat Reader)

    2. If the layout of each "page" is very similar consider using VBA to combine all ranges into ONE sheet which could then be saved as a multipage PDF

    3. Another option is to build a Word document from your ranges and save that as a multipage PDF using VBA - complexity depends on what your workbook contains!!

    4. Or auto-build a PowerPoint presentation fromt he ranges and save as a multipage PDF

  5. #5
    New Member
    Join Date
    Aug 2012
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Print Macro as one PDF file

    I like option 1. What would be the VBA code for that? Would I have to write the below code (for example) for each range name?

    Sub SaveAsA1()
    ThisFile = Range("A1").Value
    ActiveWorkbook.SaveAs Filename:=ThisFile
    End Sub
    Last edited by theanchorman; Jun 6th, 2019 at 01:59 PM.

  6. #6
    Board Regular
    Join Date
    Oct 2018
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Print Macro as one PDF file

    this should wotk for you. Found it on google.

    Code:
    Sub PrintAllSheetsToPDF()'SUBROUTINE: PrintAllSheetsToPDF
    'DEVELOPER: Ryan Wells
    'DESCRIPTION: Combine all your worksheets into one PDF
    Dim strSheets() As String
    Dim strfile As String
    Dim sh As Worksheet
    Dim icount As Integer
    Dim myfile As Variant
    'Save Chart Sheet names to an Array
    For Each sh In ActiveWorkbook.Worksheets
    If sh.Visible = xlSheetVisible Then
    ReDim Preserve strSheets(icount)
    strSheets(icount) = sh.Name
    icount = icount + 1
    End If
    Next sh
    If icount = 0 Then 'No charts found. Punch error
    MsgBox "A PDF cannot be created because no sheets were found.", , "No Sheets Found"
    Exit Sub
    End If
    'Prompt for save location
    strfile = "Sheets" & "_" _
    & Format(Now(), "yyyymmdd_hhmmss") _
    & ".pdf"
    strfile = ThisWorkbook.Path & "\" & strfile
    myfile = Application.GetSaveAsFilename _
    (InitialFileName:=strfile, _
    FileFilter:="PDF Files (*.pdf), *.pdf", _
    Title:="Select Folder and File Name to Save as PDF")
    If myfile <> "False" Then 'save as PDF
    ThisWorkbook.Sheets(strSheets).Select
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    myfile, Quality:=xlQualityStandard, IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, OpenAfterPublish:=True
    Else
    MsgBox "No File Selected. PDF will not be saved", vbOKOnly, "No File Selected"
    End If
    End Sub

  7. #7
    New Member
    Join Date
    Aug 2012
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Print Macro as one PDF file

    I believe I have used the code before. The Description at the top says "Combine all your worksheets into one PDF." All of my data is on one worksheet, but its printing many ranges. I need something that would combine all of the ranges into one PDF.

  8. #8
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,059
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Print Macro as one PDF file

    I like option 1. What would be the VBA code for that? Would I have to write the below code (for example) for each range name?
    Print each named ranges into separate PDFs like this
    - amend path constant and run

    Code:
    Sub Test()
    'variables
        Const path = "C:\Test\pdf\"             'include trailing \
        Dim nm As Variant, ws As Worksheet
        Set ws = ActiveSheet
    
    'loop named ranges
        For Each nm In Array("smtestp1A", "smtestp1B", "smtestp1C")
            ws.Range(nm).ExportAsFixedFormat Type:=xlTypePDF, Filename:=path & nm & ".pdf"
        Next nm
    End Sub

    Adapting your original code
    - hopefully you can loop (as above) for each of the ranges that share the same title rows and columns

    - otherwise could try replacing each pair of lines
    Code:
        Application.Goto Reference:="smtestp1A"
        Selection.PrintOut
    with
    Code:
       ActiveSheet.Range("smtestp1A").ExportAsFixedFormat Type:=xlTypePDF, Filename:=path & smtestp1A & ".pdf"
    I would amend the original print code first so that the named ranges are looped wherever possible BEFORE adapting to do the same for PDF export
    Last edited by Yongle; Jun 7th, 2019 at 04:07 AM.

  9. #9
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,059
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Print Macro as one PDF file

    The max edit time cut me off

    previous post cont ...

    I would amend the original print code first so that the named ranges are looped wherever possible BEFORE adapting to do the same for PDF export
    something like this for common ranges
    Code:
        Dim nm As Variant
        For Each nm In Array("smtestp1A", "smtestp1B", "smtestp1C")
            Application.Goto Reference:=nm
            Selection.PrintOut
        Next nm
    or simplify and avoid selecting ...
    Code:
        Dim nm As Variant
        For Each nm In Array("smtestp1A", "smtestp1B", "smtestp1C")
            ActiveSheet.Range(nm).PrintOut
        Next nm
    Last edited by Yongle; Jun 7th, 2019 at 04:14 AM.

  10. #10
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,059
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Print Macro as one PDF file

    COMBINING RANGES INTO A SINGLE SHEET WHICH IS PRINTED TO SINGLE PDF
    - method appropriate for ranges sharing common header rows etc

    Code:
    Sub Test()
    'variables
        Const path = "C:\Test\PDF\"     'end with \
        Dim nm  As Variant
        Dim r   As Long
        Dim sh  As Worksheet:       Set sh = ActiveSheet
    'create combo sheet with headers
        Dim ws  As Worksheet:       Set ws = Sheets.Add
        sh.Rows(1).Copy ws.Cells(1)
        ws.PageSetup.PrintTitleRows = "$1:$1"
    'loop named ranges
        For Each nm In Array("smtestp1A", "smtestp1B", "smtestp1C")
            r = ws.UsedRange.Rows.Count + 1
            If r <> 2 Then
                ws.Rows(r).PageBreak = xlPageBreakManual
                r = r + 1
            End If
            sh.Range(nm).Copy ws.Cells(r, 1)
        Next nm
    'save to PDF
        ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=path & "YourFileName" & ".pdf"
    End Sub

    With worksheet laid out as below, and named ranges specified as per coloured cells, the above code created a single PDF with one page for each named range

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    1
    Header1 Header2 Header3
    2
    3
    4
    a01 b01 c01 smtestp1A
    5
    a02 b02 c02
    6
    a03 b03 c03
    7
    a04 b04 c04
    8
    a05 b05 c05
    9
    a06 b06 c06
    10
    11
    12
    13
    a11 b11 c11 smtestp1B
    14
    a12 b12 c12
    15
    a13 b13 c13
    16
    a14 b14 c14
    17
    a15 b15 c15
    18
    a16 b16 c16
    19
    20
    21
    22
    a21 b22 c22 smtestp1C
    23
    a22 b23 c23
    24
    a23 b24 c24
    25
    a24 b25 c25
    26
    a25 b26 c26
    27
    a26 b27 c27
    28
    29
    Sheet: Data
    Last edited by Yongle; Jun 7th, 2019 at 04:37 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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