extending cell

  1. B

    VBA - changing references for formula based on a given criteria

    Dear All, I am struggling with this issue for a while. I have to build a macro that changes formulas references according to a given set of criteria (basically moving the reference if it refers to external factor and staying at the previous year if it internal) <tbody> A B C D E F G H I 1...
  2. C

    Prevent Auto Increment when extending cells down

    Hi everyone, I have a spreadsheet that contains a date column (formatted as date). When it gets populated, users have a tendency to drag that value down to fill some of the rows beneath it. When they do, the date auto increments. Is there a way to prevent this other than asking all my users to...

Some videos you may like

This Week's Hot Topics