If Sheet 1 is a data entry sheet, can I use sheet 2 for summary based on a cell or row meeting certain criteria.
Ex. Sheet 1
Column A
Salesperson
Bob
John
Ben
Bob
Can I say if column A, sheet 1 = Bob then copy that entire row automatically into sheet 2 in a specific place? In this case it would copy rows 2 and 5 (salesperson is row 1)
How do I do that?
Thanks.
Ex. Sheet 1
Column A
Salesperson
Bob
John
Ben
Bob
Can I say if column A, sheet 1 = Bob then copy that entire row automatically into sheet 2 in a specific place? In this case it would copy rows 2 and 5 (salesperson is row 1)
How do I do that?
Thanks.