I have a parameter sheets in which I specify different information:
Entry Key is the header column which have the key for the gap comparison between reference sheet and file-to-review sheet.
I have also specified in this sheet the Field to compare header columns that I want to compare based on the two sheets listed above. I include if necessary the position of the column and also the name of the column.
The objective is to compare and output the gap based on the field specified in the parameter sheet and ouput the lines which have values that don’t match between reference and file-to-compare sheet.
Ex : I have my Entry Key GID which have a value DD5894 available in the reference sheet and in file to review sheet.
The value of this Entry Key related to the column TtztuT (reference sheet) is equal to CLO and equal to LANC for ClBTing TtztuT( file-to-compare sheet) in that case the values don’t match as a result the macro should write this line in gap-result sheet specifying the two values.
The objective of specifying the entry key and the field to compare in the parameter table is to allows the macro to dynamically read the Entry Key and fields to compare specified in the parameter table, which means if I add an additional field to compare or if I change the Entry Key the macro should take into account this information specified in parameter.
It would be also great to make to write the count of inconsistencies in the parameter table based on the count lines of gap-result.
Please do not hesitate to contact me if you have questions or if you think there is a better way to organize the parameter sheet.
Thank you very much for your help.