Can I drag a validated cell down the column w/a different input/ro
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 |
Can I drag a validated cell down the column w/a different input/ro
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! "Rick" wrote: 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 |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com