How do I copy a row depending on the content of a cell in the row
I have a report that has in column A codes for different facilities. I would
like to create worksheet in the workbook that copy the contents of the rows
from the master worksheet depending on the contents of the cell in Column A.
For example
A B C D
SFMC 17 22 44
MAMC 12 13 37
SFMC 19 30 70
From this report on worsheet 1 would like to have a formula in worksheet 2
that will copy the contents of any row in worksheet 1 that has SFMC in column
A.
I have tried the IF statement but I can only get it to copy the contents of
column A not the entire row.
thanks for any advice!
Bob
|