Need help writing a macro for work that can loop through reference numbers

I have attached a screencap of an example source table that I am trying to write a macro to manipulate each day. Starting conditions are that I have data in column A and B. Column A would be reference numbers that may be on one line, or more likely, on multiple lines repeating with varying counts. Column B is the weight associated with each line. I would need a macro that could loop through column A, determine if the ref number has changed, and then calculate/populate column C. Column C is the % of the total weight for the unique reference number. I have illustrated this in the table using column D. This is taking me incredible manual effort to complete right now and I do know VBA, I just don't know how to loop a variable range in this case and I'm sure there is someone on this forum that could write a smooth function in their sleep. Help or advice on where to start is greatly appreciated.

Thanks, Tom

Capture.JPG

Please don't illustrate it in a picture of a workbook, illustrate it in sample workbook ... the one you made a picture of.

There's nothing that can be done with a picture of a workbook, other than recreate it, and I have no plans to do that.

You don't really need a macro, more likely a simple formula copied down ... so a macro could just drop in the simple formula.

Regards, TMS

The formula:

Formula:

Please Login or Register  to view this content.

The code:

Please Login or Register  to view this content.

And see the updated example.

Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

The formula: C2:

Formula:

Please Login or Register  to view this content.

The code:

Please Login or Register  to view this content.

Good. Please mark the thread solved as described in post #6.

Regards, TMS