Zoe has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Data Table
Why, when creating a Data Table, do the column input cells actually refer to rows and the row input cells actually refer to columns?
RE: Data Table
Hi Zoe
The column in put cell refers to the column of information in the data table. The data is stored in a column of rows.
The logic is a bit a backward, and that is just the way it is programmed in excel.
Regards
Richard