After reading some very useful suggestions. I thought of posting my problem, hoping i'll find a solution
I have a workbook which has many sheets maybe 10-20, I need to look if in active sheet wherever in column B Project plan name is mentioned i need to copy its adjacent cell details to a new sheet. I need to keep checkin till end of sheet.
Also there's problem, how can i skip worksheets which does not have such entries.
But now problem is: i am unable to do it for all the sheets in the workbook
and secondly i need to loop through entire sheet only if next cell to project name is not blank then i need to copy its value else it should check in next sheet.
and i need to copy values of activecell's offset(-1,1) and(1,1) to new sheet