Hello Excel Masters,
Firstly I apologize if I am asking too many requirements in this thread for a single operation.
Please find attached document having the requirements indicated below:
1) There are two spreadsheets, Sheet1 having inputs while Sheet2 having outputs.
2) Sheet2 has Index match multiple criteria with excel formula until the last row of the reference column.
3) Spreadsheet name & columns are dynamic in nature.
The number of rows are exceeding more than 20,000+, hence it is becoming cumbersome to use excel formula leading to high file size and as well as Excel document is hanging by consuming too much of time.
Henceforth it's my request to help me in performing this operation via VBA. I hope it is feasible.
Thanks for your time & support in advance.