I have 2 issues actually. I have a big database of items. I want to grab only certain fields , from only certain entries. Autofilter lets me only see the records that match my selection criteria, but all the fields are still there. For anyone that knows SQL, I want to basically do
SELECT name, description, level
WHERE type!='evil' AND sorc!=NULL
FROM SpellsList
Now a solution I tried was to filter out the ones I want, then copy them to a new sheet, and then reference the fields I want in a 3rd sheet. The problem with this is that some of the fields are quite long; lots of text, the description field for example. If I look at the database itself, I can see the full text in the “content box” near the top of the Calc window. But when I reference the db, that only shows the formula I used to reference the database. I could just delete all the fields I don’t want, but there are a lot of them, and that solution just isn’t all that elegant. Is there a better way to do everything I want?