Copy/paste data validation in Google Spreadsheets
<p>I feel a bit silly not being able to figure this out. So this is the data validation I have set up:</p>

<p>Cell Range: Journal!J2</p>

<p>Criteria: List from a range - Journal!W2:X2</p>

<p>Cell Range: Journal!M2</p>

<p>Criteria: List from a range - Journal!Y2:AA2</p>

<p>This is great in my first row. I create another row and I'd like it to update all of the '2' to '3'. The cell range updates correctly, but the criteria does not, and I can't figure out an easy solution other than going in and updating it manually.</p>

<p>I've tried copy/paste as well as paste special -> data validation.</p>

<p>I know something like $Y$2 would fix the row/col but that's the opposite of what I want. I guess I'm wanting to maintain the relative formula vs it being an absolute formula?</p>