If Than Statements over mulitple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2646838%22%20slang%3D%22en-US%22%3EIf%20Than%20Statements%20over%20mulitple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646838%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20If%2FThen%20statements%20(I%20think)%20that%20will%20look%20like%20this....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Column%20R%20%3D%2058730%20or%2058765%20or%2058833%20then%20copy%20the%20entire%20row%20to%20sheet%20Divide%20County.%3C%2FP%3E%3CP%3EIf%20Column%20R%20%3D%2058757%20or%2058831%20or%2058838%20then%20copy%20the%20entire%20row%20to%20sheet%20McKenzie%20County.%3C%2FP%3E%3CP%3EIf%20Column%20R%20%3D%2058801%20or%2058830%20or%2058849%20then%20copy%20entire%20row%20to%20next%20available%20row%20on%20Sheet%20Williams%20County.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Column%20Q%20%3D%20ND%20then%20copy%20entire%20row%20to%20next%20available%20row%20on%20sheet%20ND%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20there%20is%20a%20better%20formula%20to%20use%20for%20this%3F%3F%3F%3C%2FP%3E%3CP%3EThanks!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2646838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647923%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Than%20Statements%20over%20mulitple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1127977%22%20target%3D%22_blank%22%3E%40cyrenaweeks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20advanced%20filter%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FVqQACB_69SQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FVqQACB_69SQ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need If/Then statements (I think) that will look like this....

 

If Column R = 58730 or 58765 or 58833 then copy the entire row to sheet Divide County.

If Column R = 58757 or 58831 or 58838 then copy the entire row to sheet McKenzie County.

If Column R = 58801 or 58830 or 58849 then copy entire row to next available row on Sheet Williams County.

 

If Column Q = ND then copy entire row to next available row on sheet ND

 

Maybe there is a better formula to use for this???

Thanks!!!

1 Reply

@cyrenaweeks 

 

Use advanced filter:

https://youtu.be/VqQACB_69SQ

 

 

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentialsHow does Advanced Filter work in Excel? In this quick tutorial I show ...