+ Reply to Thread
Results 1 to 2 of 2

VBA To Transfer Data(value only).

  1. #1
    Registered User
    Join Date
    06-15-2011
    Location
    Penang,Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    VBA To Transfer Data(value only).

    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
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,447

    Re: VBA To Transfer Data(value only).

    Hi azmizarinah and welcome to the forum,

    You have 57 modules of code behind this worksheet. There are overf 850 lines of code. This is not a trivial question you ask.

    I'd guess that the event code behind your B2JT worksheet is working to remove or hide data on your DataKim2 worksheet. (If that is what is really happening.) I'm not ready to trace your code to find out. The Event code Fires when a change is done to the sheet B2JT and in the code is a Timer event to do other things. Set a breakpoint in your VBA code behind the B2JT sheet and single step instructions to see what is happening.

    See http://www.cpearson.com/excel/Debug.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1