move row of data to new tab when specific number entered in specific column

[kenboy]

Hello all. Looking for some guidance on a macro for the following:

Two tabs. 1)faClaims2 2)faClosedClaims.

Idea would be when number 3 is entered into column AD2 all data in row 2 would move to faClosedClaims.

I've attached the workbook if easier.

Thanks in advance.

[PCI]

Some questions
"when number 3 is entered into column AD2 all data in row 2 would move to faClosedClaims."
column AD2 on sheet "faClaims2"
all data in row 2 from A to AC are copied, column Reason is NOT

is it?

[PCI]

See next code

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try this to see if it does what you want.

[kenboy]

Hi Mr. Davis. This is great and works as I originally requested. Now would you be able to manipulate to where the 3 could be changed to a 2 and goes back to faClaims2?

Also, would you be willing to share your work for future projects?

Thanks again. Truly appreciated.

[kenboy]

PCI. Thanks for the quick reply and not to be disrespectful, but seems Mr. John Davis beat you to the punch.

Thanks again.

[JOHN H. DAVIS]

This is the code for Sheet1

Please Login or Register  to view this content.

For Sheet3 reverse it

Please Login or Register  to view this content.

[kenboy]

Awesome. It worked as expected. Promise this is the last question....

Why when I remove the preexisting numbers in column AD, the VB no longer works? assuming it was "If Target.Cells.Count > 1 Then Exit Sub", but guess not smart enough to figure it out

[JOHN H. DAVIS]

It means if you select more than one cell at a time the code will not work.

[kenboy]

Go figure. Your're an ace.

[kenboy]

Awesome. It worked as expected and wouldn't you know, I have one more.

What if I wanted to add another tab (faOpenClaims) and change the number system around?

ex.
faClaims2. enter 1 in column AD and data transfers to faOpenClaims.
Once complete in faOpenClaims, enter 2 in column AD and data transfers back to faClaims2.
Once complete in faClaims2, enter 3 in column AD and data transfers to faClosedClaims.