I have 2 worksheets in 2 different books I am trying to share information with. On the 2nd worksheet I am trying to take the information from a column in the 1st worksheet then drag and drop that information down the rest of the column.

What happens is the cell number won't change when dragging and dropping. For instance, the first cell is ='[workbook1.xls]worksheet1!$V$11 and when I drag it down it continues with that exact reference instead of changing it to ='[workbook1.xls]worksheet1!$V$12, etc etc on down.

How can I fix this? Any help appreciated. Thank you.