Macro to copy specific items in a column

[Howardc1001]

where there is text "Sale" in Col b on sheet1, I want to copy the items from Col A : Col D and paste on sheet


I have tried to write code to do this, it cannot get a run time error "Method of range of object_Global failed"


this part is highlighted when getting the run time error

Please Login or Register  to view this content.

See full code below

Please Login or Register  to view this content.

[JLGWhiz]

Change the period to a comma before the second Cells.

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help. Only one item is being copied. I have highlighted 3 items in yellow containing sale in the text that is to be copied

Please Login or Register  to view this content.

kindly test & amend

[jolivanes]

Maybe try something like this. Not tested.

Please Login or Register  to view this content.

[Howardc1001]

Thanks Jolivanes

Code works 100%

[jolivanes]

Thanks for letting us know that all is well in SA.
Good luck