Move line with specific val to new sheet even if the value appears on diff line each time.

Hello, I was wondering if anyone can help with the below issue.

I am trying to create a Macro that i need to run daily to take specific rows of data and move them to another sheet. I have recorded a macro and this worked the first time but since my data size varies each day, the references are not working the next time i run the macro.

Ex (i want to move row where the account = 2100 to a new sheet.) If i run this today, the account is on line 10 but when i run it tomomrrow it might be on line 18.

Eventually i will need to do this for multiple accounts but i wanted to get the feasability down for 1 account first.


Account
1000
2000
2100
3300
3301
3302

Thanks in advance

Try the following code. It assumes that the account numbers are in column A starting at row 2. It will prompt you to enter the account number.

Please Login or Register  to view this content.