i need the range of the row to populate, example, A1 is a reference number 1012-1013, B1 is a name, C1 is a address, D1 is a phone number, E1 ...., etc.. next row A2 is a different reference number with different info and so on,
i want to use the reference number or name to be able to pull the specific info to a different sheet,