Match & copy specific ranges for each name to bottom based on cell value

[abdo M]

Hello
in LASTROW sheet into H2 cell I write the customer name should match with column C for SPLITTING sheet if they're matched then will brings the range is relating of the customer name as the example in RESULT1 sheet .if I write another customer name then will copy to the bottom as in RESULT2 sheet .
if I write wrong name in H2 in lastrow sheet (the name is not existed in SPLITTING sheet) then pops message "the name is not available" and exit sub without do anything and if I write the same name has already existed then should pops message "the range for this name is already existed" and exit sub without do anything and if the H2 cell is empty then should delete all of ranges are existed in LASTROW sheet .
thanks

[kvsrinivasamurthy]

Try. I have changed the name of the sheet "LASTROW" as "SEARCH_NAME"
\

Please Login or Register  to view this content.

[abdo M]

thanks, but still remain this

if the H2 cell is empty then should delete all of ranges are existed in LASTROW sheet .

when there is no any name in H2 I want deletion all of ranges have already existed in SEARCH_NAME

[kvsrinivasamurthy]

Code modified.

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[abdo M]

excellent !
thank you so much , guys!

[sintek]

..............................
THANKS.gif