Hi All,
Please help me out of this i having this to do every day....
i have attached the excel file, from that excel file i need to search the text "Pool" where ever the text, it contains other text also
eg:= Pool = D0BM BC L P LTD
from the above example i need to copy the DOMB BC L P LTD and copy this and a coumn below befor product code (Plz find the attached) and the pool name and concatenate the product code with the pool name
this will loop up next "Pool"