Depends what route you plan taking?
You go M6 as far as Preston, then cut through the Dales via M65 and some minor roads and it will taker you near to as much sport climbing as you would want; Malham, Gordale, Kilnsey, Giggleswick etc etc atc are all concentrated in that area (best route would be dependant on preference of crag) Then go A59 or something to A1 all the way to Edinburgh.
Or if you want to go M6 all the way up you can turn off onto A65 at Kirkby, head te Settle area(ish) find your crag of choice, climb, then get back on the M6 and carry on.