• 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.

Lookup to left column

Junarkar

Member
Hi

This may be a common question but I couldn't find a solution.

Item code
Req QtyScan QtyBalance
Location
24 | 559
8903742608270​
<<< Fill ITEM CODE here
1000007775234​
5​
2​
3​
Max KLRDC
1000007775311​
4​
1​
3​
Max KLRDC
1000007775369​
4​
1​
3​
Max KLRDC
8903742577866​
4​
1​
3​
Purackal Fashions-Titus-Thiruvalla-Max
1000007771363​
3​
1​
2​
Max KLRDCPending To Scan
1000007775104​
3​
1​
2​
Max KLRDCItem codeReq QtyScan QtyBalanceLocation
8903742478194​
3​
1​
2​
Purackal Fashions-Titus-Thiruvalla-Max
8907352577582​
3​
1​
2​
Max-Sana Arcade-Changanassery
1000007775094​
2​
1​
1​
Max KLRDC
1000007804067​
2​
1​
1​
Max KLRDC
8903742563777​
2​
1​
1​
Purackal Fashions-Titus-Thiruvalla-Max
8907352576752​
3​
2​
1​
Kurisupally Junction-Pala-Max
1000006612865​
1​
1​
0​
Max KLRDC
1000006612982​
1​
1​
0​
Max KLRDC
1000006646722​
1​
1​
0​
Max KLRDC
1000007552347​
1​
1​
0​
Max KLRDC
1000007590218​
1​
1​
0​
Max KLRDC


If the balance is not zero then those details should come in "Pending To Scan".

How to achieve this.
 

vletm

Excel Ninja
Junarkar
This seem to be 'next step' or 'different variation' of Your previous thread
In which I marked those 'not zero balanced' with yellow as below.
Screenshot 2019-11-22 at 18.24.49.png
Of course, I could make Your needed 'Pending To Scan'-text as well as those yellows, almost anywhere You would like ...?
 

Junarkar

Member
Junarkar
This seem to be 'next step' or 'different variation' of Your previous thread
In which I marked those 'not zero balanced' with yellow as below.
View attachment 64106
Of course, I could make Your needed 'Pending To Scan'-text as well as those yellows, almost anywhere You would like ...?
Yes vietm, that is highlighted in Yellow. What I thought was after completing all the scan, if all those bar codes not equal to 0 will come together in the left side, it would be great. I mean applying a filter will also solve the issue. I was just thinking about this.

Thanks
 
Last edited:

vletm

Excel Ninja
Junarkar
Those Yellows
as You would notice
a) rows color will update after EVERY change = live status
b) rows which has balance other than ZERO are always top
as well as
other rows are sorted in order.
If every row will have ZERO balance then NONE yellow.

What would You filter?
 
Top