HI
I am working with a data table in excel 2007. Seveal of the columns contain formulas. I am using the resize table icon under table design to add rows to the table. When I resize the table some of the formulas copy to the newly inserted rows, some do not. One formulas that is a vlookup, with an iferror the formula did copy to the new rows, but the iferror was droped only the vlookup copied.
Could someone please explain why this is happening. It happen on some table and not others, so I don't understand what it is I am doing wrong.
Thanks
L
I am working with a data table in excel 2007. Seveal of the columns contain formulas. I am using the resize table icon under table design to add rows to the table. When I resize the table some of the formulas copy to the newly inserted rows, some do not. One formulas that is a vlookup, with an iferror the formula did copy to the new rows, but the iferror was droped only the vlookup copied.
Could someone please explain why this is happening. It happen on some table and not others, so I don't understand what it is I am doing wrong.
Thanks
L
