vba script for % price change over the period

Hi folks,

I got this vba script from the experts in the thread "New worksheet based on multiple worksheets". This is pulling out the relevant information from the multiple sheets against the unique transactions. Please refer in the sample data attached.

I wish to add one more in the "output" sheet as % price change over the transactions date. This should come out from the "cost" column in the "transactions" sheet, example: for first transaction "12345678" it should be (4 - 2.14)/2.14 = 87% for the period of 13/01/2020-09/09/2020. Hope I am clear with the need. I have tried to modify the code accordingly but messed it up and couldn't got anything at the end, then thought of reaching out to the experts again. TIA...

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

Please Login or Register  to view this content.

Thanks AlphaFrog for replying. It is absolutely working fine where the prices have been increased over the time but it is not where the prices have been decreased, example, for item #23456789, the % change should be (21-32)/32 = -34% instead of 52.4%. Please refer in the attached.

Thanks man, superb...this is exactly what i need

Regards,
Abhi