Automatic Updating Of Master Worbook From Slave Workbooks

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    It is important to be sure that there are no data in columns A:D in the master workbook. As the 2 slave workbooks don't have the same structure, I can't use a loop and there must be two different treatments.

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Sorry for the late reply, a weekend without internet connection :)


    The problem is that all the other columns will have data in them, they might be empty but they might also have data in them. So the point is to have this working without any interference with the other columns, is that possible? I only say this since you stated in you last post that column A:D could not contain any data, and in my original worbook every column from A to AF will contain data.


    I am really making this hard for you aren't I, please ask me if anything is not clear from my side, I will be more than happy to explain!

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Sorry have to written such a nonsense. It really does not matter to have data in columns A:D. Next time I'll Have a coffee before answering ;)

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    I'm sure God will be pleased that his son Jesus is doing such good VBA work. A miracle worker and VBA programmer... one of the same really ::D

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Hi again! Sorry to be bothering you..


    As I said the code works flawlessly but I was wondering if you could help me with adressing some performance issues? Right now my two slave workbooks contain about 3500 rows each that is checked with the code. This takes approximately 10 minutes to do and I was hoping to get the performance up a bit. Do you have any suggestions to where in the code the program might hang or perform poorly?


    Thanks!!

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Hi.
    In the two macros, add the following lines at the beginning of the macro :

    Code
    Application.ScreenUpdating = False
        Calc = Application.Calculation
        Application.Calculation = xlCalculationManual


    and, at the end, add :

    Code
    Application.Calculation = Calc
        Application.ScreenUpdating = True


    At the top of the module, add :

    Code
    Public Calc As Long
  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    excellent! That solved it! Would have done a search on it but I didn't think it would be that easy. Reminds me of the turbobutton I had on my old computer, thanks again! :)

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Hi again! I was hoping you would grant me one last favour. Can you comment your code? I am trying to customize it a bit since there is atleast one more date field that has to be compared in the same manner as what the code is doing right now. But I am struggling with understanding your code so if you could explain it I would be veeeery grateful. If you don't have the time I can always ask a direct question as well, let me know!

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Hope this will be OK. I forgot some things :


    If you have any trouble with it, please, post the workbooks again to refresh my mind.
    Daniel

  • Re: Automatic Updating Of Master Worbook From Slave Workbooks


    Hi Christien,


    Can you please post the final version of this?


    I am solving the same problem like this.


    Thanks,
    Umesh

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!