ohuffman7
New Member
- Joined
- Jan 18, 2022
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
Trying to get my data to copy into a new sheet but i need the formulas to be copied as well. Any ideas?? Currently this just copies the cells' values.
Sub MoveData()
Sheet6.[Y1:Y1901].AutoFilter 1, "PASS"
Sheet6.[A1:Y1901].Copy Sheet2.[A1]
Sheet6.[A1].AutoFilter
End Sub
Sub MoveData()
Sheet6.[Y1:Y1901].AutoFilter 1, "PASS"
Sheet6.[A1:Y1901].Copy Sheet2.[A1]
Sheet6.[A1].AutoFilter
End Sub