cut and paste particular data rows into next sheet if column A:A contains total vba

[julielara]

Dear experts

I have bulk data in sheet datasummary In column A:A which is contains text "Total" along with code
i want cut and paste value where ever find Total that row should move to sheet "updatedata"

please find the attachment

[stnkynts]

Try this:

Please Login or Register  to view this content.

[julielara]

Thanks experts its works amazingly!!