I have a validated cell on a worksheet that gets its data from the cell
immediately to its left. In my case cell "F15" gets its data from cell "E15".
My column has 99 more cells that I want to drag the validated cell down and
still get each newly validated cells data from the cell to its left. My
current formula is: =INDIRECT(E15). When I drag this cell, all of the newly
validated cells still get their data from "E15". I can't figure out what
punctuation to use and I can't do each cell one at a time because I need to
be able to re-drag the columns if I need to replace existing data on the
sheet. Any help will be greatly appreciated. Thanks, Rick