Hi,
I basically want to export the information from the workings sheet to the office sheet based on the lowest volume highlighted in red, then the highest number in the orange cell if the volumes are equal.
I've highlighted the values in green (+volume highlighted in red) that I want to export to the working sheet for this example. As you can see it's currently importing the wrong set of data based on this example.
I hope this makes sense.
Thank you
Bookmarks