Hi There, we need to update the macro you've developed before. Now, we're gonna have two different warehouse so the AU data will be similar to UK. See RAW file attached as example.
The only change to the macro will be when filtering available stock by 0, you will need to do it for both MELB and SYD columns. Let me know if you need me to clarify further!