I have a large spreadsheet with data which I need to extract data periodically.

Basically this will require pulling data based on a match of one or more
columns.

I typically use Access to do this and export the file later to be processed
using Excel.

Was wondering if there is some macro which can do this without having to use
Access.

Thanks in Advance

Michael Lew

You can click on DATA in the menu and select FILTER/AUTO FILTER. This puts a
combobox like button at the top of each column which you can use to filter
data on one or more colums, with one or more conditions.

I'm assuming that the first row of you Excel table has fieldnames, which
will be necessary for this function to work.

--
Kevin Backmann


"Michael" wrote:

I have a large spreadsheet with data which I need to extract data periodically.

Basically this will require pulling data based on a match of one or more
columns.

I typically use Access to do this and export the file later to be processed
using Excel.

Was wondering if there is some macro which can do this without having to use
Access.

Thanks in Advance

Michael Lew