Forum

How about if we reshuffle the data then applied the formula you illustrate ( ie can copy the formula) , a the drag and dropped action is very difficul...

Thanks Sunny , I tried it seems work out , but drag and dropped actions seems a very tediuos exercise , is there other simple way we can copy the f...

Thanks Sunny. I tried first to see if I can control

Sunny, you mean drag all highlighted boxes to the designated Cells ? But when I press Function key F2, boxes is hgihlighted , but can not drag to...

Sure, please refer the attached again as the material deliverd from the Vendors to our warehouse varies daily and from their packing list [ soft co...

Thanks Sunny, but how can the formuda extend to the rest of the column F. as delivered quantity is at random with reference to the material.

You are great no matter what Glass you wear you help always ..

I think no choice we have to tidy up our data before generate any sensible report.

Use macro delated all other unwanted sheets and save it new name with xlsm file type.

Thanks Sunny again, fully understood. You always have clever trick to get wise adn comprehensive solution for complication case.

Thanks Sunny. Yes, the formula fulfilled the requirment. Appreciate if you explain a bit the formula oyu used in the CF. =IFERROR(SEARCH("ttl",$...

Why ROWS can not be highlighted, ONLY COLUMNA "A" is Highlighted after applying CONDITIONAL formatting? Pls refer attached

I did try and works OK , tks Sunny..

Thanks Sunny will try this VB