URGENT: Copy rows in Numbers using find tool keyword?

[pi6xjdskfa]

Hi,

I am looking through a XLS sheet of bank transactions and I would like to automatically select rows based on a keyword
under the Find tool in Numbers.

For example, I'd like to search for "ATM", highlight all transactions that have that keyword, and then copy and paste those
rows so I can get a separate sheet of just ATM transactions and total amount debited or credited?

The XLS sheet has rows with date of transaction, description, debit, credit, and balance.

I am looking through years of transactions and need to segregate different types of transactions with certain keywords.

If there is a better way please let me know.

Thanks.

 

[pi6xjdskfa]

Hi I found out conditional highlighting to highlight row with certain keyword match. How do I just copy the
data fields from highlighted rows to new spreadsheet?

I have about 30 rows highlighted with "ATM" keyword but cannot find way to copy entire row and column data. I can only copy description column since that contains the "ATM" keyword

 

[Slartibart]

I think the easiest is to just use the filter view, then select&copy.

 

[pi6xjdskfa]

Hi, I ended up finding a solution to the issue. I have dated transactions that needed to be tagged with a color and sorted into 10 different groups (for example, by keyword ATM) for each year. Every file is a years worth of bank transactions (from 2006-2022)

Using Conditional highlighting I was able to tag different transactions with different colors (e.g. green for ATM cash withdrawls) then I ended up using a sort (sort, sort selected rows, sort by: Column D(this was description of transaction) then descending (3.2.1...)

My question is: how do I apply the entered 10 conditional highlight rules to other number spreadsheets? I do not want to enter conditional highlights for 16 different spreadsheets).

Is there a template or method to copy and paste the conditional highlight rules to another numbers spreadsheet?

Thanks