Forum Discussion
Solved
Do a search/sort/sum in an excel workbook and put results in another workbook
I am not an in depth excel user. I am working with one excel file with multiple workbooks. In WORKBOOK1, i need to search COLUMN D for all values = to VALUE1. In each row with COLUMND = VALUE...
- Just pouring through this now...it is perfect, thank-you!! still playing with how i can expand etc. YOU ROCK
Do a little reading here to help understand the terms I used in that last message
https://exceljet.net/excel-tables
https://exceljet.net/glossary/named-range
https://exceljet.net/glossary/mixed-reference