Recent content by UCG

I was trying to extract data from another workbook and have them copied to specific column. I would like to have the message box to prompt the filter as in which period I would like to extract and for which type of invoice I would like to extract

Not quite sure what to dim here.. could you advice?

The line starts with response

Hi, could you please help me to look into the error: Sub CopyCols() Application.ScreenUpdating = False Dim srcWB As Workbook Set srcWB = ThisWorkbook Dim desWS As Worksheet Set desWS = Workbooks("CombinedData.xlsx").Sheets("Sheet1") desWS.UsedRange.ClearContents Dim...