See reply in .Misc

Biff

"gloss" wrote in message
...
Hi

Does anyone have any idea how I can do a search and extract data from a
sparate worksheet

for example

search ("smi*", 'anotherWorksheet.xls'!Users)

does not recurse through the column in the second worksheet

what am i doing wrong?

Any help is much appreciated