Is there anyway to copy cells with a function and paste them in another cell without the cell numbers changing.
ex. sum(b3:b8) if you would copy that up two cells it would change to sum(b1:b6) or move it over two cells it would change to sum(d3:d8). I need the entire cell structure to remain the same when I copy them.
Thanks
Bookmarks