RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 166
- Office Version
- 365
- Platform
- Windows
Hello, help please!
I have a macro created to copy/paste data A-Q from one sheet to another. What I want to happen is after it pastes the data in A-Q, remove the duplicates from Column U and autofill/drag the formulas from V-X down. The last row with formulas in it will be different everytime the macro runs.
Ex. Right now the last row with formulas is row 7225. Tomorrow the last row of formulas might be 5430, and so on changing every day depending on the data.
Any thoughts?
I have a macro created to copy/paste data A-Q from one sheet to another. What I want to happen is after it pastes the data in A-Q, remove the duplicates from Column U and autofill/drag the formulas from V-X down. The last row with formulas in it will be different everytime the macro runs.
Ex. Right now the last row with formulas is row 7225. Tomorrow the last row of formulas might be 5430, and so on changing every day depending on the data.
Any thoughts?