Excel VBA Macro: Autofilter And Copy to New Workbook (Dynamic Range). In this video, we go over how to automatically copy and paste filtered data from one workbook to a new workbook. We then save the new workbook based on a cell value that we used to filter the data. We also go over how to handle overwriting data when saving. One way is to use Application.DisplayAlerts = False/True to avoid the issue all together and have the macro always overwrite the existing workbook. The other way is to use On Error Resume Next to handle an error caused when the user selects "No" when asked to overwrite data.
Data used in this video:
https://gsociology.icaap.org/dataupload.html
#ExcelVBA #ExcelMacro