Hi All, i'm trying to create a function in a spreadsheet and not sure on the best way to do it:

I have a list which contains some data on sheet 1. On sheet 2, I want to create a search box that looks at the data on sheet 1, once ive search for it and clicked on the item I want, I want it to copy that row of data onto sheet 2 below the search box into a 'selected print area' then have the option to clear the search bar and search for another item. I could end up with as many as 10 line of data on my 'printable area'.

I hope somebody can help and point me in the right direction.


TIA