LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gloss
 
Posts: n/a
Default Search using multiple worksheet

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combine multiple excel file in to one excel file and multiple worksheet jbhoop Excel Discussion (Misc queries) 1 December 30th 05 09:31 PM
combine multiple excel file in to one excel file and multiple worksheet jbhoop Excel Discussion (Misc queries) 0 December 29th 05 04:59 PM
How do I search excel spreadsheets using multiple search criteria. Kasper Excel Worksheet Functions 4 December 15th 05 12:26 AM
Search a worksheet, extract rows using a list from another sheet bobf Excel Discussion (Misc queries) 9 August 31st 05 04:56 AM
Multiple worksheet master Tuc Excel Discussion (Misc queries) 1 May 31st 05 06:56 AM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"