Hi

I'd be grateful for any help on trying to do the following, please.
I've had a go at it myself, but am sort of getting lost. I've looked
in previous posts, and can't find one that addresses this exact
problem, and have found it hard putting together a macro from
different "bits". Basically, I need to be
able to do this:

1. Select from a range of criteria (eg cells in column D on Sheet1 are
not blank)
2. From the data that meets that criterion, copy/paste the cells from
particular columns from Sheet1 to the next blank worksheet
3. go back to step 1, but select a different criterion

If this is possible, I'd be grateful for some help.

Thanks very much, and apologies for cross-posting

Terry