Is there any efficent method for searching in a large excel sheet

Posted to microsoft.public.excel.programming

Eler Ocean Eler Ocean is offline

external usenet poster

Posts: 1

Is there any efficent method for searching in a large excel sheet

Hi,

I want to search an excel sheet of around 4000 records.Now I am using file
searching.

But for each data,searching will take around 10 sec.I want to search for
around 2000 records.Then it will take 2000*10sec=5 hrs.

Is database searching efficent than file searching or there is any other
method.

Please reply

Thanks,
Mlg

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Searching large excel files	mthakershi	Excel Discussion (Misc queries)	1	June 13th 07 06:31 PM
Most efficent code to copy a row on one sheet to a row on another	[email protected]	Excel Programming	1	October 27th 06 08:32 AM
searching a large database with a long list of search terms	[email protected]	Excel Discussion (Misc queries)	34	January 10th 06 06:23 AM
searching a large database with a long list of search terms	[email protected]	Excel Programming	32	January 10th 06 06:23 AM
searching sheets in large workbook?	sideout1010	Excel Programming	1	January 30th 04 03:47 AM

All times are GMT +1. The time now is 03:36 AM.

Menu

About Us