VBA To Transfer Data(value only).

[azmizarinah]

Whenever I change the date( in Sheet "B2JT"),the previously transfered data in sheet "DataKlm2" seems to dissapear only the current date data is available.
Example,
When I enter 2 in cell AS19 worksheet "B2JT" and than click the button "Transfer To Value Only DataKlm2"in worksheet "DataKlm" the data for date 1(cells E3,F3 and G3)dissapear.,only data for date 2 in cells H3,I3 and J3 is available.

Can you also help me to directly transfer data(value only) from worksheet "DataKlm" to worksheet "DataKlm2" without clicking on the "Transfer To Value Only DataKlm2" button.My source data base is in sheet "SUPCSAKLM",selection was done by clicking radio button and check boxes.

Please provide me the require VBA codes and guide me

Thanks