Hi PeterGerard73,
Had a look at the input / output files and I can take on the job.
Shall provide Excel macro script to meet your requirement within a day. Shall also provide additional instructions to change price / category variables in the macro.
Let me know.
Regards,
Arul