Hi, I have browsed this forum and tried to use some of the ideas you guys have mentioned but I'm still having problems getting transposing the names of teams/players onto a summary sheet. The odds are moving across, but all I get is an #VALUE! error when I do the same with team names...
I tried formatting these as general from text but its not changing a thing. Any ideas?
Excel Team Names Problem
Can you provide any more details?
Which market are you linking to? And what formula are you using to get the team names in a summary sheet?
And what do you mean by 'Transposing'? This term has got an actual specific meaning within Excel and relates to switching columns of data to rows and vice-versa. Is this what you are trying to do?
http://office.microsoft.com/en-gb/excel ... 24502.aspx
Which market are you linking to? And what formula are you using to get the team names in a summary sheet?
And what do you mean by 'Transposing'? This term has got an actual specific meaning within Excel and relates to switching columns of data to rows and vice-versa. Is this what you are trying to do?
http://office.microsoft.com/en-gb/excel ... 24502.aspx