Please bare with me as I explain this one...
On the Preview worksheet, cell F24 - this field needs to show values on the List worksheet, column F.
This information will change on the fly, so I need some type of trigger that will show the correct information.
Cell F24, on the Preview worksheet - needs to look at column G on the List worksheet, find the cell with a value of "1", then return the value in the cell to the LEFT.
Thank you in advance for your help!