Feb 25 2019 01:38 PM
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 ,E28:e36, that will have varying numbers related to the first cell. On the second page I am trying to reference the first page to collect the entered numbers. It has a row for each number 1-140 and the other 18 cells on the same row. I can use an If then, with a circular reference, that way when V9 changes it will not update the other 18 cells after that, but there has to be a better way. I know there is not an if then stop function, but is there a way to stop once the if then statement is true, and once it changes to keep the true number? Any help would be appreciated.
Feb 26 2019 12:21 AM
Feb 26 2019 10:15 AM
I am attaching a simple file to maybe help you understand what I trying to do.
Feb 26 2019 02:27 PM
Feb 26 2019 02:35 PM
That's what I was afraid of. I appreciate the help though. Thank you.