Copy\Paste multiple criteria based rows to new sheet

Originally Posted by rylo

Hi

Do you mean the last 2 rows not columns? I've put in a heading that totals the last 2 rows and calls them external. Do you want a heading to specify these, and perhaps remove the first 2 rows which are used in the extract.

rylo

Sorry didnt got what u explained..but Yes last 2 columns ..one for SURREY HILLS & BIGGERA WATERS are external sites so they should appear under Externals...can this be accomplished plzz..??