Data list summary-2D array

  • Hello,


    I am seeking help from experts in this forum to help to resolve the following issues other than Pivot table by using ExcelVBA.


    1. I am getting data "input" list from different users so the column heading is same but located in different column number from each user. ex. Posting date is in column "A", but from different user it can be column "D". same way products and quantity also.

    2. I want to summarize the data as per "Output" sheet.


    Since I know how to tweak the code to suit my requirement, i can use this code to generate daily and weekly report. Thanks

  • Go to Best Answer
  • To find the Column Number for the "Date" column use

    Code
        Dim lColDt As Long
        lColDt = Application.Match("Date", Sheet1.Rows(1), 0)

    Repeat for other columns.


    As your profile shows you are a student I assume that this is an assignment, so the above is the only help I am prepared to provide.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Edited once, last by KjBox ().

  • Post the code you have done so far.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    • Best Answer

    Try the attached file. Click the button on the Input sheet.


    Code assigned to the button:

  • You're welcome

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Here is the code with some comments to help you understand what does what.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Hi another way could be to expand on ...

Participate now!

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