Sir, I think ISBLANK will be Ok. But I need to check whether there is any value in respective "B" cell before putting the "P". Also due some other reasons I cannot initiate any excel formulas in this main sheet. So requesting you to kindly provide me a macro for the same. thanks in advance sir.