Transferring Information

[Guest]

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

 

[Guest]

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