Forum Discussion

Conwayhd's avatar
Conwayhd
Copper Contributor
Feb 25, 2019

No if then STOP

I have two pages that I am referencing between.  On the first page I have a list that constantly changes.  I have one cell that will have a number between 1 and 140, say cell V9. And 18 other cells ,...
excel
Formulas and Functions
Macros and VBA
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Feb 26, 2019
Could you post a sample file to help explain what you are trying to achieve.

Thanks

Wyn
  • Conwayhd's avatar
    Conwayhd
    Copper Contributor
    Feb 26, 2019

    I am attaching a simple file to maybe help you understand what I trying to do.

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Feb 26, 2019
      Thanks, would you be able to explain a bit more about what you want the formula in column H of sheet 2 to do.

      It sounds like you want to keep the result in a cell even after the source data changes? This isn't possible without copy pasting as values.
      • Conwayhd's avatar
        Conwayhd
        Copper Contributor
        Feb 26, 2019

        That's what I was afraid of.  I appreciate the help though.  Thank you.

Resources