Select the cell the data validation is working in... and then select the cells you want to copy the validation to.. go to Edit|Paste Special and select Validation... the A1 should autoupdate to the corresponding cells you pasted into.