Results 1 to 4 of 4

Locking column, but not row

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    13

    Locking column, but not row

    Hi all,
    What I am trying to do is copy a formula by row and have the following changes.

    When I copy the formula across the next formula should be.

    =(I34-((E15-408)*1.138))*0.1

    and the one after should be

    =(I35-((F15-408)*1.138))*0.1

    and so on and so forth - so the "i" bit should increase in number i34 - becomes i35

    and the "15" bit should increase in letter so "E" becomes "F"
    Last edited by danwhitehouse; 05-19-2011 at 08:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1