Consulting

Results 1 to 7 of 7

Thread: Template

  1. #1
    VBAX Regular
    Joined
    Dec 2009
    Posts
    15
    Location

    Template

    Hi,
    A few years ago I made a template to create an financial report from it.
    But sometimes I want/have to adjust (add or remove) a couple of rows.
    Then I have to be very carefull that I don't alter the rows beneath that point, or the formulas wont work anymore, because above the adding or removing, formulas pick up values from the lower part (which are shifted by adding rows)
    Hope this makes sense..
    Is there a way to still add some rows and not altering the cell name further down the sheet, which value is picked up, in the beginning of the sheet?
    I.e:
    Row 20 to 24 have values say
    one
    two
    three
    four

    I want to add five and six which alters row 30 to 32. Now the cell on row 10 won't read cell 32 because it's set to read 30.
    Pff I suck at explaining.. i know.. sorry

  2. #2
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    326
    Location
    Hi HV_L!
    You can enter a special symbol at the end of the line and use the formula to determine its position.

  3. #3
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    3,805
    Location
    With a little bit of creativity you can design a worksheet with named ranges and then refer to them by name rather than by cell references
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Regular
    Joined
    Dec 2009
    Posts
    15
    Location
    Quote Originally Posted by 大灰狼1976 View Post
    Hi HV_L!
    You can enter a special symbol at the end of the line and use the formula to determine its position.
    Hi, can you explain? Show?

  5. #5
    VBAX Regular
    Joined
    Dec 2009
    Posts
    15
    Location
    Quote Originally Posted by Aussiebear View Post
    With a little bit of creativity you can design a worksheet with named ranges and then refer to them by name rather than by cell references
    Hi,
    So I can call a cell with a sumed total a name, then it doesn't matter where it's exact location is? I can refer in another formula to this name?

  6. #6
    VBAX Regular
    Joined
    Dec 2009
    Posts
    15
    Location
    Just tried this and think that's the answer..
    Thanks

  7. #7
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    326
    Location
    Hi HV_L!
    I gave a very very simple example of my suggestion.
    Attached Files Attached Files

Posting Permissions

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