file search with filters

cacker · May 15th, 2002, 09:49 AM

I desire to learn how to determine the following information:
 For n number of .xls files, list those files that contain numerical cell data on the same row as a cell with text data such as a noun.
 Sum the value of all cells that contain numerical data (no cells that contain formulas) that are on the same row as a cell with text data such as a noun.
Thank you.
Chuck

Asala42 · May 15th, 2002, 10:10 AM

G'day,

I believe you're going to have to go with a VBA solution here. Some questions to get this rolling:

Are the n number of files all in the same directory? Do these files have similar filenames? If so what is the pattern? Are the files formatted the same way (meaning is the appropriate data all in the same place on each file)?

Adam

KniteMare · May 15th, 2002, 10:29 AM

Are the files in question open or closed?

If Closed you are going to have to write a rather complex set of code which will be calling several .dll files. (The search function I am beginning to write does anyway!)

The "Where clause" you mentioned complicates things. ( where some row x contains text AND numeric information. but the information is random.)

If closed, do the files have any Characteristics you can scearch for to limit your choices?

Are you comfortable with code?

Yours in EXCELent Frustration
KniteMare

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 09:49 AM	#1
cacker New Member Join Date: May 2002 Posts: 1	I desire to learn how to determine the following information:  For n number of .xls files, list those files that contain numerical cell data on the same row as a cell with text data such as a noun.  Sum the value of all cells that contain numerical data (no cells that contain formulas) that are on the same row as a cell with text data such as a noun. Thank you. Chuck

May 15th, 2002, 10:10 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	G'day, I believe you're going to have to go with a VBA solution here. Some questions to get this rolling: Are the n number of files all in the same directory? Do these files have similar filenames? If so what is the pattern? Are the files formatted the same way (meaning is the appropriate data all in the same place on each file)? Adam

May 15th, 2002, 10:29 AM	#3
KniteMare Board Regular Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	Are the files in question open or closed? If Closed you are going to have to write a rather complex set of code which will be calling several .dll files. (The search function I am beginning to write does anyway!) The "Where clause" you mentioned complicates things. ( where some row x contains text AND numeric information. but the information is random.) If closed, do the files have any Characteristics you can scearch for to limit your choices? Are you comfortable with code? Yours in EXCELent Frustration KniteMare