Reformat Sales Data and Annualized Unit Data

  • Hello JT,

    try the following code:



  • An alternative method which will be faster if Dataset is Large.

    I assume in your actual file you have the Data on a separate sheet so I created a new sheet in your sample file for the data, and named that sheet "Data". I have indicated in the code where you need to make a change if sheet name is not "Data" in your actual file (Line 4 of the code).

    Click the button on the Data 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.

Participate now!

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