Hi all
once again I am puzzled and need to pick the brains of more knowledgeable people!
I have a fairly complex workbook which I am developing for tracking and predicting football scores. I have pasted data into one particular sheet which has home team, home score, away score and away team in that column order. When I query the data from another worksheet, the home team and home score are read correctly, but the away score and away team are not; however when I TYPE the same data in it is read correctly. All of the data was entered by the 'paste value' method as I wanted to keep the destination formatting. Clearly there is some sort of format issue going on, but I can't suss it out.............
all suggestions gratefully received!
Thanks
Paul
once again I am puzzled and need to pick the brains of more knowledgeable people!
I have a fairly complex workbook which I am developing for tracking and predicting football scores. I have pasted data into one particular sheet which has home team, home score, away score and away team in that column order. When I query the data from another worksheet, the home team and home score are read correctly, but the away score and away team are not; however when I TYPE the same data in it is read correctly. All of the data was entered by the 'paste value' method as I wanted to keep the destination formatting. Clearly there is some sort of format issue going on, but I can't suss it out.............
all suggestions gratefully received!
Thanks
Paul
