Hello everyone, I would really appreciate your help with this. I have tried many various methods by using a nested for-loop which causes excel to hang, probably having too many cells to work with and I am almost clueless how to work with Arrays. This is just a sample of the project which up to 10-20 thousand cells.
Added Box Link
I have 4 Sheets: The first sheet is filled in by the Users, which Compares the values of A4 to B4; A5 to A6, etc.
The Remaining 3 sheets, comparing unique values based on the Project's Design to Columns. Example: ProjectA2 to ProjectA1's Design to Design, Koi to Koi.
The results only require what is removed or added with the column header.
Also, if a Design is removed or added, all subsequent compared columns are not required to be added. (Shown in Example ProjectE2 to ProjectE1)
Thank you very much!
Added Box Link
I have 4 Sheets: The first sheet is filled in by the Users, which Compares the values of A4 to B4; A5 to A6, etc.
The Remaining 3 sheets, comparing unique values based on the Project's Design to Columns. Example: ProjectA2 to ProjectA1's Design to Design, Koi to Koi.
The results only require what is removed or added with the column header.
Also, if a Design is removed or added, all subsequent compared columns are not required to be added. (Shown in Example ProjectE2 to ProjectE1)
Thank you very much!