I'm fairly new in VBA for excel and wondering if someone can help.

I have a spreadsheet which provides me with list of bids broken down in
monthly revenue. The colomn count varies based on date range selection.

I also have a column that holds a ratio which identifies the bid's win
probability. Each record must hold the full monthly opportunity value but
the monthly total sum is only based on the win probability ratio.

Example:
(Full Monthly Value)
WinProb% Jan Feb Mar Apr
10% 100 100 100 100
20% 0 100 100 100
30% 0 0 100 100
40% 0 0 0 100

Total 10 30 60 100

If you need more info please let me know,

Greatly appreciate the help,

Norm