I'm trying to link every cell in 3 columns to corresponding cells in a different worksheet. While I am able to pick up the first cell reference just fine, when I drag the reference down the column in each of the 3 columns, instead of picking up cell reference in a sequence (i.e. c1, c2, c3 etc) the information just gets copied (i.e. c1, c1, c1 ) for all the cells in that column.
Is there a way to automate this instead of manually changing the cell references. I have about 200 rows for each of the 3 columns.