The calculated distance (air line) between Andover and Sheffield is approximately 150 miles respectively 241 kilometers.
By car or train, the actual journey to Sheffield is certainly longer, as only the direct route (as the crow flies) between Andover and Sheffield has been calculated here.