Hi,
I am not sure whether I am understanding the problem correctly. What I
have understood is that you have a spreadsheet where a certain column
contains either 'Expert' or 'Equipment' in its rows, and you are trying to
put the rows where that column contains 'Equipment' in one sheet and the ones
where that column contains 'Expert' in another sheet.
If I am right, a non-programmatic approach to the problem would be to
sort the spreadsheet by the column containing 'Expert'/'Equipment', and then
to copy and paste the Expert and Equipment sections to sheets 2 and 3
respectively.
If you want to restore the rows to their original order, create a
helper column containing a running index, 1,2,3.......n, before sorting and
distributing the info to sheets 2 and 3. Now you can restore sheet 1 to its
original format by sorting by the helper column (and getting rid of the
helper column).
Regards,
B.R.Ramachandran