how to copy and paste..if a text is fixed in "a" colum..and related information is in d5

Your request is not clear!
The attached code works if you have complete blank row between all Rakesh' s regions.

hey i need like this

when i get Rakesh - BkCI

then i should get BCI ids in sheet3 A colum And Error % in B colum to respective id

example:B6F and #Div%l0!

same like above for this below mentioned

if Rakesh VIL

then i should get Vil ids in sheet3 c colum

if Rakesh - Dcpt

thein i should get Dcpt ids in Sheet3 e colum


if Rakesh - zoning

then i should get Zoning ids in Sheet3 g colum

If this is not what you want, I need to see a desired output.

Please attach a desired sample which clearly shows which data come from which sheet in put sheet and where they go in sheet output.

Here we go!

thanks a Lot man...dont we have any simple programming with out using offset function ..if we have please send me that program..so it would be a great help to me from u...

I do not know what do you mean by "simple programming" There is no such thing as simple programming ,as far as I am concerned. You may have alternative code, or approaching the issue differently. Try looping if that gives you a simple code.