I have a master spreadsheet that changes everytime it is updated, and it
contains 5 columns of information. In a new spreadsheet i want to be able to
search for one column for a specific bit of information, and when found it
will copy the whole row of information ? Is this possible ? Or do i need to
enter different formula's in each column of the new spreadsheet ? Any help
would be appreciated.