VBA Macro Column Rounding & Cleanup

Hello,

I created a macro that cleaned up a spread sheet into two columns. My first column (A) contains a list of names and my second column (B) contains weights. Although column B is percentages, I cannon have the cell formatted as a percentage, so I converted the column to "General". I need help with two issues. Also, I am taking 98% of Column B.

1) I need column (B) to stop with the last name displayed in t column A. Each A cell corresponds to B, so I don't want to have B running all the way down to B200. Column A range can fluctuate, so I need B to react to A dynamically.

2) I need column B to round to two decimal places. Rounding up will be fine. I need to have it in the same "General" format.

I have attached the spread sheet and will post my code below.

Please Login or Register  to view this content.

Any help would be much appreciated

Please Login or Register  to view this content.

Do you mean like this?

Please Login or Register  to view this content.