On 1/4/15 10:43 AM, Gordon Burgess-Parker wrote:
Yes - add $ to the cell references in the formula - e.g., A2 becomes $A$2. That means you can move the formula anywhere you want but it will still reference A2...
I know that but that is what I am trying to avoid. I would have to change it to copy and then change it back after I move it so I can drag the next year.
I am looking for a way to copy and paste the existing formulae without changing them. This may not be possible but I thought I would check. If I can't do that I will have to investigate to see what the fewest number of cells I actually must change are and take it from there.
-- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
