Paste text from one sheet to another

[geniusufo007]

in the attachment, the code paste only column A data in "MASTER" sheet from "CUSTOMERS" sheet in the relevant place
and then save it on "C:\common" with name in column A, i need to paste other columns
from "CUSTOMERS" sheet as well at the relevant place, in this connection I need help and additions in code.

[WideBoyDixon]

Add the lines in red to your code:

Please Login or Register  to view this content.

WBD

[geniusufo007]

Thanks Mr WideBoyDixon for your great help and solution