locked
Best way to make this into a macro RRS feed

  • Question

  • Hello everyone, I am attempting to create a macro to make this data more usable and cut down on the time required to analyze this file. I need to Pull labled A, B, C and D and then having the values of the quantity next to ABC with each line being a separate break. I have attached an image 1 and how I would like it to look after. I have been having to copy and paste and then transposing the data in Qty. The date runs over the top of all the data since it is the same dates for each lines. Image 1 is how it comes and Image 2 is how I need helping the macro to create.

    raw

    result

    Monday, February 3, 2020 1:34 PM

All replies

  • Hi JM0616,

    I hope you will share your Excel file.
    Otherwise, we can hardly make a macro, since it would take too much time to input data as yours.

    Regards,

    Ashidacchi -- http://hokusosha.com

    Tuesday, February 4, 2020 2:38 AM
  • Hi JM0616,

    I hope you will share your Excel file.
    Otherwise, we can hardly make a macro, since it would take too much time to input data as yours.

    Regards,

    Ashidacchi -- http://hokusosha.com

    File


    Tuesday, February 11, 2020 5:44 PM
  • What I would do is have a simple formula to bring the header info A-C down along side the data rows.


    Then you could use a pivot table to lay out the info as you have shown-

    If you also need to give different people a summary- this would let you filter on Customer / sales rep etc

    Wednesday, February 12, 2020 12:27 PM