Hi All,
I'm wondering if someone might be able to help me with a VBA script to populate the 'yellow' cells in the attached document.
Basically the script would search through the 5 sheets in the workbook and return all results in a single cell based on 3 criteria without duplicates.
To further complicate the matter, although the criteria is consistent, the columns are not. All gray cells are hard coded including the gray cells in the 'Result' tab.
Any help here would really be appreciated. I've had some success formulating this in excel, but it appears to be so slow it almost hangs up which is not practical. Each sheet will contain approximately 1,000 lines.
Thank you in advance.
Bookmarks