need copy data by the color

like here !

Subodh Tiwari (Neeraj)

Thanks for the fast response !!

Great Solution like always

i need to copy to other workbook
can be ?

Is the other workbook opened?
If yes, you can choose the destination cell in the other workbook as well by activating the other workbook and selecting the destination cell.

If the other workbook is not opened, the code will require a tweak provided you answer to the following queries...

1) What is the name and path of your other workbook i.e. the complete path?
2) Where do you want to paste the copied data in the other workbook i.e. on which sheet and in which cell?

Subodh Tiwari

1- could be an select file

so i can select the file as needed??

Yes that can be done.
But still you need to reply to the second query, which sheet and cell in the selected file then?

Subodh Tiwari (Neeraj)

HERE THE SOURCE FILE NEED BE COPY BY DATE
wktaSSS.xlsm

HERE THE DESTINATION FILE
MED_2.xlsx

BY DATE  IN THE DESTINATION
DATE IN THE DESTINATION IS IN ONE COLUMN

%  is the name of the area to paste the data

Sorry not getting it as it seems to be complex and will need much more time to make it work.

Subodh Tiwari

from the source file i need copy the yellow area to the destination file
the destination file date is  in one column so i need paste using the date as the reference

Great Job !