VBA to calculate and display the output quantity in corresponding week number table

[Vassen]

Need help. In my excel worksheet I have the following info:
Column BM - Start Output Weeknum
Column BN -End output Weeknum
With below VBA, In columns BO to DN,I display the weeknum as follows: Weeknum 1 in BO , 2 in BP and so on.

Please Login or Register  to view this content.

I have in column BF the total quantity, and in Column BG the weekly output, thus I need to modify the above VBA to display in appropriate weeknum column (BO to DN representing week 1 to 52) the output quantity instead of the weeknum, example of expected result as follows:
BF3 = 4000 = quantity ( Not a constant - varies in each row)
BG3 = 1500 = output per week ( Not a constant- varies in each row)
BM3 = 1 = start output weeknum (Not a constant - varies and obtain with a formula after data input- subject to change on same row - not to remove formula when applying VBA)
BN3= 3 = end output weeknum (Not a constant - varies and obtain with a formula after data input- subject to change on same row - not to remove formula when applying VBA)
RESULTS in BO3 (week 1)= 1500, BP3 (Week 2) = 1500 and BQ3 (Week 3) =1000
Should display figure (in appropriate weeknum column) in BF if BG > BF

I remain at your disposal if more clarification needed.
Thanking you
Vassen

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[Vassen]

Hi antoka05,
Waoh, really fantastic, it works as I wanted . Thanks a lot.
Cheers
Vassen