marreco
12-26-2012, 04:38 PM
hi
Every day I get more than 50,000 items in the array to be distributed to the branch, but it is becoming increasingly difficult, because the list is growing.
I do not have even a little knowledge of VBA and macro to automate this routine, I sent it to a link to download the file in Excel called "planning", within that file contains three worksheets, the first of which is "ORDER OF THE MATRIX" the second is called "PASSING tHE BRANCH" and the third is "result_manual" which is only demonstration of how they would do manually.
Just let little item, because it would be difficult to download the spreadsheet at the link, but I want it to do is this:
1 - In the spreadsheet ORDER OF THE MATRIX, he located the items and quantities that distributes this column "Quantity Supplied" corresponding worksheet in "ORDER OF THE MATRIX" in worksheet "PASSING THE BRANCH", according to this column that the "quantity to be supplied "the worksheet" PASSING tHE BRANCH "so that it does not exceed this amount, the result of the distribution should put it in the column" amount distributed "(worksheet" a BRANCH TRANSFER ").
2 - If there is any amount that exceeds the amount to be provided in spreadsheet "PASSING THE BRANCH" he put in the column next to a warning as "disagreement", "surplus" and so on.
3 - If after the distribution, and had completed the amount specified by the matrix, but no balance left to complete the remainder of the item located at zero and it completed in the next column show "Missing" (in "result_manual", the items are so populated with the number zero).
thank you
Every day I get more than 50,000 items in the array to be distributed to the branch, but it is becoming increasingly difficult, because the list is growing.
I do not have even a little knowledge of VBA and macro to automate this routine, I sent it to a link to download the file in Excel called "planning", within that file contains three worksheets, the first of which is "ORDER OF THE MATRIX" the second is called "PASSING tHE BRANCH" and the third is "result_manual" which is only demonstration of how they would do manually.
Just let little item, because it would be difficult to download the spreadsheet at the link, but I want it to do is this:
1 - In the spreadsheet ORDER OF THE MATRIX, he located the items and quantities that distributes this column "Quantity Supplied" corresponding worksheet in "ORDER OF THE MATRIX" in worksheet "PASSING THE BRANCH", according to this column that the "quantity to be supplied "the worksheet" PASSING tHE BRANCH "so that it does not exceed this amount, the result of the distribution should put it in the column" amount distributed "(worksheet" a BRANCH TRANSFER ").
2 - If there is any amount that exceeds the amount to be provided in spreadsheet "PASSING THE BRANCH" he put in the column next to a warning as "disagreement", "surplus" and so on.
3 - If after the distribution, and had completed the amount specified by the matrix, but no balance left to complete the remainder of the item located at zero and it completed in the next column show "Missing" (in "result_manual", the items are so populated with the number zero).
thank you