Afternoon, I have data validation in a cell which has a list of strings, 1 of which references another cell. I would like to drag this across so the formula updates to a3, b3, c3 etc. However currently even if the data validation is a relative reference, when dragging across it stays at a3.
Anyone know how to auto full the data validation??
Thanks!
Bookmarks