• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allocation Query

soul.naveen

New Member
Hi Annaya,
Hope your doing Good.

My query is I have mentioned last 3 months Vendor details now this month I want to allocate to different vendors and my Requirement is last 3 months Vendors shouldn't get the repeated allocation. Is this possible to do in Excel using formula or through VBA.

Expecting a positive Update.

Kind Regards
Your Brother !!
 

Attachments

  • Rough.xlsx
    349.5 KB · Views: 3

soul.naveen

You gave some freedom ...
I moved those G ... I -columns is other order.
Usage:
#1 Select the 1st rows the 1st empty cell
#2 Press [ Do It ]-button
#3 Wait until 'animation' runs
#4 If You want to reallocate - then start from #1
#5 You can apply that Month value as You want.
( That 'animation' can take away if needed. )
Notes:
You've allocated some tasks to #N/A.
In this sample, those are as any others You've allocated.
 

Attachments

  • Rough.xlsb
    167.5 KB · Views: 1
Back
Top