Hi I have a problem which I don't think is possible in excel but thought I'd throw it out there as this site has some amazing members who have wowed me in the past.
I have two sheets one has data which i want pulled onto the 2nd sheet but in a very particular way. the cell has two numbers in it...