Hi susanjane
In case you haven't found them yet, John and Elizabeth's family are in the 1851 Scottish Census in Melrose, Roxboroughshire. I'm not sure if this means they moved from Galashiels or if Melrose is the political location and Galashiels the parish.
John 42, Elizabeth 35, Andrew 9, Nicholas 8, James 6, Isabella 4, John 2 and William 0. Living with them was a servant, Rebekah Hopkirk, 17.
John was an agricultural labourer. The farm appears to be West Houseby(res) or (rne). The writing is not clear.
Regards, Swanny