none
excel if then formula/macro RRS feed

  • Question

  • I need a simplified if/then formula. Sheet one contains all information and cell J2 has 1 of 8 clerk names. If J2 = Chris then I need to copy the only specified cells in that row to the sheet named "Chris". If J2= Rick then copy only the specifed cells in that row to  the sheet named "Rick" and so on for all 8 clerks.

    Thank You!

    Wednesday, October 19, 2011 4:53 PM

Answers

  • I need a simplified if/then formula. Sheet one contains all information and cell J2 has 1 of 8 clerk names. If J2 = Chris then I need to copy the only specified cells in that row to the sheet named "Chris". If J2= Rick then copy only the specifed cells in that row to  the sheet named "Rick" and so on for all 8 clerks.

    Thank You!


    Check out Excel help for the VLOOKUP function.
    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present
    Wednesday, October 19, 2011 5:25 PM