Ihave a spreadsheet which is comparing the information on the spreadsheet to
another spreadsheet via an Array Formula, if the information can not be found
I am going to put No in a column. What i would like to be able to is to
transfer all the informatoon over 6 columns against all the items showing No
to another spreadsheet without sorting and to ttransfer the information on
the other sheet in the next available line, Can this be done

Yes it can be done, but you need to write a macro to do it!

"Freddo" wrote:

Ihave a spreadsheet which is comparing the information on the spreadsheet to
another spreadsheet via an Array Formula, if the information can not be found
I am going to put No in a column. What i would like to be able to is to
transfer all the informatoon over 6 columns against all the items showing No
to another spreadsheet without sorting and to ttransfer the information on
the other sheet in the next available line, Can this be done