Not exactly what I'm looking to do...I need to select and copy the values of
columns "D, E, F" as long as the value of column "G" remains the same.
When the value of column "G" changes I need to paste the selected records
into a range on the next sheet. Each time the range on the next sheet will be
different.

"ambushsinger" wrote:

I have data separated in groups. The last column is the qualifier, call it
column G.
Each time the value of column G changes I need to copy that group of data to
another worksheet and then go back to the original worksheet to do it again
until it's finished.
any ideas?