Is is possible t write a formula that doesn't use a cell address but rather a
relative location ( I cant have a specific cell letter in the formula)

ex. a formula adds the two cells to the left of the cell with the formula

What I'm trying to do is add the formula to a query that gets pasted into
excel. Then i manually type a formula in the last column. I can't hard
code a cell reference because each month there is an extra column so the
formula gets moged over one column each month.
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/