Hmmmmm. OK. I'm trying to copy the cells to the right of the first cell with CY in it (including the first cell). Not underneath it. So, in this example, I want to be able to copy cells ED:5 through EV:5 and paste those values starting at Y:3 on the Master Program List tab and going to the right.

My problem is that I think the cell where I first see CY will change from time to time, so I can't choose a specific cell but I have to search for the first one.

Sorry if this is confusing.