Prev: How can I allow users to sort a protected table using dropdowns?
Next: Entering Formula - Cannot select cell as it is hidden by formula
From: Jim on 25 Mar 2010 00:58
I'm using Excel 2007.

I have created a table with customer numbers, names, status, and several
other columns. I named this table including the header row
'Mortgage_Pay_Table'. Excel automatically named the table EXCLUDING the
header as 'Table4'. This table has 37 rows excluding the header numbers from
100 to 136 in the first column. This table is formatted correctly for visual
appearance, ease of data entry, and printing.

I am trying to make a near 'duplicate' of this table on another sheet that
would be hidden to generate raw data for analysis with a pivot table. This
new table is called 'Table5' by Excel. In the first row & column of the
table I have put in '=Table4[Mortgage No]'. In the second column, first row
I put in '=Table4[Mortgage Name]. All of the rest of the columns in the
first row I entered the same format for the data I wanted from Table4. Excel
automatically copied these formulas down the different rows and all the data
transfered correctly except I'm missing the first row from Table4. The first
row in Table5 returns a value of 101 rather than 100, and the next column
also shows the data from the second row of Table4 rather than the first.

Why doesn't it show the first record?

JIM

 | 
Pages: 1
Prev: How can I allow users to sort a protected table using dropdowns?
Next: Entering Formula - Cannot select cell as it is hidden by formula