How to automate a 20 step process after importing data into Excel

For costing, I have to export a product Bill of Material (BOM) into excel. The export is not editable and needs to be altered. The alteration is a 20 step process of removing formatting, formatting cells, deleting blank cells, etc...

Is there any way to automate some of these tasks? I have to do this with every BOM and we have hundreds of them.

Attachment show raw export from database and final edit.

Thanks,

Eric

With this recorded macro.

See the attached file.

[CODESub Recorded_Macro()

Columns("F:J").Delete Shift:=xlToLeft

Rows("10:10").Select
Selection.Font.Bold = True
Selection.RowHeight = 24
With Selection.Font
.Size = 14
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Range("A1").Select
End Sub
]Please Login or Register to view this content.[/CODE]