Extract chronological data

  • Re: Extract chronological data


    Do you mean that the records of both buy and sell are stacked one below the other? The problem is the past data is already built up over past many months. Henceforth I can ensure that 'new data' are placed one below the other for easy use in future. Is there a solution for the current data which is available only in this format?

  • Re: Extract chronological data


    .
    .
    Running the Macro Recorder will result in this:



    Usually not the most efficient means of coding but it gets the job done.


    See attachment and click button.

  • Re: Extract chronological data


    I got it. Thanks a lot. Will henceforth structure data in such a way that final reports are easily achieved by few commands rather than such a long code. Sincerely appreciating your effort to help me Roy, Logit.

  • Re: Extract chronological data


    If the data is correctly entered and stored then you would probably be able to use a PivotTable, see the attached example. You can experiment with different layouts of the PivotTable


    As always the recorded code is clumsy and much of it can be deleted or edited. The data range used should be made dynamic in the code and the selecting is unnecessary.

Participate now!

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