Hi been looking for days but kind find what I am looking for.
I have a data sheet with all my bank transactions and would like to search in different columns.
Once found the multiple selctions I need to edit some of them.
Most dynamic filtering takes data from one sheet and search results are in another sheet but can't edit those results.
As an exemple I want to look for an amazon receipt of 25.08 in columns j and k.
J is debit k is credit.
Once all are found then I need to maybe change the column for expense category.
I can use the excel find but if there are many rows tedious to scrolling one by one.
I can filter column j but if the 25.08 was a credit it would be in column k so need to check back and forth.
Any ideas on how I can filter in 2 columns or all columns in data set and be able to edit those results ?
Thanks
I have a data sheet with all my bank transactions and would like to search in different columns.
Once found the multiple selctions I need to edit some of them.
Most dynamic filtering takes data from one sheet and search results are in another sheet but can't edit those results.
As an exemple I want to look for an amazon receipt of 25.08 in columns j and k.
J is debit k is credit.
Once all are found then I need to maybe change the column for expense category.
I can use the excel find but if there are many rows tedious to scrolling one by one.
I can filter column j but if the 25.08 was a credit it would be in column k so need to check back and forth.
Any ideas on how I can filter in 2 columns or all columns in data set and be able to edit those results ?
Thanks