Help Recreate Formatting with Macros

Step 1: Enable the Developer Tab

• Open Excel.
• Go to File > Options > Customize Ribbon.
• Check the Developer tab in the right panel and click OK.

Step 2: Record a Macro (Optional for Beginners)

• Go to the Developer tab and click Record Macro.
• Name your macro (e.g., FormatData), assign a shortcut key (optional), and choose where to store it (e.g., "This Workbook").
• Perform the formatting steps you want (e.g., adjust column widths, add borders, or apply cell styles).
• Stop the recording by clicking Stop Recording on the Developer tab.

Step 3: Write or Edit a Macro
For more control, write your macro in VBA (Visual Basic for Applications). Here's an example macro to format and organize a raw data file:

Sub FormatData()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets(1) ' Adjust for your sheet number or name

    ' Clear previous formatting
    ws.Cells.ClearFormats

    ' Apply Header Formatting
    With ws.Rows(1)
        .Font.Bold = True
        .Interior.Color = RGB(200, 200, 200) ' Gray background
        .HorizontalAlignment = xlCenter
    End With

    ' Auto-fit columns and rows
    ws.Columns.AutoFit
    ws.Rows.AutoFit

    ' Add Borders
    With ws.UsedRange.Borders
        .LineStyle = xlContinuous
        .Weight = xlThin
    End With

    ' Add Additional Formatting (Adjust as needed)
    ws.Columns("A:A").NumberFormat = "dd/mm/yyyy" ' Example: format Date column
    ws.Columns("B:B").NumberFormat = "0.00"      ' Example: format numeric data

    MsgBox "Formatting Complete!", vbInformation
End Sub

Step 4: Assign a Button to the Macro

• Go to the Developer tab, click Insert, and select a button (Form Control).
• Draw the button on your sheet.
• Assign the macro (e.g., FormatData) to the button.