>>Are you trying to make K5 and Q5 both also say =A55? If so, you nee to change it in E5 to say =$A$55, and then copy and paste and it will maintain that reference to =A55 as you move it around to other cells.
>
>That works.
>
>Thanks

The $ locks that portion. So you can use $A29 to always use column A, but the row will change. Or A$29 to always use row 29, but the column will change. And $A$29 to lock both.