Finding data in Excel
 

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

Hi Riaan

Cannot remember Lotus, but are you talking about <Ctrl <F?

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

Yes, I want to use find data with two or more conditions.

"Kassie" wrote:

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

Have you tried Data|Autofilter?

"Riaan" wrote:

Yes, I want to use find data with two or more conditions.

"Kassie" wrote:

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

I want to use this function in a macro. Autofilter will not work.

"Kassie" wrote:

Have you tried Data|Autofilter?

"Riaan" wrote:

Yes, I want to use find data with two or more conditions.

"Kassie" wrote:

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?

To help you with a macro, I will need much more specific info. Maybe mail me
on

"Riaan" wrote:

I want to use this function in a macro. Autofilter will not work.

"Kassie" wrote:

Have you tried Data|Autofilter?

"Riaan" wrote:

Yes, I want to use find data with two or more conditions.

"Kassie" wrote:

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?