I can't seem to figure out how to NOT insert rows when using smart markers. I have a very large worksheet with formulas at the column level (aways using current row). I've tried changing the formulas to use the &=&= and have mixed results. It works fine except in a few places where I don't want the formula printed for the first row.
I tried something like this:
A | B | C | D | |
1 | &=data.Field1 | &=data.Feild2 | Total: | Old Way: |
2 | &=&=A{r}+B{r} | =A2+B2 | ||
3 | =A3+B3 | |||
4 | =A4+B4 | |||
5 | =A5+B5 |
But column C & D don't start at row 2, they will start after the data is loaded.
I'd like to just leave the hard coded formulas and have the designer NOT move my cells (it even updates my name ranges which is a another problem, but I'll save that for a different topic). Cam this be done???
Any help or ideas would be great!
thanks,
Jason