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