Extracting rows from a sheet depending on a category field

  • Thread starter Thread starter Nils Magnus
  • Start date Start date
N

Nils Magnus

Hello,

I have a large sheet with a simple data table with headers. Each item
has a column 'category'. I have another sheet on which I want to fetch
all items from a certain category - is this possible?

I come from a database background (as you might have noticed already),
and I don't have much experience with Excel. For those of you who
understand queries, I basically want to do a "SELECT FROM Sheet WHERE
Category = '...'" - but how do I do this?


Regards,
Nils Magnus
 
You can use a database query in Excel to do this. Save your spreadsheet and
open the sheet where you want to display the selected data. Click on
Data->Get External Data->New Database Query and then double-click on 'Excel
Files' in the Database section of the window. Select your spreadsheet and
click OK, you will now see the Microsoft Query window. Drag the column
headings you want to display to the area at the bottom of the window and then
click on Criteria -> Add Criteria to set the selection criteria. When you
have constructed the query you can close the query window and you will see a
window where you can select the cell to be used at the top left-hand corner
of the imported data (eg A1). When you click OK your data will be imported
and you can update it by clicking on Data -> Refresh Data or by clicking the
exclamation mark icon on the External Data toolbar (View->Toolbars->External
Data).

Andrea Jones
www.allaboutoffice.co.uk
 
Back
Top