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

R

Rick

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
 
R

Rick

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

A data validation question 1
changing rows *and* columns in automatic formulae 1
Drop down / validation / lookup into the same cell 3
Print Macro w/drop down list 1
drag formula down from columns that go acros 3
How to add cell's reference to cell's content 5
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Multiple items selected multiple dependancies available 3

Top