Home » Forums » Open Source Learning Center » Question and Answer

Remaining Qty to be distributed as they falls on date

Submitted by abuharvey on 12 March, 2015 - 08:35

Please find attached Image I need to distribute Per day Qty in adjacent cells automatically with formula

Thanks and regards

Remaining Qty to be distributed as they falls on date
‹ Match Strings in 2 columns copy the one match in one sheet and exclude the one found in other sheet Linking different files ›
»
Nick's picture

Firstly, congratulations on

Submitted by Nick on 13 March, 2015 - 10:02.

Firstly, congratulations on writing a very good forum question.. It's really clear what you need here.

you probably could write an excel formula to do this, but it would be incredibly ugly.

recommend writing this in VBA as your cols are dependent on your start date and finish date.

It raises a few more questions:
- what do you do if everything is in the past ?
- do you want to remove old entries (before today)

Nick

»