none
Automatic update from source file RRS feed

  • Question

  • Sir,

    I have an Excel file with 3 sheets viz; 1-INP, 2-AVG & INP (2) 

    I manually enter all the data in INP (2) with 19 columns this is the source sheet,

    and i want a vba or excel formula to automatically transfer the info from INP (2) to INP sheet 

    and from sheet named INP to sheet named AVG which is basically a summary sheet.

    I could have attached the file here, but there is no option for that, kindly let me know how to attach the file for your reference if needed.

    Thanks,

    Raaj.

    Monday, January 29, 2018 12:50 PM

Answers

All replies

  • Hi Raaj306,

    You had asked," i want a vba or excel formula to automatically transfer the info from INP (2) to INP sheet 

    and from sheet named INP to sheet named AVG which is basically a summary sheet."

    Try to refer code below.

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim sht1, sht2 As Worksheet
    Set sht1 = Sheets("INP1")
    Set sht2 = Sheets("AVG")
      sht1.Range(Target.Address).Value = Target.Value
      sht2.Range(Target.Address).Value = Target.Value
      
    End Sub
    
    

    Output:

    Further, You can try to modify the code based on your requirement.

    Reference:

    Worksheet.Change Event (Excel)

    Let us know, If you have any further questions.

    We will try to provide you suggestions to solve the issue.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 30, 2018 6:04 AM
    Moderator
  • No Sir, this code does not work on the huge file i have, it wud be better if you could take a look at my file.

    kindly let me know how to send you the file.

    thanks,

    Raaj.

    Tuesday, January 30, 2018 7:23 AM
  • Hi Raaj306,

    You can try to upload your file any free file hosting website.

    Then you can share the link of your file here.

    We will try to visit the link to get the file.

    Then we will try to check your file and try to provide you further suggestions to solve the issue.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 31, 2018 12:48 AM
    Moderator
  • Hi,

    I have uploaded my sample file in below link.

    thanks,

    https://volafile.org/r/g4uz17vc

    Wednesday, January 31, 2018 8:55 AM
  • Hi Raaj306,

    I try to visit the link and I find that You had uploaded a .XSLM file.

    But when i download the file, File get downloaded as .XLSX File.

    As a result, When I try to open the file. Excel shows that file is corrupted.

    I suggest you to again try to upload file or any other site and share the link.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 31, 2018 9:41 AM
    Moderator
  • Thank you Mr. Deepak,

    I got the VBA code from Mr. HansV this morning and it turned out to be perfect.

    Thanks a lot for him and thank you too for your effort.

    Best Regards,

    Raaj.

    Wednesday, January 31, 2018 11:23 AM
  • Hi Raaj306,

    From your last post I can understand that your issue is solved now.

    This thread is still open.

    I suggest you to mark your own last reply as an answer.

    It will help us to close this thread.

    This thread will remain open until you mark the answer.

    So please take appropriate steps to close this thread.

    Thanks for your understanding.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 1, 2018 12:49 AM
    Moderator