I am writing a macro to create individualized workbooks based on filtering a specific field, but when it copies and pastes the data it is referencing the original file, which obviously won't work since when we email the new workbooks to these individuals they will not have the original file open. How do I paste a range such that the formulas paste "as is" without references?
'3-Order Data
Workbooks(orgwb).Sheets("3-Order Data").Activate
col = 17
ActiveSheet.AutoFilterMode = False
ActiveSheet.Columns("A:X").AutoFilter Field:=col, Criteria1:=DM
ActiveSheet.AutoFilter.Range.Copy
Windows(DMFileName).Activate
Sheets("Sheet4").Paste
Sheets("Sheet4").Cells.EntireColumn.AutoFit
Sheets("Sheet4").Name = "3-Order Data"
Sheets("3-Order Data").Tab.Color = vbGreen
Sheets("3-Order Data").Visible = xlSheetHidden
Bookmarks