How do I create a formula to copy and paste between workbooks?

[Guest]

I would be grateful for any help with this. I am trying to scan one column
on a worksheet for a name e.g. Smith and then to copy all the information on
the same row into another workbook. There would be many rows with the name
Smith in that column and would like ALL of these rows to be copied into the
other workbook.

I saw the information posted by Bob Phillips on 10 Jan about programming
excel to do this but I do not understand how the formula would actually look.

Thanks a lot.

 

[Guest]

Easiest way is to put an autofilter on the top of the row heading:
Data>Filter>Autofilter:

then choose the name you want - then copy - paste.

Otherwise use a pivot table of the data area

 

[Guest]

Phil

Thanks for your reply. Unfortunately I am not permitted to change the order
of the rows, even temporarily. I was searching for an automated scan which
then copies and pastes the information as a result of the scan.

Thanks once again.