Busymanjohn
Member
Hi guys, I have a query with some data from a colleague and I can't seem to find a solution. There is a sample file attached. Basically, there is a set of data that shows product being transferred into an area and a few days or so later that material being transferred back out ( positive qty means transferred in, negative qty is transferred back out ). The attached file shows ( All tab ) the data set and the subsequent outcomes in the other tabs ( In, Out, Remainder ) .... In the All tab there is some data highlighted, this is the data that has been transferred into the area, but has not been transferred back out ( due to incomplete work etc ), what we are looking to establish is of the product transferred in, what is still to be transferred out ( or completed ). It would be great if there is a way to do this within the All tab, rather than having to split the data into different worksheets.