I have a workbook with 5 worksheets in it. Column F on each worksheet is titled "Policy?" and I put a "Y" whenever I come across a policy.
How do I:
Sort all the worksheets simultaneously to find all the rows with "Y"?
Copy and paste the row marked with "Y"s into a fresh worksheet?
I don't want to go back into each individual worksheet. Is there an IF function I could use to pull it all together?
Thanks to anyone who replies,
Mia
How do I:
Sort all the worksheets simultaneously to find all the rows with "Y"?
Copy and paste the row marked with "Y"s into a fresh worksheet?
I don't want to go back into each individual worksheet. Is there an IF function I could use to pull it all together?
Thanks to anyone who replies,
Mia