consolidating

[joshdoc]

How do you this:

I have two excel worksheets with two different lists that have the sam
categories (the lists are identical, the data is not). I need a formul
or VBA to move a row of cells of sheet 1 when a condition is satisfie
to sheet 2 in the next available row of cells. Any help would b
appreciated. Thank you

 

[Dave Peterson]

Not quite sure what the conditions are, but maybe you could just apply
data|filter|autofilter.

Filter to show the rows with the criteria you want.

Copy those visible cells to the bottom of the data on the other worksheet.