|I have looked at both files, as well as the notes in the file. There are a few things that are not clear to me.|
re: "The requirement is to copy data from cell range 'A4' TO 'J20' of this sheet 'SOURCE' to destination file. "
When I look at the Destination file, I do not see the data from Column B:C or F:G of the SOURCE file. Does that mean that the data to be copy is actually from A4:A20, D4:E20 and H4:J20, not A4:J20?
re: "If we can select the data range by use of mouse would be really helpful"
If you have already specified the range to be copied, why does the data need to be selected with the mouse? Are you saying that it won't always be A4:A20, D4:E20 and H4:J20?
re: "If Possible, Value For Column 'A' And 'C' To Be Asked To The User At The Time Of Copying Data From Source File."
I assume this means that you want to present an InputBox to the user, at which time they will enter the values that should be placed A4:A20 and C4:C20 of the Destination
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.