Sorting, Cutting and Pasting from Multiple Worksheets

Mia A

New Member
Joined
Feb 21, 2006
Messages
29
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

moneytastesbad

Board Regular
Joined
Aug 28, 2006
Messages
106
Im pretty new to all of this too, but here is my suggestion.


If this is a task that you are going to have to do often, then I would start recording a macro, then go through the steps manualy. Then you can open the macro up in VBE and clean it up a little.

You will be supprised at how much you can learn by using the macro recorder to show you the code for a task.
 

Forum statistics

Threads
1,136,878
Messages
5,678,305
Members
419,753
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top