hi
My sheet is macro enabled and some column is password protected i want to combine these file as examble given in picture. i use abebits and ktools for the same but not fulfill my requirement. Please somebody solve the issue
Sir,
i upload new sheet in which i asign colour to which i want to match with different sheet.
I want three Match
1) Name of Work (Comparitive F2 = Chart A3)
2) Name of Agency (Comparitive i7 = chart f6)
3) desricption of Item (Comparitive d10= chart b8:b20)
and desired result taken from chart...
Sir I want lowest tender rate given by firm come to First No and arrangement of Rest all the firms not a issue. Example given in excel sheet. Thanks for help to solve my problem.