Hi Paul,

1. I have given a screenshot of what the input workbook and the master list looks like.

2. "Your approach is not very general purpose, and I think the overall structure needs improvement" Sorry I am new to VBA not sure what you mean by not general purpose. Can you provide insights as to how I can improve the structure?

3. Oh sorry I didn't know how to debug but I have just found out how to. The error is coming from this line: Workbooks.Open ("C:\Users\A9901965\Documents\Jinn\Major Project\VBA Coding\latest\Monthly Tracking Channel Fake.xlsb")
I have changed my percentagecollected to long as well.


Excel sheet given by information company
Capture.jpg

Master List
Capture.jpg