Copy value only if condition meet
Closed
azmiismail
Posts
17
Registration date
Thursday March 3, 2011
Status
Member
Last seen
July 20, 2011
-
Jun 14, 2011 at 06:05 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2011 at 09:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2011 at 09:46 PM
Related:
- Copy value only if condition meet
- Google meet download for pc - Download - Video calls
- Available memory less than 15mb condition zero - Guide
- If condition in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Google meet camera not working - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 14, 2011 at 05:24 PM
Jun 14, 2011 at 05:24 PM
Could you post some sample file on some shared site and then post back the link to the file back here
azmiismail
Posts
17
Registration date
Thursday March 3, 2011
Status
Member
Last seen
July 20, 2011
Jun 15, 2011 at 09:51 AM
Jun 15, 2011 at 09:51 AM
https://authentification.site/files/28987248/eFforT_NewTest-2.xls
I able to solve part of the problem,but another problem had occuer.That is 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 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.
Thanks .
I able to solve part of the problem,but another problem had occuer.That is 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 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.
Thanks .
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 15, 2011 at 11:10 AM
Jun 15, 2011 at 11:10 AM
Sorry Azmi, I am not able to access Speedyshare. Could you post it to http://wikisend.com/ too and post back the link. I am sorry, I should have told u that in the first place.
azmiismail
Posts
17
Registration date
Thursday March 3, 2011
Status
Member
Last seen
July 20, 2011
Jun 15, 2011 at 06:55 PM
Jun 15, 2011 at 06:55 PM
It seem to be that I'm having problem with wikisend.HTTP 500 Internal Server Error had occuered.Is there any other share site which I can post the link?
Thanks
Thanks
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 15, 2011 at 08:19 PM
Jun 15, 2011 at 08:19 PM
I was able to download your file. Before even addressing your issue, I have a question. I see you have a lot and I mean a lot of modules. Is there any reason that each module has just one routine ?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 15, 2011 at 09:46 PM
Jun 15, 2011 at 09:46 PM
Looking at the macro that is associated with your button "Transfer To Value Only DataKlm2" on sheet "DataKlm", basically it copies data in range B3:CS22 from sheet "DataKlm" and then paste it in range "C4:CT23 on sheet "DataKlm2". All previous data in range C4:CT23 is over written. What you would like to have ?
I am not too sure how to use your workbook. Could you give a step by step instructions on you you do it today and then how you would like to happen
I am not too sure how to use your workbook. Could you give a step by step instructions on you you do it today and then how you would like to happen