Advanced paste function

From: gseltz (gps15_at_yahoo.com)
Date: 02/23/04


Date: Mon, 23 Feb 2004 11:51:12 -0800

Is there an advanced paste function availible that when pasting a cell reference will advance x number?
For example you reference A1 on a different work*** and copy that cell. If you paste that cell directly below the inital reference it will reference the same work***, cell A2. Is there a way to paste this cell so it will reference cell A1+#. If # = 5 the cell will reference A6. Please help!!!!!