Recent content by paramveer

vletm Sir, its just sample files, i want 100 files to combine thats why i need shortcut method

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

bosco_yip Thanks sir this formula solve my problem Thank you very much

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 also want f2 match with chart A:A

Pls somebody help

Please suggest me formula. the result i want after matching three different data mention in file

thanks i dont think this

thanks sir for solving my problem

after match two combination answer increment given to next row mention in excel sheet thanks in advance

ok sir thanks

please help someone

in b2 you can use this formula =if(a2="","","Yes")

how can i retrieve data after eliminates blank column thanks in advance

ok sir thanks for your valuable suggestion