Can I drag a validated cell down the column w/a different input/ro

G

Guest

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
 
G

Guest

Never mind! I am such a dope! It was working all along! I was just dragging
a cell that I had selected every time so the selected data kept repeating!
And this cost me a night's sleep!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation accepts illegal entries when one spreads values 5
How do I control where the input message appears? 2
How To Have A Cell Be Blank If... 2
Concatenate Results from a Validated Drop Down List 2
A data validation question 1
Drop down arrow location for validated data 1
change the font colour in a validated drop-down list? 1
How do I stop entry in one cell if another cell is occupied?? 15

Top