Quick Excel question.

[Anonymous]

I'm almost positive some people in here know how to use excel and could tell em why i am getting this error.

I understand that this isn't really the purpose of this forum but no one would answer my questions on the excel.forums.com site.

Data!$A:$A, Data!$B:$B, Data!$D:$D, Data!$F:$F, Data!$H:$H

I need a table of these columns, I am using a pivot table to make them. When i have selected them and press the finish button

\!/

[m_woolf · Accepted solution]

I presume Excel doesn't like the data ranges being non-contiguous

[Anonymous]

Yea I eventually figured that.