Reply to thread

Message: [QUOTE="Biff, post: 3599072"] Hi! That would look like this: ................A.........................B............... 1.......Supplies............Entertainment...... 2..........100........................50.............. 3..........200........................60.............. 4.......................................................... 5..........300.......................110............. Sheet2: ................A........................B................ 1.....Monthly Totals.............................. 2.......................................................... 3..........Supplies.............Formula(...).... 4.....Entertainment .........Formula(...).... In B3 of sheet2 enter this formula and copy down as needed: =INDEX(Sheet1!A$5:B$5,ROWS($1:1)) Now, the above table will look like this (if done properly): ................A........................B................ 1.....Monthly Totals.............................. 2.......................................................... 3..........Supplies................300............. 4.....Entertainment ............110............. A more complicated way to do it (or, if the headers are not in the same order, this method should be used): Enter this dormula in B3 of sheet2: =INDEX(Sheet1!A$5:B$5,MATCH(A3,Sheet1!A$1:B$1,0)) The result will be the same. Biff [/QUOTE]