change your original refernce from A1 to $A$1. See Help on absolute
versus relative references.

Hope this helps
Rowan

collegeboy28 wrote:
I want to be able to create a entire column in which every cell in the column
pulls a data point from the same cell. If I high light and paste from my
initial, lets say B1 to b2 through b100. It changes the A1 data in each cell
to the next to a2 a3 a4 a5 a6 a7 a8 ect.. i know this is simple but thanks
anyway. Todd