0
I know i am not perfect but what i can do to optmise my code is below.
Option Explicit
Sub new_comment()
'Coded by Vij, Atul (Contractor)'
Dim MainWB As Workbook
Dim ws, wsnew, ds, SapDataWS, AutoBlImp As Worksheet
Dim lastRow, iLeft As Long
Dim a, b, i, Filename, updatesheet, strFile As String...